Pivot table only updates via VBA when sheet is active

[Glory]

With Sheet6
        
        .PivotTables("PivotTable2"). _
            PivotFields("Name").CurrentPage = "Text"
 
End With

This code is not working. If I change "Sheet6" to "ActiveSheet" and activate Sheet6, it works just fine.

I don't want to have to activate all the sheets that I'm going to be working with. Is there any way to fix this code?

 

[Glory]

bump

 

[Glory]

bump

Edit: You know, come to think of it, when I "PrintOut" the pivot reports I think that the sheets are being activated anyway, so maybe it doesn't really matter if I activate the sheets first and just do it that way.

If anybody has any input to offer on this that'd be great, but otherwise I guess I know what I'm gonna do.

 

[Marcelo Branco]

Hi Glory,

Your code worked perfectly for me - i havent faced any problem with something like this

Sheet1.Activate
With Sheet4

.PivotTables("PivotTable1"). _
PivotFields("Code").CurrentPage = "1"

End With

So, i dont know how to help you...

M.