How to delete a PivotTable or PivotChart report in Microsoft Excel 2010 on Windows Vista

Think complex calculations and the most obvious thought, which strikes the mind is to make use of Microsoft Excel 2010. While working on a Microsoft Excel what can further ensure greater efficacy and accuracy while averaging or summing up your data is the use of a PivotTable. This feature not only carries the calculus in an efficient manner but also reflects it in an adjoining table. While it is a great number crunching tool, at times you might want to exercise some discretion while sharing your data. In this case, you will need to delete the PivotTable. However, while doing so the PivotTable report may not get deleted. So, you need to go a step ahead and delete the associated report too, in order to ensure that all that is being shared is the larger data without the analysis drawn through the PivotTable while working on your Windows Vista PC. Let us see how:

FOR DELETING A PIVOTTABLE REPORT

1. Click the PivotTable report.
2. Click on the “Options” tab, in the “Actions” group, click “Select”, and then click “Entire PivotTable”.
3. Press “DELETE”.

FOR DELETING A PIVOTCHART REPORT

1. Select the PivotChart report.
2. Press “DELETE”.