Graphics

 View Only
  • 1.  Excel Datalinq data missing

    Posted 04-19-2023 10:03

    I've been populating stats with Excel sheets in the xls. format and i haven't had an issue with it until yesterday where some number stats aren't populating into datalinq and I have tried changing the formatting of the cells from generic to number and also to text and it still hasn't populated for me. Usually that does the trick for me but im lost.



    ------------------------------
    Aaron Paladino
    ------------------------------


  • 2.  RE: Excel Datalinq data missing

    Posted 04-20-2023 11:00

    I'm not sure how to directly address address your problem, but I will say that I have been using .xls docs for data for a long time and have just recently started having compatibility problems where the file won't save correctly and other issues. So I switched to .xlsx documents. I was told that as long as you use the 32 bit version of Excel and turn on legacy sharing, it should work in datalinq. It has been working well for me  since the switch, so I would recommend trying that.



    ------------------------------
    Matt Finlayson
    Brigham Young University
    ------------------------------



  • 3.  RE: Excel Datalinq data missing

    Posted 04-20-2023 17:12

    Have you pressed the "Test Connection" button on the Datalinq configuration to see if data is coming through? Also make sure you have you have the Share Workbook checkbox checked.



    ------------------------------
    Omar Reyes
    ------------------------------



  • 4.  RE: Excel Datalinq data missing

    Posted 04-23-2023 18:12
    Aaron - 

    It's been a while for me, but I remember having an issue similar to this and the cell I was trying to link to was not in the table.

    Also, you can try copy and paste from a similar cell into that one that is not working.

    Just a few thoughts.

    --
    Anthony Bordignon
    XPression Graphics Designer | Stadium

    1901 W. Madison St.
    Chicago, IL 60612
    M: 630.890.2287
    watchstadium.com I  Welcome to the game – sign up now for updates





  • 5.  RE: Excel Datalinq data missing

    Posted 05-09-2023 13:09

    Hello all, changing the format over to xlsx has solved the issue thanks all for the help



    ------------------------------
    Aaron Paladino
    ------------------------------