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.
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,016
Office Version
  1. 365
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.
 

Forum statistics

Threads
1,144,698
Messages
5,725,821
Members
422,643
Latest member
elwayfan446

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top