Article ID: 980528 - View products that this article applies to.
Expand all | Collapse all

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 it button or link. Click Run in the File Download dialog box, and follow the steps in the Fix it wizard.

Fix this problem
Microsoft Fix it 50515


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
    Collapse this imageExpand this image
    the Start button
    , type regedit in the Start Search box, and then press ENTER.

    Collapse this imageExpand this image
    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.

Properties

Article ID: 980528 - Last Review: August 26, 2011 - Revision: 3.2
APPLIES TO
  • Microsoft Excel 2010
Keywords: 
kbtshoot kbsurveynew kbexpertiseinter kbprb kbfixme kbmsifixme KB980528

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com