| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
V Look up Link problem accross different workbooks
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. -- Jen |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
V Look up Link problem accross different workbooks
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. -- Allllen "Jen" wrote: 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. -- Jen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I merge and link workbooks into one summary workbook? | Excel Worksheet Functions | |||
| link workbooks | Excel Discussion (Misc queries) | |||
| How do I link data from 11 workbooks to 1 | Excel Discussion (Misc queries) | |||
| how do i link workbooks | New Users to Excel | |||
| How to link cells in diff't workbooks that don't contain formulas | Excel Discussion (Misc queries) | |||
Hybrid Mode
