Is it possible that there is a workbookopen event handler that is supposed to
be checking the autorefresh but isn't and is just refreshing?

Peter Richardson

"Neily" wrote:

Hopefully someone here can help me out. I'd be most appreciative.

When I open one of my Excel spreadsheets, I get a window popping up headed
"Query Refresh".

The details are along the lines of....
This workbook contains queries to external data that refresh automatically....
If you trust the source you can enable automatic query refresh....

and then there are buttons to "Enable automatic refresh" and "Disable
automatic refresh"

I do have queries in the workbook but in the Data Range Properties of each,
none are set to automatic refresh. I've never seen this message before and
can't for the life of me stop it from popping up everytime I open the
spreadsheet.

Any ideas how to stop it anybody?

Thanks