View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
king60611 king60611 is offline
external usenet poster
 
Posts: 9
Default GETPIVOTDATA Question

I'm trying to reference pivot table cells in another worksheet; a direct cell
reference doesn't work because the data is ever-changing. I figured out the
formula if I'm in the same tab, but not from a secondary worksheet.

The same-tab formula is: =GETPIVOTDATA("Budget",$A$4,"Office","ATL")

How do I re-write that to work from another worksheet? I have many others
to do, but I need the basic structure to follow.

Thanks for your help.