EXCEL ran out of resources error message

Microsoft Excel
1

I have been getting error messages with the Excel Foundation Sheet. This is the message (Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated.] Does anyone know what this means or how to fix the problem?

2

It happened to me after I downloaded a few new templates. I uninstalled one, saved the file and closed it. It has not returned. Not sure about the cause.

1 Like
3

I will give that a try thanks for sharing

4

I have a similar issue.

5

As an FYI, I have 19000 transaction rows and 30000 balance history rows. Is anyone using files of this size?

6

I have approximately 9800 transaction rows and 28,000 balance history rows. The file size is a 9.729 mB.

7

I wonder how balance history records are used. Why would that many stored records be needed?

8

Thank you for your advice. I tried two things: I set the calculation function to Manual Calculation mode, which stopped the error messages. But of course, when you turn it back on, you still have the same problem. Second, I tried your advice and removed a template that I had added to my workbook [Budget Plan], a community-generated template, and I am no longer getting the error message.

9

I’ve been consistently running into the same “Excel ran out of resources while attempting to calculate one or more formulas” error, even though my file is less than 1MB and only contains this year’s data.

FYI this is my current setup:

  • Templates in Use: Balance History, Categories, Transactions, AutoCat, Accounts, Balances, Monthly Analysis, Debt Payoff Planner.
  • Number of Transactions: Less than 400.
  • Auto Categories: 70.
  • Categories: 40.
  • Accounts Linked: 9 (from 2 banks + mortgage).
  • Manual Data: Uploaded CSVs from 2 credit cards (Apple Card + another) since Tiller doesn’t sync them. Also manually added student loans, car loan, and solar panel loan.

What I’ve Tried:
:white_check_mark: Deleted 3 template pages to reduce size.
:white_check_mark: Saved the file to my Excel account in OneDrive

But still, the error still persists frequently. Has anyone else encountered this with a similarly small file? Any insights into why this might be happening and potential fixes?

Thanks in advance!

10

After I deleted the debt planner sheet, the error went away.

11

I had to uninstall the account register and reconciliation sheets to make this error go away. I thought it went away with just deleting the debt planner sheet, but that was not the case. Now I am reviewing my other installed sheets to determine if I should delete them instead and reinstall others of interest. I don’t know if the Google Sheets Simple Reconciliation is less resource intensive, but I would love for it to be ported to Excel. I would delete other installed templates to use it.