GETPIVOTDATA
 

When I clicked one of the cells in the pivot table, it
comes like the following:
=GETPIVOTDATA("% DAY",$A$6,"Code","V"). How do I get the
cell references like E3 instead.

Thanks
John

GETPIVOTDATA
 

There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off:

http://www.contextures.com/xlPivot06.html

John Smith wrote:
When I clicked one of the cells in the pivot table, it
comes like the following:
=GETPIVOTDATA("% DAY",$A$6,"Code","V"). How do I get the
cell references like E3 instead.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html