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.
TIA
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
