Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

How to quickly find which cell is linked to other cells

Posted by DaJiang on June 04, 2001 2:28 AM

When I created a large excel file, some of its cells are linked to other cells in another excel file. Now I want to remove these links because everytime I open it, I am always prompted wheather or not to update the linked information. This is quite boring. I just cannot find which cell links to an external cell.

Thanks

Re: How to quickly find which cell is linked to other cells

Posted by Mike H on June 04, 2001 3:38 AM

Re: How to quickly find which cell is linked to other cells

Posted by Mike H on June 04, 2001 3:45 AM

Sorry I posted a blank reply by accident!
The workbook that is linked may be found by using Edit Links and then there is an option to open the source file. In order to find the cell(s) in the book that are linked you can hihlight all cells in the first sheet of the book and then link all sheets by clicking on their tabs while Shift is pressed. Then use Edit Find to look for the name of the book(s) that the book is linked to.

Re: How to quickly find which cell is linked to other cells

Posted by Tuc on June 04, 2001 7:59 AM

If you cannot go to the Links sub menu off the Edit menu and change the source back to yourself, then here is the Fastest way. Go to Microsoft MSDN site and search for Q Article q188449. Get the Delete Links Wizard. It works.

Tuc

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.