I have a folder containing files which are interlinked. Example

C:\Folder A\Data\A1\1.xls
C:\Folder A\Worksheet\A.xls

Certain cells in A.xls is linked to 1.xls. I copy & paste Folder A to server
H:

When I open A.xls from server, the cell is linked correctly
H:\FolderA\Data\A1\1.xls. However, it cannot be updated. It will prompt for
location of the file, from My Document. How can make sure the link is
correct. I can't update source individually as the linkage is massive (more
than 300 files).

Pls help