How to get rid of GETPIVOTDATA function?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

while addressing cells in a spredsheet from PivotTable Excel 2007 always
puts GetPivotData functionautomatically instead, like old versions, simply
addressing cells (like =B3 or simillar). It makes my formulas very long and
not possible to understand. I wonder if I can switch off this automatic
functuion and tell Excel to address cells just by they simple address?
Thanks

Rafal
 
Office button/Excel Options/Formulas/2nd section: deselect "Use GetPivotData
functions..."
 
The Generate GetPivotData command is also on the Ribbon:

Select a cell in the pivot table
On the Ribbon, click the Options tab
At the far left, in the PivotTable group, click the arrow on the Options
command
Click Generate GetPivotData, to remove the check mark.
 
Back
Top