|16 Nov 2010||#1|
| || |
Excel 2010 Auto Refresh Problem
I am currently trying to create an excel document that will utilise the stock levels on our website and update in real time as I'm creating a map of our warehouse and racking that will allow anyone to find out where a certain product is and how much stock there is of said product.
I have set up an auto refresh system that will keep the stock levels correct already and that's fine. The problem is that our website admin section, where the excel file gets the stock levels from, requires a username and password to access. I can login intially through excel but once I close the excel file and reopen it, it logs out and therefore no longer has access to the stock levels. When I click refresh all the information disappears and is replaced by the boxes that say 'Username' and 'Password.' Is there any way that I can get excel to stay logged into our website so that it can always access the information it requires?
Thanks for any help.
|My System Specs|
|Similar help and support threads for2: Excel 2010 Auto Refresh Problem|
|Display doesn't auto-refresh (sometimes)||Graphic Cards|
|problem saving excel spread sheet in 2010 to 97-2003 format||Microsoft Office|
|Formatting Excel 2010, Excel 2003||Microsoft Office|
|Outlook 2010 EXCEL (64 bit) problem||Microsoft Office|
|Explorer windows auto refresh then don't auto refresh. Why?||Software|
|Auto Refresh IE8||Browsers & Mail|
|How to disable folder auto refresh after rename/delete?||Customization|
|Our Sites ||Site Links ||About Us ||Find Us |
© Designer Media Ltd
All times are GMT -5. The time now is 01:09 PM.