Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated.

Hello Pascal,

Thanks for reaching out here in Microsoft Q&A.

I know how frustrating it can be when Excel hits a resource limit and stops calculating formulas.

This issue is usually caused by extremely large or complex formulas, excessive use of volatile functions, or insufficient system memory available to Excel during calculation.

You can free up system memory by closing unused apps and browser tabs.

Also, try to simplify formulas:

• Break down complex formulas into smaller steps.
• Avoid volatile functions like INDIRECT, OFFSET, or NOW if possible.

You can check for Array Formulas or Circular References:

• Go to Formulas > Error Checking > Circular References.
• Review any array formulas that might be consuming too many resources.

If possible, try to increase Excel’s memory allocation. On macOS, this is limited, but ensuring Excel is updated to the latest version can help optimize performance.

If the file is very large, consider splitting it into smaller workbooks or using Power Query to manage data more efficiently.

Let me know if you need further assistance.

Best regards,

Alex | Microsoft Q&A Specialist

------------------------------------------------------------------------------------------------------------ 

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".  

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.