Thanks for your response, but I am still at a loss:

If i use this formula:
=GETPIVOTDATA("3Q06",$A$3,"Linking - Building code","11")
It will return the correct answer of 405.

However, if i simply change the "11" to the cell reference J2 (which
contains the number 11), i get the error #ref.

=+GETPIVOTDATA("3Q06",$A$3,"Linking - Building code",J2)

Is there some syntax that I am missing????

"Debra Dalgleish" wrote:

While creating the formula, you should be able to go to Sheet 1 and
click on the cell that you want to reference. Using your example, where
the "11" is a cell reference on Sheet 1:

=GETPIVOTDATA("3Q06",$A$3,"Linking - Building code",'Sheet 1'!J2)

Spidey wrote:
I am or have been attempting to extract data from a pivot table. I would
like to use a reference in "sheet 1" cell $A1 as the "item" in the
getpivotdata (the pivot table is in a separate sheet) formula below.

=GETPIVOTDATA("3Q06",$A$3,"Linking - Building code","11")

=GETPIVOTDATA(data_field,pivot_table,field1,item)

all my efforts have resulted in #ref results.

Any insight would be greatly appreciated



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html