I am trying to update a worksheet that has multiple links to other workbooks.
The only problem is that the file locations are not in 2006\Dec\Frame Weld
Cell 6 Dec 06.xls\, they need to be changed to read 2007\Jan\Frame Weld Cell
6 Jan 07.xls. Is there any way I can do this? The formula is too long to be
typed in the find and/or replace section. PLEASE HELP!!! (Is there an easy
way to do this without having to go through each and every cell in the
worksheet?)

You can perform an find/replace all by pressing Control F.
--
http://HelpExcel.com




"LaToya" wrote:

I am trying to update a worksheet that has multiple links to other workbooks.
The only problem is that the file locations are not in 2006\Dec\Frame Weld
Cell 6 Dec 06.xls\, they need to be changed to read 2007\Jan\Frame Weld Cell
6 Jan 07.xls. Is there any way I can do this? The formula is too long to be
typed in the find and/or replace section. PLEASE HELP!!! (Is there an easy
way to do this without having to go through each and every cell in the
worksheet?)

I know I can perform the find/replace, but my problem is that the formula is
so long that the entire line can't fit in the space. EG....the formula is
about 4 lines long, and it has 2006 throughout it and Dec throughout the
entire lines. When I tried to only replace 2006, it took me back to file
find, and I had to click the correct drives and folders to get to the right
one. The workbook is too large for that.

"galimi" wrote:

You can perform an find/replace all by pressing Control F.
--
http://HelpExcel.com




"LaToya" wrote:

I am trying to update a worksheet that has multiple links to other workbooks.
The only problem is that the file locations are not in 2006\Dec\Frame Weld
Cell 6 Dec 06.xls\, they need to be changed to read 2007\Jan\Frame Weld Cell
6 Jan 07.xls. Is there any way I can do this? The formula is too long to be
typed in the find and/or replace section. PLEASE HELP!!! (Is there an easy
way to do this without having to go through each and every cell in the
worksheet?)

You only need to replace portions at a time.
--
http://HelpExcel.com




"LaToya" wrote:

I know I can perform the find/replace, but my problem is that the formula is
so long that the entire line can't fit in the space. EG....the formula is
about 4 lines long, and it has 2006 throughout it and Dec throughout the
entire lines. When I tried to only replace 2006, it took me back to file
find, and I had to click the correct drives and folders to get to the right
one. The workbook is too large for that.

"galimi" wrote:

You can perform an find/replace all by pressing Control F.
--
http://HelpExcel.com




"LaToya" wrote:

I am trying to update a worksheet that has multiple links to other workbooks.
The only problem is that the file locations are not in 2006\Dec\Frame Weld
Cell 6 Dec 06.xls\, they need to be changed to read 2007\Jan\Frame Weld Cell
6 Jan 07.xls. Is there any way I can do this? The formula is too long to be
typed in the find and/or replace section. PLEASE HELP!!! (Is there an easy
way to do this without having to go through each and every cell in the
worksheet?)

Edit|Links|Change Source
Might be a way.

LaToya wrote:

I am trying to update a worksheet that has multiple links to other workbooks.
The only problem is that the file locations are not in 2006\Dec\Frame Weld
Cell 6 Dec 06.xls\, they need to be changed to read 2007\Jan\Frame Weld Cell
6 Jan 07.xls. Is there any way I can do this? The formula is too long to be
typed in the find and/or replace section. PLEASE HELP!!! (Is there an easy
way to do this without having to go through each and every cell in the
worksheet?)

--

Dave Peterson