Formulas in Pivot Tables

G

Guest

I just upgraded to Excel XP, and I can no longer do formulas in Pivot tables.
(In Excel 2000, right click in Pivot Table, then "Formulas", then
"Calculated Field" or "Calculated Item"). There is no "Formulas" optin in
Excel 2003.

Any ideas?
 
D

Debra Dalgleish

I just upgraded to Excel XP, and I can no longer do formulas in Pivot tables.
(In Excel 2000, right click in Pivot Table, then "Formulas", then
"Calculated Field" or "Calculated Item"). There is no "Formulas" optin in
Excel 2003.

Any ideas?
Click to expand...
 

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

Calculates field in pivot table 2
Limitations for Calculated Field formulas in Pivot Tables 1
Pivot Table criteria 2
Insert Calculated Field in a Pivot Table 1
how do I remove #DIV/0! in a pivot table calculation field ? 2
Problem with Calculated item in Pivot Table 1
Pivot table, IF function, calculated item versus calculated field 1
Pivot tables calculated fields 2

Top