Pivot table: calculation outside

N

Nikolaus Hiebaum

Hi folks,

Ever since transferring to Office 2000, I have encountered a new
behavior of pivot tables with formulas outside the pivot table. It's
kinda hard to explain it, but I'll try.

So, I have this pivot table and want to use one or more of the figures
for a calculation *outside* the Pivot. With Excel 97 if I linked one of
the figures, it would be something like this =C17*5 and I was able to
pull down this formula when I wanted to multiplay all figures of the C
column with five.

Since Excel 2000, however, I get something like this
=PIVOTDATENZUORDNEN("Dauer";$C$30;"Name Angerufener";"Murmi"), and when
I "pull down" a formula composed of such a value it doesn't adapt to the
new value. It stays. Is there a way to mimic the old behavior?
 
D

Debra Dalgleish

You can change this setting, or you can type an equal sign, and type the
cell reference, instead of clicking on the cell to reference it.

To change the setting --
Choose Tools>Customize
Select the Data category on the Commands tab
Near the end of the commands list, select Generate GetPivotData
Drag the command to one of your toolbars
Click Close

Use this button to toggle the feature on and off.
 
Top