Moving files

[srburk]

I have 30 Excel files located on a shared network drive.
I have several reports that pull information from these individual files.
I need to put these individual files into another folder for archiving.
I still want the reports to link to the files --- links need to be updated.

What is the best way to move these files and have their links update on the report files?

 

[drsarao]

Some tools are described here:
http://forums.techguy.org/business-applications/613001-solved-moving-linked-excel-files.html