Circular reference error when opening Excel file

%3CLINGO-SUB%20id%3D%22lingo-sub-1699468%22%20slang%3D%22en-US%22%3ECircular%20reference%20error%20when%20opening%20Excel%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1699468%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22%E2%80%8F%E2%80%8F%D7%9C%D7%9B%D7%99%D7%93%D7%94.PNG%22%20style%3D%22width%3A%20728px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F221099iA0C3E5A191DEAA99%2Fimage-dimensions%2F728x91%3Fv%3D1.0%22%20width%3D%22728%22%20height%3D%2291%22%20title%3D%22%E2%80%8F%E2%80%8F%D7%9C%D7%9B%D7%99%D7%93%D7%94.PNG%22%20alt%3D%22%E2%80%8F%E2%80%8F%D7%9C%D7%9B%D7%99%D7%93%D7%94.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHello%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20experiencing%20a%20wierd%20error%20regarding%20a%20circular%20reference%2C%20the%20problem%20is%20it%20happens%20for%20EVERY%20excel%20file%20I%20open.%20Meaning%20it's%20not%20something%20particular%20in%20the%20a%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20translation%20of%20the%20error%20is%3A%3C%2FP%3E%3CP%3E%22To%20Micosoft%20Excel%20there%20is%20no%20option%20to%20calculate%20a%20formula.%20A%20Circular%20reference%20occur%20in%20an%20open%20file%2C%20but%20there%20is%20no%20option%20to%20create%20a%20list%20of%20circular%20references.%20Try%20and%20edit%20the%20last%20formula%20you%20entered%20or%20remove%20it%20by%20using%20the%20function%20Cancel.%22%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EI%20can%20retrieve%20the%20last%20formula%20I%20did%20because%20it's%20a%20file%20I%20just%20opened%20and%20didn't%20do%20anything.%3C%2FP%3E%3CP%3ENor%20can't%20find%20and%20cancel%20option%20to%20cancel%20the%20error.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20help%20me%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advcance%2C%3C%2FP%3E%3CP%3ENir%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1699468%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1708078%22%20slang%3D%22en-US%22%3ERe%3A%20Circular%20reference%20error%20when%20opening%20Excel%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1708078%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F803478%22%20target%3D%22_blank%22%3E%40Nir_Bresler%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20circular%20reference%20error%20occurs%20when%20you%20reference%20the%20current%20cell%20in%20your%20formula.%20Refer%20to%20the%20following%20to%20learn%20more%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fremove-or-allow-a-circular-reference-8540bd0f-6e97-4483-bcf7-1b49cd50d123%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fremove-or-allow-a-circular-reference-8540bd0f-6e97-4483-bcf7-1b49cd50d123%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

‏‏לכידה.PNG

Hello Everyone,

 

I'm experiencing a wierd error regarding a circular reference, the problem is it happens for EVERY excel file I open. Meaning it's not something particular in the a file.

 

The translation of the error is:

"To Micosoft Excel there is no option to calculate a formula. A Circular reference occur in an open file, but there is no option to create a list of circular references. Try and edit the last formula you entered or remove it by using the function Cancel."

I can retrieve the last formula I did because it's a file I just opened and didn't do anything.

Nor can't find and cancel option to cancel the error.

 

Can someone help me ?

 

Thanks in advcance,

Nir

2 Replies
Highlighted

Hello @Nir_Bresler,

 

A circular reference error occurs when you reference the current cell in your formula. Refer to the following to learn more:

https://support.microsoft.com/en-us/office/remove-or-allow-a-circular-reference-8540bd0f-6e97-4483-b...

Highlighted

Hello @PReagan 

 

I wish it would that simple

 

As written in my prevous post,

I don't see any Circular Refrences list, it's empty.

 

Nir