This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi all,
I'm having issues with Excel Online doing something pretty funky. If I have it on the Automatic calculating option and then double click within a cell to check a formula, it calculates all content to zero (I first noticed it when trying to reference a cell in a formula and it kept returning 0). But if I switch to manual calculating, all my formulas work just fine but I have to go through and manually click every single cell individually.
Everything was working just fine till just a couple hours ago and now all my formulas are acting up. I only tried the manual calculating as a troubleshooting option, and so I could keep working, but it's definitely not a long term solution.
I have tried closing the workbook and opening it back up again, but to no avail.
I can't think of how else to summarize the problem or take a screenshot that would demonstrate but please let me know if there's any other info I can provide.
EDIT: this is happening in onedrive.live.com
Also updated Chrome, relaunched browser and the issue still persists.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
Answer accepted by question author
Look at the formulas in C13 and D13. Apparently they refer to cells on another sheet. And those cells eventually refer back to E13.
Thank you!
Hey Hans, thanks for replying. So I downloaded it and indeed there are a few but I'm confused by them. Here's one:
When I click the grids (highlighted), they go away. The formula showing is in cell E, co I don't understand why it's a circular reference...
I suspect that you have a circular reference, that is a formula that refers directly or indirectly to the cell containing the formula.
A simple example is the formula =A1+1 in cell A1.
If you open the workbook in the desktop version of Excel, you should be able to find circular references through Formulas > Error Checking > Circular References...