Error: Excel found a problem with one or more formula references in this worksheet

[Davidns]

I keep getting this pop up error while working in one of my spreadsheets. I have eliminated all named ranges, and checked all cells but cannot find any problems. Is there a way to get Excel to provide specifics about the problems it is referring to? For example, determining if a cell refers to a sheet that doesn't exist? I realize that can be done cell by cell, but that is quite painful, and as I mentioned, I have visually checked every cell to verify that the formulas appear ok.
I am using Excel for Mac, v16.84

Thanks!

 

[MARK858]

Personally I would try installing the Findlink addin and see if it finds anything

FindLink

 

[Davidns]

Looks like a potentially useful extension, thank you. But how would I find references to other pages when I don’t know what those page names might be? Is there a way to search for any links outside of the current page, rather than to an external file?

 

[MARK858]

It searches for broken links within the workbook if you use the #REF option

 

[Davidns]

Excellent. Will give it a try. Thank you!