Links within Excel (2003) workbook

[MassSpecGuru]

Lately, whenever I open a workbook I've been working with I get a message asking if I want to update the links to the other data sources.

I do not want to simply turn off this mesage, but I would like ideas as to how to find the cell(s) that are supposedly tied to these other data sources since there should not be any. I have about 30 worksheets in this workbook and I don't want to have to go through "umpteen" thousand cells looking for a reference to another workbook, especially since there shouldn't be any.

Any ideas (or some VBA code that can look through all of the sheets in a workbook)?

Thanks!

 

[strategygamer]

Edit-Find (or control-f).
Search for "["
Advanced options: search in: workbook.

 

[MassSpecGuru]

Brilliant! Simple and effective. Can't believe I did't think of it! Thanks! I owe you one.

(BTW, I had copied some formulas from another workbook and hadn't deleted the temporary worksheet in the workbook in question. Doh!)