software

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 amp; 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


www.oaltd.co.uk/MVP/Default.htm
download
FindLink.zip
it is an add-in the helps you find links--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=517299In Lotus 123, there is a function File-gt;User Setup-gt;123 Preference-gt;File
locations-gt;Workbook files. By changing the workbook files to X:\Folder A, the
link will automatically follow the link and extract information from
Data\A1\1.xls located in X:\Folder A

Is there a similar function in Excel? I have tried
Data-gt;Option-gt;General\Default file locations and changing the location to
X:\Folder A. But, it won't update automatically. It will stop at X:\Folder,
and not go into sub-folder Data\A1. [Note: I can't specify the sub-folder
because, A.xls also link to sub-folder A2, A3, etc.]
quot;davesexcelquot; wrote:

gt;
gt; www.oaltd.co.uk/MVP/Default.htm
gt; download
gt; FindLink.zip
gt; it is an add-in the helps you find links
gt;
gt;
gt; --
gt; davesexcel
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=517299
gt;
gt;

I'm so careless, the link actually is incorrect. I should have copy from C:
and paste to Server: instead of a new folder in Server. The link can't read
the intermediate folder.quot;SOSquot; wrote:

gt; In Lotus 123, there is a function File-gt;User Setup-gt;123 Preference-gt;File
gt; locations-gt;Workbook files. By changing the workbook files to X:\Folder A, the
gt; link will automatically follow the link and extract information from
gt; Data\A1\1.xls located in X:\Folder A
gt;
gt; Is there a similar function in Excel? I have tried
gt; Data-gt;Option-gt;General\Default file locations and changing the location to
gt; X:\Folder A. But, it won't update automatically. It will stop at X:\Folder,
gt; and not go into sub-folder Data\A1. [Note: I can't specify the sub-folder
gt; because, A.xls also link to sub-folder A2, A3, etc.]
gt;
gt;
gt;
gt; quot;davesexcelquot; wrote:
gt;
gt; gt;
gt; gt; www.oaltd.co.uk/MVP/Default.htm
gt; gt; download
gt; gt; FindLink.zip
gt; gt; it is an add-in the helps you find links
gt; gt;
gt; gt;
gt; gt; --
gt; gt; davesexcel
gt; gt; ------------------------------------------------------------------------
gt; gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=517299
gt; gt;
gt; gt;