PIVOT Table

[Guest]

How do I make a reference value in a Pivot table? If I make a reference and
then changes the layout Ill at a #REFERENCE! message.
In the earlier versions of Excel I believe it was possible to make an
ordinary reference to a value in a pivot table and rearrange the layout
without problems

 

[Debra Dalgleish]

When you link to a pivot table cell in Excel 2002 or later version, a
GetPivotData formula is automatically created, instead of a normal link.

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