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

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.

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.

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.

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

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.

For 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.