Adding Trusted Links to Spreadsheet Hyperlinks

[steveh8204]

I have a couple of spreadsheets which regularly require opening other files/folders so have created hyperlinks to them in the spreadsheet. Is there a way to stop the "Microsoft Excel Security Notice - This location may be unsafe, do you want to continue?" box from appearing every time?

They are mainly local files but a couple on a shared network. I've tried looking at the settings in the Trust Center but none seem to do it. I even added the link as a Trusted Location but that doesn't work.

I'm a bit wary of changing a few of the settings that are "not recommended". Would have thought there would have been a "always trust this link" button in the warning box similar to when you open a network document really.

Any help appreciated in advance etc etc.