Hi.
Such an useful function GETPIVOTDATA() is, but it is SO unreliable.
Let me give you an example:
GETPIVOTDATA(PivotTable1,"*** 502 Sum of NPols")
works fine while
GETPIVOTDATA(PivotTable1,"IB 502 Sum of NPols")
does not.
Complete mystery. Before anyone asks, yes, there were values to be picked out in both cases, I kept on getting N/A and I have no idea why.
RET79
Such an useful function GETPIVOTDATA() is, but it is SO unreliable.
Let me give you an example:
GETPIVOTDATA(PivotTable1,"*** 502 Sum of NPols")
works fine while
GETPIVOTDATA(PivotTable1,"IB 502 Sum of NPols")
does not.
Complete mystery. Before anyone asks, yes, there were values to be picked out in both cases, I kept on getting N/A and I have no idea why.
RET79