References to Linked Workbooks - How do you find?
Posted by Ed J. on February 06, 2001 2:28 PM
When opening a large workbook (book1), I get the message that it is linked to another workbook(book2). The book it tries to reference (book2) does not exist and Excel takes me into 'Open' mode to find the workbook. I cancel and try to find the reference to book2 by using the 'Find' with formulas checked in all the sheets in book1. I can't find the reference in any of the sheets.
Is there an easier way to find cells that have linked references?