Hi guys,
I made few pivot tables in my DASHBOARD-sheet and would like to unmark all blank, empty and #N/A values in the filters, columns and rows each time when the pivot tables get a refresh.
Could anyone help me with this?
Is there any setting in the pivot option or a macro to accomplish that?
I don't want to replace these values by a specific value.(Ex. PivotTable Options, Format, For empty cells show:..... Is not really the solution I'm searching for)
Huge thanks in advance.
I made few pivot tables in my DASHBOARD-sheet and would like to unmark all blank, empty and #N/A values in the filters, columns and rows each time when the pivot tables get a refresh.
Could anyone help me with this?
Is there any setting in the pivot option or a macro to accomplish that?
I don't want to replace these values by a specific value.(Ex. PivotTable Options, Format, For empty cells show:..... Is not really the solution I'm searching for)
Huge thanks in advance.