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.
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.
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.
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 60612M: 630.890.2287watchstadium.com I Welcome to the game – sign up now for updates
Hello all, changing the format over to xlsx has solved the issue thanks all for the help