Find Links
You can click on on EDIT in the menu and select LINKS to get the names of the
files. Once you have the names of the files you can search through each
worksheet using FIND, just make sure that LOOK IN is set to FORMULAS.
--
Kevin Backmann
"Bill Martin" wrote:
Somehow one of my workbooks thinks it has links to another workbook. Maybe
something got established accidentally, I don't know. My workbook has 150
sheets though, and I don't really want to search for the unwanted link one cell
at a time.
Is there some way to ask Excel to tell me precisely *which* cells it thinks are
linked to another workbook?
Thanks.
Bill
|