Change Path names in copied work book
 

We have a series of linked work sheets that in the formulas use
information from other work sheets. These other work sheets appear in
the path name. We save this file each year and create a new work book.
When we copy the work book and rename to year 2 the references still
point to year one. We have some very large worksheets and cannot open
all at one time. Any thoughts on how to change the path name in the
formulas without doing it line by line. There are thousands of entries.


--
jheaney
------------------------------------------------------------------------
jheaney's Profile: http://www.excelforum.com/member.php...o&userid=16401
View this thread: http://www.excelforum.com/showthread...hreadid=277743

Search and Replace
Search for old path or filename in formulas and replace with new path or
filename for entire worksheet.



"jheaney" wrote:


We have a series of linked work sheets that in the formulas use
information from other work sheets. These other work sheets appear in
the path name. We save this file each year and create a new work book.
When we copy the work book and rename to year 2 the references still
point to year one. We have some very large worksheets and cannot open
all at one time. Any thoughts on how to change the path name in the
formulas without doing it line by line. There are thousands of entries.


--
jheaney
------------------------------------------------------------------------
jheaney's Profile: http://www.excelforum.com/member.php...o&userid=16401
View this thread: http://www.excelforum.com/showthread...hreadid=277743

Go to Edit menu, Links. You can change the external links to whatever
new folder you would like.
Hope this is a bit easier for you.


--
Scott1523
------------------------------------------------------------------------
Scott1523's Profile: http://www.excelforum.com/member.php...fo&userid=6298
View this thread: http://www.excelforum.com/showthread...hreadid=277743