I have excel sheet which has lots of links to other workbooks. The links
need to be updataed every week.

For example: a cell linked to "c:\0626\[xx_0626.xls]'sheet0626'!A3"
should be updated to "c:\0703\[xx_0703.xls]'sheet0703'!A3". I tried to
use the "replace" function to replace "0626" with "0703". It works if
there are only a few links to update. However, it takes forever if
there are hundreds of links. I don't know why the replace function is
so slow in Excel. I did try to turn off the auto calculation, but it
doesn't help. Anybody knows a faster way to do such update?
Thanks a lot!


--
hiwan99
------------------------------------------------------------------------
hiwan99's Profile: http://www.excelforum.com/member.php...o&userid=24936
View this thread: http://www.excelforum.com/showthread...hreadid=384722