Controls on an Excel 2003 or Excel 2010 worksheet change size after you change the screen resolution

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

On This Page

Symptoms

When you change the display resolution while Microsoft Office Excel 2003 or Microsoft Excel 2010 is running, controls change size when you click them. For example, this problem may occur with the command button. The controls become larger or smaller.

Resolution

This problem was first fixed in a hotfix that is now contained in a service pack. If you installed the latest Office 2003 service pack, you do not have to install the hotfix.

Service pack information

This problem is corrected in Office 2003 Service Pack 1.
To resolve this problem, obtain the latest service pack for Microsoft Office 2003. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
870924 How to obtain the latest service pack for Office 2003

Hotfix information

How to obtain the hotfix

This issue is fixed in the Microsoft Office 2003 Hotfix Package March 18, 2004. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
835704 Description of Office 2003 hotfix package: March 18, 2004
After you install this hotfix, follow the steps that are listed in the "More Information" section of this article to set the UpdateDeviceInfoForEmf registry key and to activate the hotfix.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
This problem was first corrected in Microsoft Office 2003 Service Pack 1.

More information

To use this hotfix for Excel 2003, follow these steps:
  1. Exit all the programs that are running.
  2. Click Start, and then click Run.
  3. In the Open box, type regedit, and then click OK.
  4. Locate, and then click the following registry key:
    HKEY_CURRENT_USER\Software\microsoft\office\11.0\common
  5. On the Edit menu, point to New, and then click Key.
  6. Type Draw, and then press Enter.
  7. On the Edit menu, point to New, and then click DWORD value.
  8. Type UpdateDeviceInfoForEmf, and then press Enter.
  9. Right-click UpdateDeviceInfoForEmf, and then click Modify.
  10. In the Value data box, type 1, and then click OK.
  11. On the File menu, click Exit to close Registry Editor.
To resolve this problem for Excel 2010, follow these steps:
  1. Exit all the programs that are running.
  2. Click Start, click Run, in the Open box, type regedit, and then click OK.
  3. Locate, and then click the following registry key:
    HKEY_CURRENT_USER\Software\microsoft\office\14.0\common
  4. On the Edit menu, point to New, and then click Key.
  5. Type Draw, and then press Enter.
  6. On the Edit menu, point to New, and then click DWORD value.
  7. Type UpdateDeviceInfoForEmf, and then press Enter.
  8. Right-click UpdateDeviceInfoForEmf, and then click Modify.
  9. In the Value data box, type 1, and then click OK.
  10. On the File menu, click Exit to close Registry Editor.

Properties

Article ID: 838006 - Last Review: September 10, 2012 - Revision: 3.0
Applies to
  • Microsoft Excel 2010
  • Microsoft Office Excel 2003
Keywords: 
kbqfe kboffice2003sp1fix kbbug kbfix kbhotfixrollup kboffice2003presp1fix KB838006

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