Forum Discussion

Nir_Bresler's avatar
Nir_Bresler
Copper Contributor
Sep 22, 2020

Circular reference error when opening Excel file

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

excel

2 Replies

  • PReagan's avatar
    PReagan
    Bronze Contributor
    Sep 24, 2020

    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-bcf7-1b49cd50d123

    • Nir_Bresler's avatar
      Nir_Bresler
      Copper Contributor
      Sep 24, 2020

      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

       

Resources