S
SOS
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
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