.PivotItems("(blank)").Visible = False, Not Working

[mrshl9898]

Hi there,

I cannot successfully filter out (blank) in a Pivot Field. Has anyone experienced this before?

It's working several times in my macro, but fails on a particular field "Receiver".

Checked spelling, it all looks fine, even filtered N/A successfully.

Any help would be much appreciated.

With Sheets("SummaryPivot").PivotTables("PivotTable3").PivotFields("Receiver")
.PivotItems("(blank)").Visible = False '''''''''''''''''''''''''
.PivotItems("#N/A").Visible = False
End With

 

[mrshl9898]

bump

 

[MaroManRS305]

I'm currently having this issue and cannot resolve it. Has anyone found a solution? Thank you!

 

[MaroManRS305]

Anyone??

 

[MaroManRS305]

[SOLVED] I figured it out. Had to specify the field that the item resides in (.PivotFields("index")) prior to the .PivotItems("(blank)").Visible = False. Thanks for the all the help guys...

 

[allansanjan]

[SOLVE] i encountered same problem. try PivotItems("").Visible = False