Pivot table calculated field

  • Thread starter Thread starter San
  • Start date Start date
S

San

As in XL 2000 I did not see calculated field when I right
click on pivot table? Also what XL XP pivot table can do
more than XL 2000 . Any insight will be appreciated. Thanks
San
 
To create a calculated field, on the Pivot menu choose
PivotTable>Formulas>Calculated Field.

To see what was added in Excel 2002:

What's New for Microsoft Excel 2002 Developers

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaxl10/html/xlWhatsNew.asp

You can download a product guide, which includes the changes to PivotTables:
http://www.microsoft.com/office/excel/evaluation/guide.asp

These MSKB article outline the limits for Excel 2000 and Excel 2002:

XL2000: Limits of PivotTables in Microsoft Excel 2000
http://support.microsoft.com/default.aspx?scid=kb;EN-CA;211517

XL2002: Limits of PivotTables in Microsoft Excel 2002
http://support.microsoft.com/default.aspx?scid=kb;EN-CA;291061
 
Back
Top