Pivot Table new items as bold

[jale]

Hi everybody

After every refreshing dynamic pivot table ,is it possible to see as bold
,new or changed records.

Thanks for advance.

 

[Frank Kabel]

Hi jale
AFAIK that is not possible/directly supported by pivot tables.

Frank
P.S.: one idea (though not tested / verified):
- use VBA to do this (e.g. create a specific button for this)
- Prior to the refresh copy the old pivot data to a (hidden) sheet with
VBA
- Do the refresh
- Copare cell by cell (also with VBA) and tag/highlight the changed
cell

 

[jale]

Thanks I will try it.

Hi jale
AFAIK that is not possible/directly supported by pivot tables.

Frank
P.S.: one idea (though not tested / verified):
- use VBA to do this (e.g. create a specific button for this)
- Prior to the refresh copy the old pivot data to a (hidden) sheet with
VBA
- Do the refresh
- Copare cell by cell (also with VBA) and tag/highlight the changed
cell