How do I set up a macro to automatically update links upon openin.

[MikeJoyner]

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.

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

"MikeJoyner" <MikeJoyner@discussions.microsoft.com> wrote in message
news:04C3065C-81D7-44DF-931A-2484E73F3596@microsoft.com...
> 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.