Finding Invalid References

[Philip J Smith]

Hi

I have a very large workbook with many thousands of calculations.

An error message has recently appeared when saving.

"A formula in this worksheet contains one or more invalid references.
Veryfy that your formulas contain a valid path, workbook, range name, and
cell reference."

There are no links to other workbooks.

Does anyone know if there is a tool, within Excel 2007, which will help me
to find the erroneous formulae?

Regards

Phil Smith

 

[Dave Peterson]

If excel thinks you have links, then you have links.

I'd use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm