Help and Support

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

Article ID:257448
Last Review:November 23, 2004
Revision:4.1
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 (http://support.microsoft.com/kb/256986/EN-US/) Description of the Microsoft Windows Registry
On This Page

SYMPTOMS

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

Back to the top

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.

Back to the top

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.

Back to the top

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.

Back to the top

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.

Back to the top

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.

Back to the top

STATUS

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

Back to the top

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 (http://support.microsoft.com/kb/278543/EN-US/) 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 (http://support.microsoft.com/kb/189279/EN-US/) OFF97: Excel Objects Appear Truncated

Back to the top


APPLIES TO
Microsoft Excel 2000 Standard Edition, when used with:
  Microsoft Windows 2000 Standard Edition
  Microsoft Windows NT 4.0
Microsoft PowerPoint 2000 Standard Edition, when used with:
  Microsoft Windows 2000 Standard Edition
  Microsoft Windows NT 4.0
Microsoft Word 2000 Standard Edition, when used with:
  Microsoft Windows 2000 Standard Edition
  Microsoft Windows NT 4.0

Back to the top

Keywords: 
kbbug kbfix KB257448

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.