Embedded Excel worksheets shrink when you edit them in PowerPoint

Symptoms

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

Cause

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

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.


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).
Proprietăți

ID articol: 300523 - Ultima examinare: 8 mai 2008 - Revizie: 1

Feedback