Circular reference error when opening Excel file

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

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

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