MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.


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

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.

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.