XL2000: Undo Unavailable After Creating PivotChart Report

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.

This problem occurs when you do all of the following:

1. You create a PivotChart from a PivotTable.
   
   -and-
2. You delete either the cells, rows, or columns containing the PivotTable report.
   
   -and-
3. You try to undo the Delete command.

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

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.

For more information about creating a PivotChart Report, click Microsoft Excel Help on the Help menu, type Create a PivotChart report in the Office Assistant or the Answer Wizard, and then click Search to view the topic.