A linked Excel 2000 chart may be truncated in Word 2000 and PowerPoint 2000 (257448)


The information in this article applies to:

  • Microsoft Excel 2000, when used with:
    • the operating system: Microsoft Windows 2000
    • the operating system: Microsoft Windows NT 4.0
  • Microsoft PowerPoint 2000, when used with:
    • the operating system: Microsoft Windows 2000
    • the operating system: Microsoft Windows NT 4.0
  • Microsoft Word 2000, when used with:
    • the operating system: Microsoft Windows 2000
    • the operating system: Microsoft Windows NT 4.0
This article was previously published under Q257448

IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

SYMPTOMS

After you link to a Microsoft Excel 2000 chart in Microsoft Word 2000 or Microsoft PowerPoint 2000, the chart may be truncated.

CAUSE

This problem occurs when the following conditions are true:
  • You copy an Excel chart sheet.

    -and-

  • You switch to Word or PowerPoint.

    -and-

  • You click Paste Special on the Edit menu and then click Paste Link in the Paste Special dialog box.

    -and-

  • Your computer is running Microsoft Windows NT version 4.0 or Microsoft Windows 2000.

WORKAROUND

To work around this problem, use one of the following methods before you copy the chart.

NOTE: After you use one of these methods, the chart is not truncated when you use the Paste Link command.

Method 1: Select "Sized with Window"

  1. In Microsoft Excel , click to activate the chart on the chart sheet.
  2. On the View menu, click Sized with Window.

Method 2: Move the Chart to a Worksheet as a Chart Object

  1. In Microsoft Excel, click to activate the chart on the chart sheet.
  2. On the Chart menu, click Location.
  3. In the Chart Location dialog box, click the As object in button.
  4. In the box to the right of As object in, select the worksheet where you want to insert the chart, and then click OK.

Method 3: Install Service Release 1 (SR-1) and Modify the Windows Registry

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

You may be able to resolve this problem by following these steps.
  1. Quit all Windows programs.
  2. Install Microsoft Office 2000, Service Release 1 (SR-1).For additional information about how to obtain Service Release 1 (SR-1), click the article number below to view the article in the Microsoft Knowledge Base:

    245025 OFF2000: How to Obtain and Install Office 2000 SR-1/SR1a Update

  3. After Service Release 1 (SR-1) is installed, click Start, and then click Run. In the Open box, type regedit, and then click OK to run Registry Editor.
  4. Locate and select the following key (folder) in the left pane of Registry Editor:

    HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\9.0\Excel\Options

  5. On the Edit menu, point to New, and then click DWORD Value. Type QFE_Nice to rename the value. Then, double-click the QFE_NICE value, and type 00000001 in the Value data box. Click OK.
  6. On the Registry menu, click Exit.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

REFERENCES

For more information about Excel charts, click Microsoft Excel Help on the Help menu, type chart in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For additional information about Excel objects that appear truncated when you paste them in PowerPoint, click the article number below to view the article in the Microsoft Knowledge Base:

278543 OFFXP: PPT2002: Excel Objects Appear Truncated When You Paste Them in PowerPoint

For additional information about Excel objects that appear truncated, click the article number below to view the article in the Microsoft Knowledge Base:

189279 OFF97: Excel Objects Appear Truncated

Modification Type:MinorLast Reviewed:11/23/2004
Keywords:kbbug kbfix KB257448
©2004 Microsoft Corporation. All rights reserved.