XL2000: PivotChart Report Loses Data When Pasted to a New Workbook (215959)
The information in this article applies to:
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.
STATUSMicrosoft 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.
REFERENCESFor more information about the Clipboard, click Microsoft Excel Help on the
Help menu, type clipboard in the Office Assistant or
the Answer Wizard, and then click Search to view the topics
returned.
| Modification Type: | Major | Last Reviewed: | 9/25/2003 |
|---|
| Keywords: | kbbug kbnofix KB215959 |
|---|
|