Hello there,

If you go to Edit---Links in your workbook, you will see the path of each
external link.
You can then check the links and it will tell you of the invalid link.
Then do a search for the link text (Look in Formulas).
If you are only missing links to other cells in the workbook, your sheet
names may be changed. The edit links will also show you this.

Finally if you want to search manually or see the formulas while you do a
search from Edit Search, hit CONTROL AND ~ together(Next to the 1 key) this
will expand cells to show background formulas Same keys restore your sheet.

"Feejo" wrote:

Verify that your formulas contain a valid path, workkbook, range name, and
cell reference.

How can I search them.