View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Finding Invalid References

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



Philip J Smith wrote:

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