thisworkbook.open

james potter

New Member
Joined
Aug 15, 2005
Messages
45
When I am opening an excel file I get the messagebox to updatelinks or not. Is there a code and what is the code to give excel the answer to not update at startup? I think this code needs to be placed by private sub workbook open. I have seen some answers but they all are opening another file when there is already one open.

For example
Code:
Workbook.open (filename), updatelinks
Workbooks.Open FileNmae:= " ", UpdateLinks:=xlUpdateLinks

And also what is the code for update the links of the activeworkbook.
Thanks for all help so far.
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,984
Which version of Excel are you using?

Try going to edit --> links --> startup prompt if that option is available to your version.
 

Joe Was

MrExcel MVP
Joined
Feb 19, 2002
Messages
7,539
"Don't ask whether to update links when I open any workbook, and update links automatically:"

For the current user only, and affects every workbook opened. Other users of the workbook are not affected on shared workbooks. This option also affects the links to other programs.

On the Tools menu, click Options, and then click the Edit tab.

Clear the Ask to update automatic links check box.
If the box is cleared, the links are automatically updated, and no prompt is displayed.



"Don't ask to update links for this workbook, and let me control whether links are updated:"

Warning: This option affects all users of the workbook. If you choose to not update links, and not to prompt the users about it, users of the workbook will not know the data is out of date!

On Edit menu, click Links.

Click Startup Prompt.

Select the option you want.

Note: You will still be notified if there are any broken links.
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
To add to what Oaktree has said, I don't believe you can disable it via Workbook_Open, as the prompt executes before the event. So Oaktree's solution is the one to go for (if possible).

Richard
 

james potter

New Member
Joined
Aug 15, 2005
Messages
45
I see the problem. I will try a different method to tackle this problem.
Thank you all for your replies.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,992
Messages
5,545,375
Members
410,679
Latest member
rolandbianco
Top