Pivot table: calculation outside

  • Thread starter Thread starter Nikolaus Hiebaum
  • Start date Start date
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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Data From a Pivot Table to autofill 2
Pivot Table - Compare Dates & calc. % 1
Pivot table question 3
Problem with Calculated item in Pivot Table 1
Problem inserting calculated pivot fields into Pivot Table (2007) 1
Count outside of pivot table 2
how do I remove #DIV/0! in a pivot table calculation field ? 2
Rows disappear in pivot table 1

Back
Top