Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stopping display of "FALSE" | Excel Discussion (Misc queries) | |||
Stopping the "This removes the subtotal and sorts again." notifica | Excel Discussion (Misc queries) | |||
"Web Query" refresh failure | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Query parameter "refresh when value changes" doesn't refresh - why | Excel Discussion (Misc queries) |