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

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.

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

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.