GETPIVOTDATA

[John Smith]

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

 

[Debra Dalgleish]

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