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)
Since upgrading to 16.85 on a Mac some of my files show errors
"Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated." The error comes up again and again and the only way to end the loop is to force quit.
Other files lock up for several seconds trying to refresh or calculate something.
I have changed the calculate setting to Automatic except for Data Tables and issue 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
A revised update [16.85.2] has been issued. Apply that & see if it resolves the issue.
If it doesn't, please provide specific examples illustrating the issue. Open the file in the Excel Online web app if necessary.
Include the specific macOS Version Number in your reply.
same issue with v16.85 on Mac. For example, Maxifs formula "disappeared" and is unusable, even when I look for it in the formula builder. Gone.
Mac OS Ventura 13.6.7 (22G720)
Also 16.85.2 doesn't seem to be available yet in my region (Europe). No updates available