Forum Discussion
Techy25
Oct 26, 2021Copper Contributor
Excel Ran out of resources while attempting to calculate one or more formulas
Hi all!
I'm trying to do up a simple excel sheet for personal stock tracking, so im doing up a pivot table halfway where out of the sudden this tab with "Excel Ran out of resources while attempting to calculate one or more formulas" popped up and affecting even other excel sheets. Any way to resolve this?
** The issue is that i could add in other tickers, but not Apple's. Once i add that in, the error will return
Thank you!
2 Replies
Sort By
Most probably that's wrong array formula. If you could share the file we could check.
- JSHEP73Brass Contributor
You could try reducing the size of the file, may help.
Try saving as a .xlsb
You can also try changing a setting on any pivot tables you have, untick the Save source data with file.
The only thing you'll have to change is that you will have to refresh the pivot table before you can make any changes to it.
Hope this helps.