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?
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
I will give that a try thanks for sharing
I have a similar issue.
As an FYI, I have 19000 transaction rows and 30000 balance history rows. Is anyone using files of this size?
I have approximately 9800 transaction rows and 28,000 balance history rows. The file size is a 9.729 mB.
I wonder how balance history records are used. Why would that many stored records be needed?
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.
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:
Deleted 3 template pages to reduce size.
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!
After I deleted the debt planner sheet, the error went away.
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.
I had the same problem on my Mac. Problem appeared after I installed a bunch of templates, but I wasn’t sure initially if that was the reason. Long story short, problem was resolved after I deleted the Debt Pay Off Planner (Tiller Sheet!) template. @heather Is that something you could look into? Thanks!
I setup a template to test this issue out. I was able to receive the same error message on the first use of the add-in template. After I saved the Tiller template, exited out, and opened it up again, the issue didn’t return. I don’t have a root cause for the error, but will keep looking into it. I do use OneDrive and suspect it might have something to do with my spreadsheet being stored in OneDrive. I will create a test case to determine if my hypothesis is correct in my situation.
Hi Clint. Thanks for getting back on this so quickly. Same here, I am using OneDrive to store the Excel file. Closing excel and reopening it did not solve it for me. I also turned off multi-threaded calculation in preferences without success.
1 Like
Thanks Matt. I do have my template set to “Always keep on this device” as it relates to OneDrive. You might try that if you haven’t already.