Macro to unfilter values in a Pivot Table

[Maci3j]

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.