Forum Discussion
Cinnymon
Oct 25, 2021Copper Contributor
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
- CinnymonCopper ContributorOk, 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_SoBronze Contributor
start excel in safe mode:
https://spreadsheetplanet.com/start-excel-safe-mode/
then you can fix the problem
- CinnymonCopper ContributorThank 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.