not enough resources to display completely starting excel 2010

[Boris]

I have just performed a clean install of Office 2010, having totally removed
my Office 2007. I have installed the 64 bit variant, running on my (fairly
new) Sony Vaio with 250 Gb ssd and 6 Gb RAM. I am running windows 7 ultimate
(64 bit). Imagine my surprise that, whenever I start Excel, I get the error
message:
Not enough resources to display completely!!!

I have not opened any workbook, nor do I have any other programs running,
and I am a bit perplexed as to what could be causing this issue. Any ideas?

I did also get some error messages when first starting Word but these seem
to have cleared themselves up after a reboot. And, to be honest, I was
getting a similar error recently when running Excel 2007 (32 bit of course)
but only for a particular file at least that is what I though) which had been
recovered and repaired so I was not overly worried But, following a clean
install and with nothing else running... ...

Any suggestions would be greatly received.

 

[will l]

this may seem random, but might be worth a shot... i think this problem often occurs because of registry errors with the fonts... this solution fixes that. if you browse to windows/fonts and immediately get a blue screen, then the fonts are your problem

first try going to control panel > fonts >font settings (on left) > restore default fonts

if you can't access fonts in the control panel then try this... in explorer go here: \\%COMPUTERNAME%\C$\Windows\Fonts (replacing %computername% with your computername).

then hit ctrl+a to select all the fonts.
once they're all selected right click and select "install".

when the dialogue box pops up saying that "[such and such] font is already installed, would you like to reinstall it?" click the box for "do this for all current items", and hit "yes"

reboot (just for grins), and you should be good to go

 

[JulioNobre]

EXCEL 2010 bug that almostdrove me crazy
A couple of months ago, I have found out that someolder EXCEL workbooks, that worked fine for years in versions from 2000 to2007, start giving error "Not enough system resources to displaycompletely" when trying to open them on EXCEL 2010.

Symptons
- Opening workbook it gives error "Not enoughsystem resources to display completely";
- Sometimes it hapened and sometimes it did not, evenusing the same workbook (but different opening sheets);
- It never happened during workbook operation, onlyduring opening;
- Could not solve it reducing opening sheet zoom to100%, according to Microsoft’s suggestion on http://support.microsoft.com/kb/183503/en-us;
- My version of EXCEL is 14.0.5128.5000 (32 bits).

Note: Since this a rather complex project, I did notrelated this behavior with EXCEL 2010. I thought It was something that I didwrong.

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

Conclusion:
Opening a workbook EXCEL 2010 which opening activesheet have controls (buttons, checkboxes, etc) in it, it will likelly give youerror "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 withoutany controls);
2 - Use workbook BeforeSave event to activate DummySheet- This will grant that once the workbook is reopened, opening sheet willbe DummySheet, which will not have any controls;
3 - Save, Close and Reopen.
4 - If everything went fine, you might consider arestyling on DummySheet so opening sheet show something like "Loadingdata..."

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

Anyway, it is just an unacceptable and shamefull mistake on one ofthe greatest software products ever made: Microsoft Excel.

Cheers

 

[JulioNobre]

I have prepared a sample workbook that show how to implement the workaround, along with full implementation detais. You can get it at http://www.mrexcel.com/forum/showthread.php?t=62223&page=2

Hope this helps, speacilly newbies