I have a set of 6 workbooks all in a single directory. Each of the
workbooks are linked, pulling data from other workbooks.
When I copy the entire directory to a new location(folder), the links
still try to go to the older folder. Here is an example formula:
The current folder is "folder1"
=VLOOKUP(A2,'C:\folder1\[Roster.xls]Sheet1'!$A$1:$E$10,2)
If I move to "folder2", the formula still points to "folder1"
Is there a way to edit the formulas to reference the current folder?
Thanks for your help
- Pulcue
--
Pulcue
------------------------------------------------------------------------
Pulcue's Profile:
http://www.excelforum.com/member.php...o&userid=24654
View this thread:
http://www.excelforum.com/showthread...hreadid=382368