+ Reply to Thread
Results 1 to 4 of 4

Excel 2010 fails to release memory allocation

  1. #1
    Registered User
    Join Date
    07-20-2010
    Location
    Oklahoma City
    MS-Off Ver
    Excel 2007
    Posts
    6

    Excel 2010 fails to release memory allocation

    I am running Excel 2010 32bit under Windows 7. The Excel file worked perfectly under Excel 2007 and Windows XP. The Excel file is somewhat complex with numerous links and embedded cell formulas. Occasionally, I get the following error message:

    5.jpg

    It appeared the message appeared somewhat random, until I began checking all of the recommended solutions. Unfortunately all of the solutions I was able to find on the internet and various forums did not help my problem. Frustration lead me to memory issues, as many of the solution recommended the 64 bit version of Excel. Before I install the 64 bit version, I attempted to chack a few other things. I opened the task manager and while viewing the process tab, I opened my Excel file. Once the file loaded, this is the allocation displayed in task manager:

    1.jpg

    This seemed reasonable considering the size of the Excel file (33Mb). Without changing anything, I clicked save to make sure it was working properly. While viewing the process, I watched the allocation climb, substantially. when it completed, this is what the process displayed:

    2.jpg

    Continuing to click the save button, without changing anything, continued to increase the memory allocation until the error message was displayed:

    3.jpg

    4.jpg

    Closing Excel and re-openeing the file resets the memory allocation back to normal, which is a popular solution to this issue in the forums.

    I did check the same issue using Excel 2007 and the memory allocation releases after each save.

    I can see how installing the 64 bit version of Excel can correct this issue, and with 12Gb of Ram, I will probably use this method until I can get this fixed.

    I would very much appreciate a solution to address this issue.

    Thank you for your time.

    Tommy Tucker

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Excel 2010 fails to release memory allocation

    64Bit excel will aleviate that nonsensical issue for sure, and I never quite found the issue either, but at 32GB of ram I stopped caring .
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    07-20-2010
    Location
    Oklahoma City
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Excel 2010 fails to release memory allocation

    Aleviate yes, solve no. It is pretty pathetic that Microsoft has not solved this problem.

  4. #4
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Excel 2010 fails to release memory allocation

    Agreed. Also 2013 64bit for me crashes at least 100x more frequently than 2010 32bit... and if you build a slick powerpivot tool, it will NOT be backwards compatible even if it is smaller than 2GB...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 06-15-2012, 03:00 AM
  2. Excel won't release memory
    By jkmcn69 in forum Excel General
    Replies: 1
    Last Post: 02-16-2011, 03:51 AM
  3. Release Variable from Memory Problem
    By Huyeote in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-22-2006, 12:43 AM
  4. [SOLVED] XLL Memory allocation problem
    By Nat in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2006, 07:10 AM
  5. how do i release memory
    By kurb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2005, 01:06 AM

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