Oct 26 2021 03:05 AM - edited Oct 26 2021 03:17 AM
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!
Nov 01 2021 08:12 AM
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.
Nov 01 2021 09:22 AM
Most probably that's wrong array formula. If you could share the file we could check.