Forum Discussion
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 attempti...
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.