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