Symptoms
When you open a Microsoft Excel 2010 workbook that contains many OLE objects, ActiveX controls, or form controls, the workbook does not work correctly.
For example, the following issues may occur:
-
Display issues
-
Performance issues
-
Excel 2010 stops responding
-
Excel 2010 crashes
If you are running a Windows operating system, the operating system and other applications that are running on the computer are also affected.
Cause
This issue occurs because the operating system has a limit to the number of Graphics Device Interface (GDI) objects that can be created after the operating system is installed. If the operating system reaches the limit, no new GDI object is allocated. Additionally, a Windows operating system and any other running application stop responding.
Resolution
To have us fix the problem for you, go to the "Fix it for me" section. If you prefer to fix this problem yourself, go to the "Let me fix it myself" section.
Fix it for me
To fix this problem automatically, click the Fix itbutton or link. Click Runin the File Download dialog box, and follow the steps in the Fix it wizard.
Notes
-
In Windows XP, Windows Vista and Windows 7, the default value of the GDIProcessHandleQuota registry entry is 10000.
-
This wizard may be in English only. However, the automatic fix also works for other language versions of Windows.
-
If you are not using the computer that has the problem, save the Fix it solution to a flash drive or a CD and then run it on the computer that has the problem.
Then, go to the "Did this fix the problem?" section.
Let me fix it myself
To resolve this issue, change the value of the GDIProcessHandleQuota registry entry. To do this, follow these steps:
-
In Windows Vista or in Windows 7, click Start
If you are prompted for an administrator password or for confirmation, type the password, or provide confirmation.
In Windows XP, click Start, click Run, type regedit in the Open box, and then click OK. -
Locate and then click the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Windows
-
Click GDIProcessHandleQuota.
-
On the Edit menu, click Modify.
-
In the Value data box, type a number that is greater than the current value, and then click OK.
-
Exit Registry Editor.
-
Restart the computer.
Did this fix the problem?
-
Check whether the problem is fixed. If the problem is fixed, you are finished with this section. If the problem is not fixed, you can contact support.
-
We would appreciate your feedback. To provide feedback or to report any issues with this solution, please leave a comment on the "Fix it for me" blog or send us an
email.
