Automatically confirm "Don't Update" for external sources warning message

BlueSkys

New Member
Joined
Mar 14, 2005
Messages
12
I have about 20 files and each of them have links to external sources.
I open all the files together.
Each file is opened with the following warning massage:
"This workbook contains links to one or more external sources that could be unsafe. If you trust the links, update them to get the latest data. Otherwise, you can keep working with the data you have"
I then need to click "Don't Update" and then the next file is opened with the same message...

I don't want to update the link to the external sources of these files and I want all the files to open instantly without the need to click "Don't Update" for each.

I tried the Trust Center options but no solution so far. Any Idea?
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Go to Data --> Connections --> Edit Links --> Startup Prompt
and select 'Don't display the alert and don't update...'
 
Upvote 0
Go to Data --> Connections --> Edit Links --> Startup Prompt
and select 'Don't display the alert and don't update...'

Thank you Tetra201.
For sure this solve the issue for a specific file.
Unfortunately I get these files on a daily basis from outside users and I can't instruct them to do that.
I could change the Startup Prompt for each file myself every day but this will be time consuming...
So I'm looking for a solution for all files and not per file.
 
Upvote 0

Forum statistics

Threads
1,223,228
Messages
6,170,875
Members
452,363
Latest member
merico17

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