XL2000: Undo Unavailable After Creating PivotChart Report

• Microsoft Excel 2000

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-



2. You delete either the cells, rows, or columns containing the PivotTable report.
   
   -and-



3. You try to undo the Delete command.

STATUS

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

REFERENCES

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.

Additional query words: XL2000 grayed disabled dimmed greyed

Keywords : kbdta kbchart xlpivot
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug