The Case of the Invisible Invokers of "Automatic Refresh" Dialog!

[ScottSutherland]

I have an Excel workbook which (among other things) queries Yahoo & other financial data to get stock, currency, option, etc. quotes. There must be an old web query still hiding someplace that has the "Refresh every xxxx" checked, because when I open the file, I always get the dialog box that asks me if I want to enable automatic refresh. I don't. In fact, I don't use that technique anymore (too CPU-intensive for little value in return). I have other similar workbooks that don't pop up that dialog box when I open, so there must be something left (somewhere) in that first file that still "wants" periodic refreshes. I have gone through everything I could SEE (and even large clumps of blanks where I thought something MIGHT once have been), and I can't find the offending web query.

Anybody have any ideas how I can find what's asking for the enable? And/or is there some way to GLOBALLY turn off automatic data refresh? I do it all manually by pushing the "Refresh All" button now. I don't need anything to be automatic.

Thanks!

Scott <><

[ScottSutherland]

Can anyone help me with this?

Thanks!

Scott <><

[Mark@Work]

I'm unfamiliar with using web queries, however...
Could you not simply use the EXCEL Find facility?
select Edit from the toolbar, then Find... (or press Ctrl+F)
ask it to find "refresh" and away you go.

[ScottSutherland]

Whatever is triggering this is not something I can readily see. I've had lots of web queries come and go on my "quotes" page, and I suspect there's some old query lying around somewhere for some long-expired option which will NEVER exist again. When it tries to retrieve the data via the query, it fails, and there's no new (visible) data to see. So there's nothing on the sheet to search for. It's a query that never completes.

Scott <><