The question to update links is pitched before any macros are run.

--
Regards,
Tom Ogilvy

"MikeJoyner" wrote in message
...
I am trying to set up a spreadsheet that needs to automatically update the
links that it contains without asking. This spreadsheet will be used on
other computers on the LAN, so just changing the settings for Excel won't
work. I am thinking that I need a macro that will run when the
spreadsheet
is opened. Thanks.