Forum Discussion

Cinnymon's avatar
Cinnymon
Copper Contributor
Oct 25, 2021

Excel document not opening due to circular references.

I am trying to open an Excel document.  When it first opens I get the message:

 

"There are one or more circular references where a formula refers to its own cell either directly or indirectly.  This might cause them to calculate incorrectly.  Try removing or changing these references, or moving the formulas to different cells."

 

When I click ok it just goes to a blank screen, no document.   Most everything is greyed out.  This is a multiple page document that I have worked on for days.  Everything was saved multiple times.  Only thing that had happened between the time I closed it and reopened it was an update.

 

Is my document gone?

14 Replies

  • Cinnymon's avatar
    Cinnymon
    Copper Contributor
    Ok, so I sent my document to a friend. She didn't see anything either, but then opened it this morning and there it was so she sent it back to me. I opened it in google docs then tried to download it in hopes it would open and of course no go. All other Excel docs are opening fine.
  • Yea_So's avatar
    Yea_So
    Bronze Contributor

    Cinnymon 

     

    start excel in safe mode:

    https://spreadsheetplanet.com/start-excel-safe-mode/

     

    then you can fix the problem

    • Cinnymon's avatar
      Cinnymon
      Copper Contributor
      Thank you. I got it opened in Safe Mode, no document popped up. I went to circular references under error checking and see the error, but nothing pops up when I click on it. Not one sheet on the document.
      • Yea_So's avatar
        Yea_So
        Bronze Contributor

        Cinnymon 

         

        Now that you're able to open the file, turn the Calculation options from automatic to manual:

         

Resources