VLOOKUP How do you keep the pathway linked to original source? in Excel General Questions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              Jen 11/9/2006 8:49 AM PST   Question   Hi, I have used vlook up across different workbooks. All is well until I resave the source as a version 2 in a different folder. I would like the vlookup to remain the same, linked to first workbook - but I find that it adjusts itself to search within the new workbook I have created. Is there anyway I can "lock" the vlookup so that it is not affected by pathway changes or can you only use Vlook up on worksheets within the same workbook? Suggestions are much appreciated - Thanks! Jen     Was this post helpful to you?         Reply |   Top           Duke Carey  11/9/2006 8:56 AM PST   Save & close the workbook with the VLOOKUP formula BEFORE saving the source workbook with new name & path "Jen" wrote: > Hi, > > I have used vlook up across different workbooks. All is well until I resave > the source as a version 2 in a different folder. I would like the vlookup to > remain the same, linked to first workbook - but I find that it adjusts > itself to search within the new workbook I have created. Is there anyway I > can "lock" the vlookup so that it is not affected by pathway changes or can > you only use Vlook up on worksheets within the same workbook? > > Suggestions are much appreciated - Thanks! > > Jen     Was this post helpful to you?         Reply |   Top           CRIS 5/7/2008 5:25 PM PST   "Duke Carey" wrote: > Save & close the workbook with the VLOOKUP formula BEFORE saving the source > workbook with new name & path > > "Jen" wrote: > > > Hi, > > > > I have used vlook up across different workbooks. All is well until I resave > > the source as a version 2 in a different folder. I would like the vlookup to > > remain the same, linked to first workbook - but I find that it adjusts > > itself to search within the new workbook I have created. Is there anyway I > > can "lock" the vlookup so that it is not affected by pathway changes or can > > you only use Vlook up on worksheets within the same workbook? > > > > Suggestions are much appreciated - Thanks! > > > > Jen     Was this post helpful to you?         Reply |   Top           Allllen 11/9/2006 8:57 AM PST   Answer   at the moment when you resave the source file, make sure you have the file with the vlookup CLOSED before you do that. It only "knows" to adjust itself if it is open when you resave the other file. or you can close both files, and use windows explorer rather than excel to copy or rename the source file. -- Allllen "Jen" wrote: > Hi, > > I have used vlook up across different workbooks. All is well until I resave > the source as a version 2 in a different folder. I would like the vlookup to > remain the same, linked to first workbook - but I find that it adjusts > itself to search within the new workbook I have created. Is there anyway I > can "lock" the vlookup so that it is not affected by pathway changes or can > you only use Vlook up on worksheets within the same workbook? > > Suggestions are much appreciated - Thanks! > > Jen     Was this post helpful to you?         Reply |   Top           Mohammed 5/10/2008 4:22 AM PST   Thank u very much for usfull information if you have any information in the futher pleasc send it to me on mu email. thank you again "Mohammed' "Allllen" wrote: > at the moment when you resave the source file, make sure you have the file > with the vlookup CLOSED before you do that. It only "knows" to adjust itself > if it is open when you resave the other file. > > or you can close both files, and use windows explorer rather than excel to > copy or rename the source file. > > -- > Allllen > > > "Jen" wrote: > > > Hi, > > > > I have used vlook up across different workbooks. All is well until I resave > > the source as a version 2 in a different folder. I would like the vlookup to > > remain the same, linked to first workbook - but I find that it adjusts > > itself to search within the new workbook I have created. Is there anyway I > > can "lock" the vlookup so that it is not affected by pathway changes or can > > you only use Vlook up on worksheets within the same workbook? > > > > Suggestions are much appreciated - Thanks! > > > > Jen     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies