Results 1 to 10 of 10
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Excel out of resources

    SIGH.

    I've been working on a 5000 row, 26 column sheet with a number of SUMPRODUCT calcs. It's been going along just fine.
    I've had manual calc on and as I make adjustments, SHIFT+F9 to recalc. Has been just fine.

    All of a sudden, I'm getting an out of resources message. I closed all applications and even rebooted. No luck. GROAN.

    Any thoughts on how to get the sheet to recalc?

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    I am guessing that you are suffering from lack of memory - but what was the exact error message and when did it occur ?

    As a one-off workaround you will probably be able to get things to work if you boot up your PC in Safe Mode, but for a better solution I'd recommend you work through he type of things which you'll find listed in this article: http://www.add-ins.com/support/out-o...soft-excel.htm

    PS How much physical memory does your PC have ?

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    I have 4 gigs of RAM. My concern is that it WAS working and now it's not recalculating.

    I get the error when I try to recalc the sheet using SHIFT+F9.

    I also deleted all of the formulas after row 1000 as a test and still have the problem.

    Clip0001.jpg
    Last edited by kweaver; 2013-12-19 at 12:53.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    Could be that you have corruption in the Excel file.

    What happens if you save it with a different filename and also with a different file type eg an older version of Excel, whatever ?

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Won't let me save it as an XLS file (it's currently 2010 XLSX file). I did change the name (still XLSX file), but that didn't help.
    One "error" claim is that I have columns beyond IV...which I don't.

  6. #6
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    Ouch - it does sound like a corrupt file

    I have had some success rescuing such files by opening them with Open Office Calc, saving, then going back to Excel. You'll lose and VBA but formulas usually survive.

    Alternatively you might have a Circular Reference. As you have automatic calculation turned off that wouldn't show until you tried to recalculate the Workbook.
    Last edited by MartinM; 2013-12-19 at 13:58.

  7. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Ouch is right. I can't open the file in Open Office for some reason -- beats me. OO hangs.
    I've also tried to copy text and paste into a new file and recreate a small number of formulas, but still get the same resource error.
    Very frustrating.

  8. #8
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    It is starting to look like a circular reference to me. OO doesn't like 'em either.

  9. #9
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Well, I gave up and recreated the sheet and bypassed the SUMPRODUCT with SUMIFS and I have a new sheet with out resource issues. Phew!

  10. #10
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    I'm pleased it is fixed even if it couldn't be diagnosed

Posting Permissions

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