Archive of Mr Excel Message Board

Back to Links in Excel archive index
Back to archive home

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?

Re: Linked File

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.

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

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.