MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Linked File


Posted by falcon on January 31, 2002 1:03 PM

I have copied an excel file, modified it, eliminated (I think) all links to the old file. When I open it, it still shows linked to the old file name. How do I get rid of this?


Posted by mike on January 31, 2002 1:42 PM

Did you try:

From the Excel Menu, select EDIT/LINK and then select "Change Source" and select the new workbook.

Sometimes the Change Source button is inactive, in which case you need to go into Design mode first by selecting Alt+F11 and selecting the Design button from the VBA Toolbar.


Posted by anno on January 31, 2002 1:58 PM

see http://support.microsoft.com/default.aspx?scid=kb;EN-US;q188449 [nt]