Excel Error Message

%3CLINGO-SUB%20id%3D%22lingo-sub-1531401%22%20slang%3D%22en-US%22%3EExcel%20Error%20Message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1531401%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20one%20of%20my%20spread%20sheets%20I%20keep%20getting%20the%20following%20message-%22Excel%20ran%20out%20of%20resources%20while%20attempting%20to%20calculate%20one%20or%20more%20formulas.%20As%20a%20result%20these%20formulas%20cannot%20be%20evaluated%22.%20I%20don't%20know%20how%20to%20correct%20this.%20Please%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1531401%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1531490%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%20Error%20Message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1531490%22%20slang%3D%22en-US%22%3EExcel%20has%20various%20limitations%2C%20including%20amount%20of%20memory%20it%20uses%2C%20that%20affect%20it.%20Large%20workbooks%2C%20complex%20formulas%2C%20array%20formulas%20that%20create%20large%20tables%20in%20memory%2C%20are%20some%20issues%20that%20can%20cause%20it%20to%20run%20out%20of%20resources.%20This%20site%20has%20some%20additional%20information%20that%20might%20be%20worth%20reading.%20%3CA%20href%3D%22http%3A%2F%2Fwww.decisionmodels.com%2Fmemlimitsc.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.decisionmodels.com%2Fmemlimitsc.htm%3C%2FA%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

In one of my spread sheets I keep getting the following message-"Excel ran out of resources while attempting to calculate one or more formulas. As a result these formulas cannot be evaluated". I don't know how to correct this. Please 

1 Reply
Excel has various limitations, including amount of memory it uses, that affect it. Large workbooks, complex formulas, array formulas that create large tables in memory, are some issues that can cause it to run out of resources. This site has some additional information that might be worth reading. http://www.decisionmodels.com/memlimitsc.htm