You are currently offline, waiting for your internet to reconnect

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

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

  • 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 Startthe 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.
fixit fix it

Article ID: 980528 - Last Review: 08/26/2011 22:12:00 - Revision: 3.2

  • Microsoft Excel 2010
  • kbtshoot kbsurveynew kbexpertiseinter kbprb kbfixme kbmsifixme KB980528