Pivot Table new items as bold

  • Thread starter Thread starter jale
  • Start date Start date
J

jale

Hi everybody

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

Thanks for advance.
 
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
 
Thanks I will try it.


Frank Kabel said:
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
Click to expand...
 
Back
Top