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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
The question to update links is pitched before any macros are run.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting data from a spreadsheet without opening? 2
Run Macro Upon Entering Data into Cell/s 3
Macro to generate powerpoint slides 43
Update Password Protected Links 1
Update Links and Essbase Retrievals 6
Recording a macro 3
Macro Security & Automatic Link updates 3
Macro Help.... 2

Back
Top