Stopping "Query Refresh" messages

[fmistry]

I have a spreadsheet which at one time used auto update to get data
from another external data source. I have stopped using this function
but I still get the "Query refresh" message asking me whether I want
to "Enable automatic refresh" or "Disable automatic refresh". How can
I get rid of this mesaage since I am not using auto refresh anymore?

Also, there is another message from Excel (again when I open the file)
saying that there are links to other data sources and whether I want
to "Update" or "Don't Update". I want to get rid of that message too

What do i do to et rid of these useless messages? Thank you.

 

[Guest]

The "query refresh" message is explained in this link:

http://support.microsoft.com/kb/248204

You'll also find in the link what you need to do to change that behavior and
what options you have.

As for links to other Excel files, go to Edit->Links to see which Excel
files your file is linked to. You'll have the option to break those links
from the pop up.

 

[fmistry]

The "query refresh" message is explained in this link:

http://support.microsoft.com/kb/248204

You'll also find in the link what you need to do to change that behavior and
what options you have.

As for links to other Excel files, go to Edit->Links to see which Excel
files your file is linked to. You'll have the option to break those links
from the pop up.







- Show quoted text -

Thank you. I shall try out your suggestions.