V Look up Link problem accross different workbooks

[Jen]

Hi,

I have used Vlook up across different workbooks. This has worked fine. The
problem arises when I resave the source workbook to another name and place.
The Vlook up function then actually defers from the original workbook and
links to the new work book. Is there any way I can "lock" the formulae so
that it remains linked to the original workbook?

Suggestions are very much appreciated.

 

[Allllen]

All you have to do is close the workbook with the links in it at some moment
before you resave the source file to a different name and place.

The other option is to close both workbooks. Then do the rename using
windows explorer.