ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Stopping "Query Refresh" messages (https://www.excelbanter.com/excel-discussion-misc-queries/132566-stopping-query-refresh-messages.html)

fmistry

Stopping "Query Refresh" messages
 
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.


Vergel Adriano

Stopping "Query Refresh" messages
 
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" wrote:

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.



fmistry

Stopping "Query Refresh" messages
 
On Feb 27, 3:43 pm, Vergel Adriano
wrote:
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" wrote:
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.- Hide quoted text -


- Show quoted text -


Thank you. I shall try out your suggestions.



All times are GMT +1. The time now is 09:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com