Archive of Mr Excel Message Board

Back to Links in Excel archive index
Back to archive home

Linked Files

Posted by jacob on January 02, 2002 8:46 AM

In one of my spreadsheets the Edit - Links menu shows that the spreadsheet is linked to another spreadsheet. However, the menu does not allow me to delete the link, only to change the link.

To my knowledge I do not have any links in any of the cells of my spreadsheet. How do I eliminate this file link?!? Thanks

Re: Linked Files

Posted by Ken on January 02, 2002 10:41 AM

Hi Jacob,

One way to delete a link is to go to the Excel menu, go to
Edit|Links|Change Source| then direct the link right back to the open workbook with
the link. Click OK. This will point the link right back to the original
workbook and in effect wipe out the link. However be careful any
formulas dependant upon another workbook will be deleted.

Thanks
Ken

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.