Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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.

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


Keywords: kboffice2003presp1fix, kbhotfixrollup, kbfix, kbbug, kbqfe, kboffice2003sp1fix, kb, kbnotautohotfix, kbentirenet

↑ Back to the top

Article Info
Article ID : 838006
Revision : 3
Created on : 3/30/2017
Published on : 3/30/2017
Exists online : False
Views : 368