Oct 24 2021 05:46 PM
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?
Oct 24 2021 09:06 PM
start excel in safe mode:
How to Start Excel in Safe Mode (3 Easy Ways) - Spreadsheet Planet
then you can fix the problem
Oct 26 2021 11:46 AM
Oct 26 2021 01:52 PM
Oct 26 2021 03:26 PM
Oct 26 2021 03:29 PM
Oct 26 2021 03:38 PM
Oct 26 2021 04:43 PM
Oct 26 2021 04:48 PM
Oh you're using work computer then. Then only an administrator can do my previous post. You'll have to employ the help of your IT Administrator.
Oct 26 2021 07:10 PM
Oct 26 2021 07:11 PM
@Cinnymon I've had problems like this and found sometime I could open the problem file when Excel was already open as opposed to directly from the finder. Also under File -> Options you can select Formulas and ENABLE iterative calculations and then set it to something small:
the point being to try and prevent Excel error/crash.
ALSO if you go under File -> Open and then click on This PC and then on the right click on the file folder next to the path all the way at the top (above the search). That will bring up the file system open dialogue. Then navigate to the file and click the down arrow next to the OPEN button:
As you can see you can try Open in Protected View or Open and Repair... options.
Oct 28 2021 10:52 AM
Oct 28 2021 10:54 AM
Oct 28 2021 04:49 PM - edited Oct 28 2021 04:50 PM
Now that you're able to open the file, turn the Calculation options from automatic to manual: