Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Excel 2010 Auto Refresh Problem

16 Nov 2010   #1

Windows 7 Professional
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 SpecsSystem Spec


 Excel 2010 Auto Refresh Problem

Thread Tools

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 10:28 AM.
Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33