Page 1 of 3 123 LastLast
Results 1 to 10 of 24

"Not enough system resources to display completely"

This is a discussion on "Not enough system resources to display completely" within the Excel Questions forums, part of the Question Forums category; Hi, I've been working with links the past few days and have been experiencing the subject error message. What do ...

  1. #1
    New Member
    Join Date
    Oct 2002
    Posts
    35

    Default "Not enough system resources to display completely"

    Hi, I've been working with links the past few days and have been experiencing the subject error message. What do I need to do to avoid the error?

    Thank you in advance...

  2. #2
    Board Regular Iridium's Avatar
    Join Date
    Jul 2002
    Location
    West Bridgford, Notts., England
    Posts
    2,834

    Default Re: "Not enough system resources to display completely&

    Iridium


  3. #3
    New Member
    Join Date
    Mar 2007
    Location
    toronto
    Posts
    3

    Default Not enough system resources to display completely&

    I had a case where using a combo box, where my ListFillRange referred to a named range on a different worksheet caused this error.

    By moving the named range to the same worksheet, the error went away

  4. #4
    New Member
    Join Date
    Apr 2009
    Posts
    1

    Thumbs up Re: "Not enough system resources to display completely&quot

    http://support.microsoft.com/default...&Product=xlw2K

    The above article was spot on, pretty much a limitation with excel it's self...

  5. #5
    Board Regular Kris75's Avatar
    Join Date
    Jul 2009
    Location
    Kettering, Northamptonshire
    Posts
    143

    Default Re: "Not enough system resources to display completely&quot

    It happened with me when i formatted the background, when i removed the background the size of file shrank friom 164 kb to 32kb - problem solved!

  6. #6
    New Member
    Join Date
    Apr 2010
    Posts
    1

    Default Re: "Not enough system resources to display completely&quot

    This also happens if Excel starts up while the desktop is locked.

  7. #7
    New Member
    Join Date
    Sep 2010
    Posts
    2

    Default Re: "Not enough system resources to display completely&quot

    I have just fixed this problem - I had multiple combo boxes referencing tables in another tab. Simple fix, zoom level must be equal in both tabs, error goes away (i.e. set all tabs to 100% zoom).

    Not sure that this will work for all causes of the error, but it worked for me.

    See more at:
    http://support.microsoft.com/kb/183503

  8. #8
    New Member
    Join Date
    Nov 2007
    Location
    Ohio, USA
    Posts
    8

    Default Re: "Not enough system resources to display completely&quot

    Quote Originally Posted by samty View Post
    I have just fixed this problem - I had multiple combo boxes referencing tables in another tab. Simple fix, zoom level must be equal in both tabs, error goes away (i.e. set all tabs to 100% zoom).
    This worked for me Thanks samty!

  9. #9
    New Member
    Join Date
    Feb 2009
    Posts
    5

    Default Re: "Not enough system resources to display completely&quot

    EXCEL 2010 that almost drove me crazy
    A couple of months ago, I have found out that some older EXCEL workbooks, that worked fine for years in versions from 2000 to 2007, start giving error "Not enough system resources to display completely" when trying to open them on EXCEL 2010.


    Symptons
    - Opening workbook it gives error "Not enough system resources to display completely";
    - Sometimes it hapened and sometimes it did not, even using the same workbook (but different opening sheets);
    - It never happened during workbook operation, only during opening;
    - My version of EXCEL is 14.0.5128.5000 (32 bits).


    Since this a rather complex project, I did not related this behavior with EXCEL 2010. I thought It was something that I did wrong.


    A carefull investigation that lasted more than 60 hours of brain and fingertips burning (along with all the sorrow because time was running out too fast), I have reached the following conclusion.


    Conclusion:
    Opening a workbook EXCEL 2010 which opening active sheet have controls (buttons, checkboxes, etc) in it, it will likelly give you error "Not enough system resources to display completely".


    Solution 1:
    1 - Remove controls (button, checkbox, images, listbox, etc) from opening worksheet, save, close and reopen workbook. Everything should be fine.


    Solution 2:
    1 - Add a DummySheet (obviously without any controls);
    2 - Use workbook BeforeSave event to activate DummySheet - This will grant that once the workbook is reopened, opening sheet will be DummySheet, which will not have any controls;
    3 - Save, Close and Reopen.
    4 - If everything went fine, you might consider a restyling on DummySheet so opening sheet show something like "Loading data..."

    I hope this tip will ease someone's life and avoid going thru the same nightmare I did.

    Cheers

  10. #10
    New Member
    Join Date
    Nov 2011
    Posts
    2

    Default Re: "Not enough system resources to display completely&quot

    Julio,

    Thanks for the tip. I'd like to try it, but could you help explain how to create a beforesave event that switches to a dummysheet? I searched but couldn't find anything clear enough.

    Also, do think I would get the resource error when saving if I was on a sheet with checkboxes, etc?

    thanks

Page 1 of 3 123 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com