I have a link from one spreadsheet to another

I have the "Don't display the alert and update links" option chosen yet it
still displays an alert when I open the file.
This is annoying because I am using a VBA program from Access to open many
spreadsheets and change the link.
Any ideas on how to stop the alert?

many thanks

Rod