VBA/macro to hide,uncheck "(blank)" in pivot tables when refreshing

[PLwolves87]

hi all,

please help i have search and tried nearly everyone suggestions with no luck at all.

i have a workbook and the sheet with all the pivot tables is named ("Tables_outbound") on this sheet i have a total of of 11 pivot tables, the pivot tables names are ("PTABLE1") , ("PTABLE2") until we get to ("PTABLE11")

i then have refresh icon which i want to click, and then it will update all of my pivot tables with the new data and then remove the "(blank)" for each of the 11 pivot tables.

the pivotfield names are below but when i have attempted this i get an error message about the pivotfield not found or something.

PTABLE1 - "Account"
PTABLE2- "Account2"
PTABLE3- "Account3"
PTABLE4- "DATE"
PTABLE5- "DATE2"
PTABLE6- "Account4"
PTABLE7- "STATUS"
PTABLE8- "Account5"
PTABLE9- "STATUS2"
PTABLE10- "Account6"
PTABLE11 -"Account7"


please help thanks

 

[GlennUK]

Show your VBA code. And definitely take a screen-shot of the error message, and post that too.