+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Registered User
    Join Date
    05-07-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    2

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

    I had an issue with a 2010 spreadsheet that has a number of sumproduct formulas (around 690).
    I wanted to pass this on if anyone else that might be having this type of issue..
    I read in one of the forums that changing to 64 bit would help this issue, but I also heard that this Excel cause other issues so choose not to go there...
    Just for giggles I save the spreadsheet to .XLS instead of the .XLSM and ran in capiblity mode...It worked and faster too...
    So give it a try.
    CK35

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Excel ran out of resources while attempting to calculate one or more formulas

    Hi ck35,

    welcome to the forum.
    I have something to add here :-

    As an option, change the workbook calculation mode to "manual" and press "shift + F9" to calculate the sheet having sumproduct formulas


    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    05-07-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Excel ran out of resources while attempting to calculate one or more formulas

    Just an FYI...I had the spreadsheet in that Manual calculate and I repeatedly got the error message. The only thing I found to work was as I stated running in compiblity mode.
    Thank you for your input...
    CK35

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1