Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping the Update Links Message
How do I stop the Message "do you want to update links" coming up when I open a workbook?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping the Update Links Message
Application.AskToUpdateLinks=False
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Matty S" wrote in message ... How do I stop the Message "do you want to update links" coming up when I open a workbook? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping the Update Links Message
In Excel 2002 and later there is an option under the Edit=Links menu
In all versions you can go into tools options under the Edit tab, uncheck Ask to Update Automatic links. However, this causes the links to be updated without prompt (which may be acceptable. If you don't want them updated and don't want to be prompted, then in versions earlier than xl2002, there is no remedy except to use a dummy file that has macro code to open the workbook with the parameter UpdateLinks set to zero. On the offhand chance that you do not intentionally have any links and you would like to get rid of the links, see Bill Manville's free addin - Findlink.xla which can be downloaded from Stephen Bullen's site: http://www.bmsltd.ie on the left, choose the MVP page. -- Regards, Tom Ogilvy "Matty S" wrote in message ... How do I stop the Message "do you want to update links" coming up when I open a workbook? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping the Update Links Message
Thanks Bo
But where do i put thate code, under worbooks open? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping the Update Links Message
Just before you open the workbook, then reset afterwards.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Matty S" wrote in message ... Thanks Bob But where do i put thate code, under worbooks open? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping the Update Links Message
That code won't work in Workbooks_Open if you mean to put it in the workbook
that causes the prompt. The prompt appears before any code is run. That changes the setting for Excel itself, same as doing it manually as I explained - also with the same effect, that the links are updated without prompt. -- Regards, Tom Ogilvy "Matty S" wrote in message ... Thanks Bob But where do i put thate code, under worbooks open? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot Update Links Message is False but Always Appears | Excel Discussion (Misc queries) | |||
Excel Links don't update error message even if it really does upda | Excel Discussion (Misc queries) | |||
Suppress Update Links Message | Excel Discussion (Misc queries) | |||
Can I avoid annoying Update Links message | Excel Discussion (Misc queries) | |||
Disabling the Update links message | Excel Programming |