I have inherited a excel file from a predecessor. Somewhere in the file there is a web query trying to pull data from a web page that no longer exists. As a result, I get an error message every time I open the file: “Unable to open http:_______. The internet site reports that the item you requested could not be found.”
The problem is I can’t find the file where the web query is, in order to correct the problem or delete it. I have already tried:
1. Find (by formulas, values, and comments)
2. Links
3. Macros
The file is large enough that even after some searching I can’t find anything. And going to every cell in the file and then seeing if Data > Import External Data shows something just seems impossible.
Does anyone know how to search for web queries in an Excel file? Microsoft support was of no help. Thanks!
(We have Excel 2003 here.)
