Re: "Not enough system resources to display completely"
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.
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).
Re: "Not enough system resources to display completely"
EXCEL 2010 that almost drove me crazy <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o> 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.
<o></o> Symptons<o></o> - 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;<o></o> - My version of EXCEL is 14.0.5128.5000 (32 bits).
<o></o> <o>Since this a rather complex project, I did not related this behavior with EXCEL 2010. I thought It was something that I did wrong.</o> <o></o> <o><o></o></o> 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.
<o></o> Conclusion:<o></o> 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".
<o></o> Solution 1:<o></o> 1 - Remove controls (button, checkbox, images, listbox, etc) from opening worksheet, save, close and reopen workbook. Everything should be fine.
<o></o> Solution 2:<o></o> 1 - Add a DummySheet(obviously without any controls);<o></o> 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;<o></o> 3 - Save, Close and Reopen.<o></o> 4 - If everything went fine, you might consider a restyling on DummySheet so opening sheet show something like "Loading data..." <o></o> I hope this tip will ease someone's life and avoid going thru the same nightmare I did. <o></o> Cheers
Re: "Not enough system resources to display completely"
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?
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.