SOLVED

Getting this msg "Excel ran out of resources while attempting to calculate one or more formulas."

%3CLINGO-SUB%20id%3D%22lingo-sub-2003279%22%20slang%3D%22en-US%22%3EGetting%20this%20msg%20%22Excel%20ran%20out%20of%20resources%20while%20attempting%20to%20calculate%20one%20or%20more%20formulas.%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2003279%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20issue%20with%20excel%20sheet%20which%20keeps%20showing%20me%20this%20issue%20%3CSPAN%3E%22Excel%20ran%20out%20of%20resources%20while%20attempting%20to%20calculate%20one%20or%20more%20formulas.%20As%20a%20result%2C%20these%20formulas%20can%20not%20be%20evaluated.%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ENever%20had%20seen%20this%20before-%20pls%20guide.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2003279%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-2003781%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20this%20msg%20%22Excel%20ran%20out%20of%20resources%20while%20attempting%20to%20calculate%20one%20or%20more%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2003781%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F906852%22%20target%3D%22_blank%22%3E%40GaneshIyer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20cell%20D36%20you%20have%20formula%26nbsp%3B%3D30%3A294001%20which%20means%20you%20instruct%20Excel%20to%20return%20all%20rows%20from%2030%20to%20294001.%20Includes%20row%20in%20which%20the%20formula%20is.%20Kind%20of%20cyclic%20reference%20and%20never%20ended%20loop.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20remove%20this%20formula%20it%20works.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2004447%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20this%20msg%20%22Excel%20ran%20out%20of%20resources%20while%20attempting%20to%20calculate%20one%20or%20more%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2004447%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B-%20Amazing%20it%20worked%20well%20for%20me.%20Thanks%20a%20million.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHappy%20Holidays%20and%20Happy%20New%20Year%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am having issue with excel sheet which keeps showing me this issue "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas can not be evaluated."

 

Never had seen this before- pls guide.

3 Replies
best response confirmed by GaneshIyer (New Contributor)
Solution

@GaneshIyer 

In cell D36 you have formula =30:294001 which means you instruct Excel to return all rows from 30 to 294001. Includes row in which the formula is. Kind of cyclic reference and never ended loop.

 

If you remove this formula it works.

@Sergei Baklan - Amazing it worked well for me. Thanks a million.

 

Happy Holidays and Happy New Year in advance!