What I do...
Go to TOOLS--OPTIONS--CALCULATION and change it to manual. Then go into
FIND/REPLACE (ctrl+h), then type in the old file location, and the new file
location. click on REPLACE ALL.
The go back and turn the calculation back to automatic. It will still take
a while, but it shoudn't take 2 hours.
I work in Excel 2003. I have a large file with about 3000 lines. It links
to another file that is about the same size (7800KB). I often move them into
new directories or change the file name. I change the source on the target
file using edit links change source. It takes 2 hours to update (I have a
relatively new laptop with 1000mb memory and a 715 processor).
I notice that the update button is always on automatic, and the manual is
grey, so I am not able to change from automatic update to manual. My
computer gets locked up for this time. I would like to change the links more
quickly. Is my problem this automatic update? Why can't I change it to
manual? Would changing to manual solve my time problem?