Top Tip on 17th March 2014
#Pivots – Stop Pivots retaining old data no longer referenced
R-click, PivotTable Options, Data tab, Number items to retain per field=None
1 January
#Pivots – Stop Pivots retaining old data no longer referenced
R-click, PivotTable Options, Data tab, Number items to retain per field=None