prevent opened file from updating links

trusty1

Board Regular
Joined
Aug 8, 2005
Messages
50
Hi,

I have a file that is linked into 2 very large files. I have designed a macro that updates the main file by opening & closing the 2 files.

Now I need to prevent the user updating the links from the popup when the file is loaded. Due to the size of the files this could take many minutes.

thanks
trusty
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Sub Auto_Open()
Application.AskToUpdateLinks = False

End Sub

This will suppress the dialog box asking on opening the file that asks to update links

I hope this what you need
 
Upvote 0
Another maybe easier way would be, to go to EDIT-LINKS-STARTUP PROMPT and select "dont display alert and dont uodate links"
 
Upvote 0

Forum statistics

Threads
1,224,317
Messages
6,177,850
Members
452,810
Latest member
jeffrey0409

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
Back
Top