Forum Discussion
Notification of error in formula reference, but can't find error
Try looking for the error in Conditional Formatting > Manage Rules. A PITA as you have to look through each rule for an error, since it won't have any indication it's incorrect. Plus can only do a sheet at a time. But generally if you can't find an error when Excel says its there, that's the place to look.
Also, check in Name Manager on the Formulas page, especially if you copied data from one workbook to another.
Try looking for the error in Conditional Formatting > Manage Rules. A PITA as you have to look through each rule for an error, since it won't have any indication it's incorrect. Plus can only do a sheet at a time. But generally if you can't find an error when Excel says its there, that's the place to look.
Also, check in Name Manager on the Formulas page, especially if you copied data from one workbook to another.
Thank you Randy Birch! I will remember these ideas.
In the end, I closed the file and when I opened it about an hour later, the error message went away. I must have corrected the error during the search and the file just took a while to register it.