How to get rid of GETPIVOTDATA function?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rafal Hemmerling - 26 Oct 2007 09:56 GMT

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

Reply to this Message

Bob Umlas - 26 Oct 2007 13:58 GMT

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

> Hello,
>
[quoted text clipped - 7 lines]
>
> Rafal

Reply to this Message

Debra Dalgleish - 26 Oct 2007 22:29 GMT

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.

> 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?

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message