Update Links to current Directory??
 

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

How about using Edit|Links?

There's an option to change the source.

Pulcue wrote:

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

--

Dave Peterson