Excel Error of Reference

Carlos Cerqueira 0 Reputation points
2023-10-03T10:49:25.9466667+00:00

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

https://drive.google.com/file/d/1b1mrnjlgMtyNlOh56WiKqDnbP1J7NT3p/view?usp=drivesdk

Or this one

https://1drv.ms/x/s!Ave9wMM6LZzehqIQM5MT_nwOMtB7Kw?e=g0IUxh

Thanks

Carlos Cerqueira

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,917 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,519 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Tanay Prasad 2,110 Reputation points
    2023-10-05T06:43:45.72+00:00

    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-

    1. Formula errors commonly occur as a result of incorrect syntax, circular references, or references to cells that no longer exist.
    2. If your worksheet contains references to other workbooks or data sources, problems with those references may cause this error.
    3. 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.


  2. Carlos Cerqueira 0 Reputation points
    2023-10-05T09:38:02.5133333+00:00

    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...

    https://answers.microsoft.com/pt-br/msoffice/forum/all/erro-do-excel-de-refer%c3%aancia/2366eabf-bf11-44af-8f25-847b3df57d6d?messageId=710622ac-5a23-4d4b-be60-1343eecba8ec

    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.

    0 comments No comments