Forum Discussion

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

excel

Yea_So

Bronze Contributor

Oct 25, 2021

Cinnymon

start excel in safe mode:

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

then you can fix the problem

Cinnymon

Copper Contributor

Oct 26, 2021

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
Bronze Contributor
Oct 28, 2021
Cinnymon

Now that you're able to open the file, turn the Calculation options from automatic to manual:
Yea_So
Bronze Contributor
Oct 26, 2021
Cinnymon

Did you open the document after you started excel in safe mode?
- Cinnymon
  Copper Contributor
  Oct 26, 2021
  I have gone to open document and click on it. It looks like it is opening it, but then it is a blank document called "book1".
  - Detlef_Lewin
    Silver Contributor
    Oct 26, 2021
    Could you share your file?