Microsoft KB Archive/215959

= XL2000: PivotChart Report Loses Data When Pasted to a New Workbook =

Article ID: 215959

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q215959



SYMPTOMS
When you copy a range of cells that contain a PivotChart report, and paste the range into a new workbook, the data in the chart is missing.



CAUSE
This issue occurs when the Clipboard toolbar contains an item and you paste the range containing the PivotChart report into a new workbook using the Clipboard toolbar.



WORKAROUND
To work around this issue, do not use the Clipboard toolbar to paste a range of cells containing a PivotChart report into a new workbook. Instead, use another method to paste, for example click Paste on the Edit menu.



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



MORE INFORMATION
When you paste a PivotChart report into a different workbook, Excel pastes a static chart containing data into the new workbook, and the chart ceases to be a PivotChart report. When you paste a PivotChart report into the same workbook you copied it from, the pasted chart remains a PivotChart report.

