Circular reference error when opening Excel file

Question

Hello Everyone,&nbsp;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.&nbsp;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.&nbsp;Can someone help me ?&nbsp;Thanks in advcance,Nir

preagan · Answer

Hello&nbsp;Nir_Bresler,&nbsp;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-bcf7-1b49cd50d123

nir_bresler · Answer

Hello&nbsp;PReagan&nbsp;&nbsp;I wish it would that simple 🙂&nbsp;As written in my prevous post,I don't see any Circular Refrences list, it's empty.&nbsp;Nir&nbsp;

Forum Discussion

Circular reference error when opening Excel file

Resources