Share via

Excel File will not open _ Circular references

Anonymous
2021-11-01T21:32:00+00:00

Hi,

My file will not open and it gives me this error message.

When I click "OK" it leaves me with a blank grey screen. I am not able to click "Enable iterative calculation" because it's grayed out.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2021-11-02T00:59:44+00:00

    Hi JaredJimenez2!

    I'm Jen, and I'd be happy to help you out with this issue.

    You'll need to find the cells with incorrect cell references and fix them. Click the Formulas tab, click the dropdown arrow on the right hand side of the Error Checking button, select Circular Reference.

    I hope this information helps. If you have any questions, please let me know and I'd be glad to assist you further.

    Best Regards!

    Jen :)

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-11-02T11:52:14+00:00

    Hi Jen,

    Thanks for helping! I clicked the formulas tab and everything is grayed out.

    .....Oh my gosh...I clicked the view tab and the "unhide" tab was the only one not grayed out. haha, I clicked it and everything came back! Thanks for pushing me in the right direction!!

    7 people found this answer helpful.
    0 comments
  2. Anonymous
    2021-11-02T12:00:14+00:00

    You're welcome. Glad your problem has been resolved :)

    0 comments