Hello,
I always always use the same pivot table formating, checking 3 things before using it:
- Repeat item labels
- Show in Tabular Format
- Hide Subtotals
I know 3 clicks doesn't sound time consuming, but when you are working with pivot tables all day it can be.
I tried recording macro , but the result macro take more time than when done manually.
Can this formatting be by default? or is there VBa macro to help with it?
Any help appreciated, thanks
I always always use the same pivot table formating, checking 3 things before using it:
- Repeat item labels
- Show in Tabular Format
- Hide Subtotals
I know 3 clicks doesn't sound time consuming, but when you are working with pivot tables all day it can be.
I tried recording macro , but the result macro take more time than when done manually.
Can this formatting be by default? or is there VBa macro to help with it?
Any help appreciated, thanks