Excel Ran out of resources while attempting to calculate one or more formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2885358%22%20slang%3D%22en-US%22%3EExcel%20Ran%20out%20of%20resources%20while%20attempting%20to%20calculate%20one%20or%20more%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2885358%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20do%20up%20a%20simple%20excel%20sheet%20for%20personal%20stock%20tracking%2C%20so%20im%20doing%20up%20a%20pivot%20table%20halfway%20where%20out%20of%20the%20sudden%20this%20tab%20with%20%22Excel%20Ran%20out%20of%20resources%20while%20attempting%20to%20calculate%20one%20or%20more%20formulas%22%20popped%20up%20and%20affecting%20even%20other%20excel%20sheets.%20Any%20way%20to%20resolve%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E**%20The%20issue%20is%20that%20i%20could%20add%20in%20other%20tickers%2C%20but%20not%20Apple's.%20Once%20i%20add%20that%20in%2C%20the%20error%20will%20return%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2885358%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2908956%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Ran%20out%20of%20resources%20while%20attempting%20to%20calculate%20one%20or%20more%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2908956%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1053573%22%20target%3D%22_blank%22%3E%40Techy25%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20could%20try%20reducing%20the%20size%20of%20the%20file%2C%20may%20help.%3C%2FP%3E%3CP%3ETry%20saving%20as%20a%20.xlsb%3C%2FP%3E%3CP%3EYou%20can%20also%20try%20changing%20a%20setting%20on%20any%20pivot%20tables%20you%20have%2C%20untick%20the%20Save%20source%20data%20with%20file.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JSHEP73_0-1635779467465.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F322246i0E85F12D8B6EE8C7%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JSHEP73_0-1635779467465.png%22%20alt%3D%22JSHEP73_0-1635779467465.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20only%20thing%20you'll%20have%20to%20change%20is%20that%20you%20will%20have%20to%20refresh%20the%20pivot%20table%20before%20you%20can%20make%20any%20changes%20to%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

@Techy25 

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.

JSHEP73_0-1635779467465.png

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.

 

@Techy25 

Most probably that's wrong array formula. If you could share the file we could check.