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!

 

[Michael M]

Probably the best way would be to upload the workbook to a hosting site, Dropbox for instance, and then post a link to it back here so posters can take a look at the formulas.

 

[Davidns]

Thank you. So there is no way to get Excel to provide details (on either Mac or a PC)?

 

[MARK858]

I assume that you have clicked the icon the arrow points to in the image below

 

[Alex Blakenburg]

I suspect you have already run through this since you mentioned Name Manager but just in case you haven't seen it and it is of use:-

Excel Found A Problem with One Or More Formula References in This Worksheet [Solved]

You receive the error Excel found a problem with one or more formula references in this worksheet while saving the Excel workbook. Read this post to learn how to fix Excel found a problem with one or more formula reference errors. If you have excel file loss problems, download EaseUS Fixo...

www.easeus.com

The Error Checking function does seem to require you to go sheet by sheet but if there are errors hitting next will cycle you through each error on that sheet.

 

[Davidns]

I ran the Error Checking and it came back with "The error check is complete for the entire sheet" and doesn't show any errors. So, its a bit frustrating, especially since the Excel Found a Problem box keeps popping up every minute or so. And, again, all results seem fine.

 

[Alex Blakenburg]

If you are working in a larger organisation that uses the Enterprise version of Excel, you should have access to the ".COM" Add-In "Inquire".
It started life as Auditing software before it was bought by Microsoft.

Ref: Excel – Analysing Your Workbooks with the Inquire Add-In
Quote from there:
"OK, you may not necessarily be interested in how many cells contain formulas etc. but there is some useful information in here such as external references, cells containing errors etc. As you click on each element, you will see exactly which cells on which sheet meet those criteria."

 

[Davidns]

Thanks, but working as an individual and thus not using the required version of Excel. It just seems like an Excel bug to me given that any error would result in wrong outcomes and yet I have verified all the results using another program.

 

[Michael M]

Have you looked outside the used range of cells ?
Do a CTRL + End and see where the last "used" cell is.
There may be something popping up further down each worksheet, that isn't affect the current dataset.

 

[Davidns]

Yep, tried that too. One point I forgot to mention is that the spreadsheet was formerly one tab in a much larger spreadsheet of multiple tabs. I simply cut and pasted the one tab into a new spreadsheet and eliminated all external references and named ranges. Having reviewed every cell, I am confident there are no external references remaining, but Excel seems to think otherwise. And, again, all results are accurate.
Is there a way to turn off the error notification? Might be a good temporary solution since it pops up every few seconds and makes working on the spreadsheet nearly impossible.
Thanks to everyone trying to help me get past this annoying issue. I really appreciate it.