Hi,

In 2003 - add the GetPivotData toolbar button to the PivotTable toolbar and
then you can toggle this feature on and off. To add the button choose View,
Toolbars, Customize, Commands tab, Data category, and scroll to the bottom of
the list of buttons, drag the above mentioned tool to the toolbar.

In 2007 - Choose PivotTable Tools, Options, open the Options drop down and
choose Generate GetPivotData. You can add this button to the QAT by right
clicking it and choosing Add to Quick Access Toolbar.

In 2003 & 2007 - don't click in the pivot table as you build your formula,
instead type the cell reference manually, for example, type =C10 rather than
clicking on C10.

--
Cheers,
Shane Devenshire


"Dinesh" wrote:

How do you turn off the long references when you linked to Pivot table cell?