- Report as spam Discussion - Post 21 of 66
- Better solution
-
After spending a day on trying to get around this, this is what I've learned.
When Excel executes a web query, it stores the query in the 'internet temporary files' folder. If the queries are of a certain type and too many accumulate in the folder, the 'file could not be accessed' error starts appearing.
Because this folder is 'special' i.e. a virtual folder, it is next to impossible to clear it out programatically. So you have two alternatives that work for me. The first is to manually clear out the internet cache through IE. The second, more surprising solution is if you reduce the space allocated to the cache through the IE advanced options to, say, 8M, the error, for me at least, goes away.
Before I could do 50 queries before the error appeared. Now, with IE open on a default page (unknown if needed) and Excel running, I'm going through 750 records and still going without error. It seems the cache limit auto-clears the web query caches sufficiently to stop the error from happening.
Bizarre bug. Hopefully Microsoft will look at how web queries are working and either fix the bug or provide the option to turn off the caching. - Posted: 08/15/2007 @ 02:38 PM (PDT) (edited 08/15/2007 @ 02:40 PM (PDT))
-
-
- Leon Tribe
- Job Role: IT Consultant
- Location: Neutral Bay, New South Wales
- Member since: 07/31/2001
-
- View Profile | Send Message
Print/View all Posts | Subscribe to this Thread
SponsoredWhite Papers, Webcasts, and Downloads
- Volume Activation Deployment Guide Microsoft This guide describes Microsoft? Volume Activation deployment concepts ... Download Now
- Getting personal with business continuity: Five critical success factors in overcoming workforce disruptions IBM Corp. An event that disrupts your business, no matter how limited or broad in ... Download Now
- Driving business agility through SOA connectivity and integration IBM Corp. This paper describes some of the business and IT issues that enterprises ... Download Now
White Papers, Webcasts, and Downloads
- The Compelling Case for Conferencing Microsoft Organizations are looking for ways to improve their businesses while ... Download Now
- Unrivaled support from Novell, now available for Red Hat Novell If Linux is going to power your mission-critical applications, you'd ... Download Now
- The Three Ps of Evaluating Managed Network Services Qwest Communications To reduce costs and keep IT resources focused on the core business, more ... Download Now
Browse by Tag
- networking
- hardware
- programming
- software
- windows
- linux
- it management
- career
- security
- off-topic
- feedback
- project management
