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.

Embedded Excel worksheets shrink when you edit them in PowerPoint


View products that this article applies to.

Symptoms

In Microsoft PowerPoint, when you edit an embedded Microsoft Excel worksheet, the worksheet object resizes itself.

↑ Back to the top


Cause

This problem occurs when your video resolution is 1024 x 768 pixels or lower.

↑ Back to the top


Resolution

To resolve this problem, obtain the latest service pack for Microsoft Office 2000. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
276367 How to obtain the latest Office 2000 service pack
After you apply the latest Microsoft Office 2000 service pack, create the QFE_Nice and the QFE_Ontario registry entries to resolve this issue. This fix is also included in Excel 2002, Excel 2003, and Excel 2007. To enable the fix in these products, you can also use the following procedure.

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows
To do this:

  1. Exit Excel, if Excel is running.
  2. Click Start, and then click Run.
  3. In the Open box, type regedit, and then click OK.
  4. Depending on the version of Excel that you are using, verify that the following registry subkey exists.

    Note If the registry subkey does exist, go to step 5.

    Excel 2000
    HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options\
    Excel 2002
    HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options\
    Excel 2003
    HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options\
    Excel 2007
    HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options\
  5. If the registry key path does not exist, create the registry key path. To create the registry key path, locate and then select the following registry key:
    HKEY_CURRENT_USER\Software\Microsoft
    1. Click the Edit menu, click New, and then click Key.
    2. Type Office, and then press ENTER.
    3. Click the Edit menu, click New, and then click Key.
    4. For Excel 2000, type 9.0, and then press the ENTER.

      Note Type the following values, depending on the version of Excel that you use, and then press ENTER:
      • For Excel 2002, type 10.0.
      • For Excel 2003, type 11.0.
      • For Excel 2007, type 12.0.
    5. Click the Edit menu, click New, and then click Key.
    6. Type Excel, and then press the ENTER.
    7. Click the Edit menu, click New, and then click Key.
    8. Type Options, and then press the ENTER.
  6. Click the Edit menu, click New, and then click DWORD Value.
  7. Type the following name for the new value:
    QFE_NICE
  8. Press ENTER.
  9. Right-click the new DWORD value name, and then click Modify.
  10. In the Value data box, type 1 and then click OK.
  11. Repeat steps 5 through to step 9, and then substitute the registry DWORD value QFE_NICE with the following registry DWORD value:
    QFE_ONTARIO
  12. Exit Registry Editor.


↑ 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 2000 Service Pack 3 (SP-3).

↑ Back to the top


Keywords: kbhotfixserver, kbqfe, kbbug, kbfix, kboffice2000presp3fix, kboffice2000sp3fix, KB300523

↑ Back to the top

Article Info
Article ID : 300523
Revision : 4
Created on : 5/8/2008
Published on : 5/8/2008
Exists online : False
Views : 592