Quote:
|
Originally Posted by dalypen
Really need help with this, last year i was able to import the toteboard data from brisnet with the get data from webpage with no problem using excel 2010. Last week i wanted to try it out but could not get the connection made. I logged in selected the import arrow even tried it on a new sheet.Still Not working.I did hear a few months back that brisnet change how they let users import there data (Is this True ?). I would love for someone to help me with this.fyi I did many searches in here and only found old post from the way I did it last year.Is excel 2013 the problem? or is it my dumb old ass. Thanks  |
I tried this and was able to get it to import into Excel 2013. In Excel under the Data table choose "From Web" - enter the web address of the tables from Supertote you want (I had to modify them slightly from the HTML source) - Select Go - Click the Import Button - in properties you can select the refresh rate.
However, each time the table refreshes for whatever reason it's hiding the columns and each time I need to manually go unhide them? The table is there, it's updating, but it's just hiding the columns on each update?
