Track Changes in a Pivot Table

[Cinta B]

Hi Excel people out there!

I couldn't find anything on the forum about tracking changes in pivot table or if this is possible at all. So I need ideas regarding this matter. I could track changes in a normal range but once I pivot the table, the track changes button is grayed out. Any help is great, thanks.

 

[GraH - Guido]

Don't know about tracking changes in Excel. It is only available when using a shared workbook if I'm not mistaken (for older versions). If the option is then greyed out, it simply means it is not possible in the given context. The point of tracking changes is accepting or rejecting the change. In a pivot, since it is connected to data, that sounds rather illogic.

For not shared workbooks a cumbersome alternative is making 2 pivots, on the same data, but not sharing the same cache.
Where Pivot 2 values are <> Pivot 1 => those are your changes.

Next time around: you refresh Pivot 1 on the "old" data. Then update the data. Then update only pivot 2.

To invoke a new pivot cache, do not copy the pivot but use ALT + D + P to create the 2nd pivot.

Simple example attached.

But obviously you can't work like that in a shared workbook.

 

[Cinta B]

Thank you so much for the explanation!