An Excel 2010 workbook does not work correctly if the workbook contains many OLE objects, ActiveX controls, or form controls

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:

  1. In Windows Vista or in Windows 7, click Start the Start button , type regedit in the Start Search box, and then press ENTER.

    User Account Control permission
    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.

  2. Locate and then click the following registry subkey:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Windows

  3. Click GDIProcessHandleQuota.

  4. On the Edit menu, click Modify.

  5. In the Value data box, type a number that is greater than the current value, and then click OK.

  6. Exit Registry Editor.

  7. 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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×