How to get rid of GETPIVOTDATA function?

R

Rafal Hemmerling

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
 
B

Bob Umlas

Office button/Excel Options/Formulas/2nd section: deselect "Use GetPivotData
functions..."
 
D

Debra Dalgleish

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.
 
Top