MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How can I quickly find a cell that is referenced to another workbook

Posted by Brian P on December 08, 2000 10:17 AM

Somewhere I in a book of 8 worksheets I have a cell that is referencing another workbook. How can I find it quickly? I have tried to trace dependants and precedants, but I don't know from that whether it's referencing another workbook or just another worksheet.

Brian P

Posted by Loren on December 08, 2000 10:46 AM

Your Edit-Links shows the name of the linked file.
Use edit-find from where you started to find the
cell(s) with the linking formula