View Full Version : Cache problem on web-based Excel file


PearlGI
08-17-2006, 04:41 AM
Hope this is the right forum - seems to be a web problem rather than an Excel problem.

I have an Excel file (file A) that links to data from another Excel file (file B) contained on a web-server. The data in file B is updated weekly and usually I have no problem with updating the linked data from file B to file A.

However, if I try to update file A from my office desktop I usually get out-of-date data from file B! I'm guessing that this is caused by the file B being cached and our web-access at the office is not checking for a newer version.

Is there any way of overcoming this problem without having to go via our IT dept?

I've even tried typing the address of file B direct into IE and then trying Ctrl-F5 to force a cache refresh, but this has no effect on file B.

(If it makes a difference, I'm the owner of the website that file B resides on, so I can make changes to that if needed)