Updating Links

E

Edgar Thoemmes

Hi

I am having trouble with turning off the promt for
updating links.

I have tried the following commands but I still get a
message re updating links.

I think they automatically update the links but I want the
program to not Update links.

Application.AskToUpdateLinks = False
ActiveWorkbook.UpdateLinks = False

TIA
 
T

Tom Ogilvy

In versions of Excel prior to xl2002, you either update automatic links
without prompt, or you get prompted. The only way around this is to open
the workbook with code since the open method has an argument UpdateLinks
which can be set to not update links. In xl2002 and later, there is an
option in the Links menu under the edit menu.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Link Continue prompt 2
Update Links Stopping Workbook_Open Routine 1
update links (ignore previous post same title) 2
Update Links prompt 1
How to update all links before re-calculation for macro? 1
workbook_open 4
Update links 2
Suppress Update Links dialog AND don't update links 5

Top