Microsoft KB Archive/199269

= XL2000: Undo Unavailable After Creating PivotChart Report =

Article ID: 199269

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q199269



SYMPTOMS
The Undo command may be unavailable on the Edit menu when you are working with a PivotTable or PivotChart, and you delete the cells containing the PivotTable report.



CAUSE
This problem occurs when you do all of the following:


 * 1) You create a PivotChart from a PivotTable.

-and-
 * 1) You delete either the cells, rows, or columns containing the PivotTable report.

-and-
 * 1) You try to undo the Delete command.



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



MORE INFORMATION
In Microsoft Excel, you can create a PivotChart report to represent the data displayed in your PivotTable report. A PivotChart combines the interactive summarization of data provided by the PivotTable with the visual benefits of a Microsoft Excel chart. With a PivotChart you can quickly change the view of the chart to see comparisons and trends by moving fields to different categories, or filtering data in a page field. However, if you delete the data in a PivotTable report after creating a PivotChart from the PivotTable data, the Undo command on the Edit menu will be unavailable.

