View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Fern Fern is offline
external usenet poster
 
Posts: 4
Default getpivotdata in excel 2007

=+GETPIVOTDATA(pivot1,$A$3 & " " &B$2 & " " &A5)

I'm trying to return pivot table data to another sheet. The range of the
pivot table is called "pivot1" and the reference cells represent (name of
doc), (date), (procedure type). I get a REF#
I have spent hours already and need a solution fast.

Please