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

• Microsoft Excel 2000

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 this to be a problem in the Microsoft products 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.

REFERENCES

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.

Additional query words: XL2000

Keywords :
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug