prevent excel from warning about external files

We have spreadsheets that will load various external documents, mostly PDF's and DWG files, when certain buttons are clicked upon. Each time, Excel warns us about the external files, and it's an annoyance, we don't want to be warned, these files are at a trusted location on our local network. We've been through the trust center settings many times, and nothing we do seems to fix this problem, any suggestions?

sc_20230724060423.png

Hey,

Here are some other methods you can try-

1. Certain settings relating to external content and warnings may be enforced by the IT department if you work in a corporate setting and your computer is managed by a Group Policy. You might need to get help from your IT support in such circumstances.
2. From the Properties Window, unblock files:
   Right-click on a file after saving the external files to a reliable location.
   "Properties" can be chosen from the context menu.
   Find the "Security" section at the bottom of the Properties dialogue box.
   If a "Unblock" button is present, click it to release the file.
3. The "Enable All Data Connections" option should be enabled.
   Navigate to the "File" menu in Excel.
   The Excel Options dialogue box will appear when you click "Options."
   Select "Trust Centre" in the left pane, and then click the "Trust Centre Settings" button.
   Pick "External Content" in the left pane of the Trust Centre dialogue box.
   The "Enable all data connections (not recommended)" checkbox must be selected.
   To make the changes, click "OK".