linking to another excel file on my server

Question

File A has data linked to another excel file B on my server. When ever I save file B under another name call it file C my data links are now set to File C and I want them to remain on file B.

Is there a way to keep my data links pointing to File B.

Jeff

deleted · Answer

Instead of renaming the source file (from B to C), move&nbsp;the source file (file B)&nbsp;to a different folder.

jeffrey hooper · Answer

Thanks, so just drag and drop to a new folder without renaming. &nbsp;Correct?&nbsp;

deleted · Answer

That's right Jeffrey. Let me know if that doesn't help.

deleted · Answer

Hi Jeff,&nbsp;Using File --&gt; Save As to make a copy of the source workbook results in external references in the dependent workbook to pick up the&nbsp;name of the newly made source workbook.&nbsp;You can get rid of this by simply making a copy of the source workbook using CTRL + C, and the renaming it by double clicking the file name or pressing F2; instead of using File --&gt; Save As to rename the workbook.&nbsp;Or you can use the earlier solution: moving the source workbook to a different folder.Hope that helps..!&nbsp;Thanks :)Balakrishna

Forum Discussion

linking to another excel file on my server

4 Replies

Resources