If PivotItem.Visible issues

[bjorgen]

I am building a procedure to save filter values and to do so I would test the pivot field's pivotitems to see if they were visible.

When I run

if pi.visible = true then
yadda yadda
Else
End if

pi.visible is always false, even when the pivot item is visible. I found this out in debug mode. This then gives me the incorrect outcome.

I tried adding

With pf
.autosort xlmanual, .sourcename
end with

I saw that snipped in a couple of forums asking the same question and I still had the same problem.

I'm running Excel 2010.

Any help is highly appreciated!

 

[bjorgen]

I did a test where I filtered the Pivot Table programatically vs manually and when I filtered it manually it worked and when I filtered it programatically it didn't work.

Thoughts?

 

[bjorgen]

Bump, any ideas here?