Excel Error of Reference

Question

I have a file that sometimes it shows me an error...

Imagem

Translating it says something like...

"The Excel encountered a problem with one or more references of formulas in this spreadsheet.

Check that cell references, range names, defined names, and links to other workbooks in your formulas are all correct."

I use the Microsoft 365 Version 2307

I think that the problem started when i find the way of showing the Graphics without the with spaces.

It went from this... User's image

To this....

User's image

You may check a file downloading using this link

Or this one

Thanks

Carlos Cerqueira

Answer

Hi,

This error message indicates that there is a problem with one or more of the formulas in your Excel worksheet.

It can occur due to various issues in formulas like-

Formula errors commonly occur as a result of incorrect syntax, circular references, or references to cells that no longer exist.
If your worksheet contains references to other workbooks or data sources, problems with those references may cause this error.
If you've deleted or moved cells that were referenced in formulas, this can cause problems.

Refer to this article for more information on how to fix it.

Best Regards.

Answer

There is no error with the formulas.

If i delete the Graphic the Error stops.

The problem started when i rename the Cells Name to make the Excel ignore the blank values.

You may check the steps where...

I used the "Rename Cell" and use this formula (Filtrar = Filter)

Imagem

And in the Graphic i made this...

Imagem

The Table that is shown is this

Imagem

But the original Table is this

Imagem

But the way that i made the formula the ID's that are blanks the Excel ignores.

Download the file that i posted and check the way i did it.

Press Ctrl+F3 to check the Name Manager and the way.

2 answers