Restart a Pivot Table in one go

If you want to clear all the fields from a Pivot Table you can use the clear all option.

On the PivotTable Analyze or Analyze tab click the Clear drop down and select Clear All.

 

This removes all the fields and allows you to start again from scratch.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.