Hey everyone,

I am trying to link pivot table info to a text box. I get an error every time.

I can only get it to work in a cell. Pivot table is on different worksheet.

Formula shows as:

=GETPIVOTDATA("XX",PIVOT!$A$6,"Unit","XXX","EQUIP Type","XXX")

I removed the column and row names in the above.

Please help.

Thanks,
Shane