when open workbook, change existing link to another workbook

  • Thread starter Thread starter Chrissie Frisbee
  • Start date Start date
C

Chrissie Frisbee

Upon opening a workbook, I would like the file to
immediately automatically change the current existing link
(which varies depending on where the user saves the
workbook) to another location/workbook (which varies same
reason as before).

I do not know how to retrieve the existing link
information and change it to the new location but I do
have the new location declared and ready to use.

Any help I would be most grateful

Kind regards
chrissie.
 
If you're prompted to update links when you open it, you could answer no and
then use Edit|links to change them.

If you answer yes to update the links and the linked file isn't available, then
xl will prompt you much like the Edit|Links dialog.

But why bother updating them at all if you know you're changing them???
 
Back
Top