Update Links to current Directory??

  • Thread starter Thread starter Pulcue
  • Start date Start date
P

Pulcue

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
 
How about using Edit|Links?

There's an option to change the source.
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
Click to expand...
 
Back
Top