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.

Financial Modelling with Scenarios

A great webinar recording from Danielle Stein Fairhurst from Plum Solutions and Thomas Paul from BDO.

A flexible technique to handle lots of different variables in a model using data tables.

Macro question – Slicer solution

Slicers are a very flexible filtering option and can control multiple pivots – even power pivots!

Always happy to help.