Excel Error: "Ran out of resources to calculate one or more formulas"

Anshul Gupta 20

Experiencing an error message in Microsoft Excel for Microsoft 365 on a Windows 11 PC that states "Excel ran out of resources to calculate one or more formulas" every time an entry prompts the calculation of other cells. The file size is under 10 MB, and no macros or add-ins are being used. The same message also appears when trying to save the file. Any suggestions for resolving this issue?

0 comments

Answer accepted by question author

Alvise C 56,041 Volunteer Moderator

hi Anshul, welcome in community

i’m Alvise, an independent consultant and I can understand your concern and, please, don't worry I am here to help you

try the following suggestions:

In Excel, go to File > Options > Formulas > Calculation Options > Manual > turn off Recalculate Workbook Before Saving. After that, please test again.

Disable hardware graphics acceleration, go to File > Options > Advanced > Display > Disable hardware graphics acceleration. let me know how it goes

Elvis

Anshul Gupta 20 Reputation points

2025-07-19T07:58:25.6133333+00:00

Thanks Alvise for the solution. It did work and error message stopped popping up, but I need to calculate my sheet manually with every entry which is quite frustrating. Help!

6 additional answers

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more
Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Excel Error: "Ran out of resources to calculate one or more formulas"

6 additional answers

Your answer