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

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

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.

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  (http://support.microsoft.com/kb/245025/EN-US/ ) 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.

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

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: For additional information about Excel objects that appear truncated, click the article number below to view the article in the Microsoft Knowledge Base: