Is there a way to retrieve data from a PivotTable if the data isn't currently
visible? I can use GetPivotData, but when the table fileds are re-arranged,
the GetPivotData formula fails because the fields aren't currently visible.

Any way around this?