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?
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?