LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jen Jen is offline
external usenet poster
 
Posts: 119
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I merge and link workbooks into one summary workbook? Sylvia Excel Worksheet Functions 3 July 31st 08 09:55 PM
link workbooks Syahira Excel Discussion (Misc queries) 6 July 13th 06 11:04 AM
How do I link data from 11 workbooks to 1 Swift Excel Discussion (Misc queries) 1 June 26th 06 09:03 PM
how do i link workbooks mickey s New Users to Excel 1 September 27th 05 01:31 AM
How to link cells in diff't workbooks that don't contain formulas Gustin512 Excel Discussion (Misc queries) 2 September 21st 05 11:26 AM


All times are GMT +1. The time now is 07:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"