How do I track down 'invalid references'

D

Dreiding

I have a workbook that has many worksheets and associated formulas. Every
once in a while when I close the file I get the following message:
----------------------
A formula in this worksheet contains one or more invalid references.
Verify that your formulas contain valid path, workbook, range name, and cell
reference.
-----------------------

I've been able to track this checking to be after "Workbook_BeforeClose"
execution, but I don't have a clue on finding the formulas with the invalid
references.
I found cells with "#DIV/0!", "#VALUE!", #NUM!, #N/A.
Which of these should I attach first? Could it be something else?

Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to find invalid formula references with VBA 2
Trace errant formula to stop annoying message 13
2007 Update 3
Excel 2003 dynamic named range for the values in a pie chart 1
persistent "invalid reference" error message 2
Invalid References 1
pesky invalid external reference error: how to track it down? 0
Finding one or more "Invalid References" in big spreadsheet 1

Top