ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pivot Table in Excel 2002 XP - Calculated Fields (https://www.excelbanter.com/excel-programming/291230-pivot-table-excel-2002-xp-calculated-fields.html)

John Flynn[_2_]

Pivot Table in Excel 2002 XP - Calculated Fields
 
there was a picot table feature in Excel office 2000
called calculated fields. I can't find it in excel 2002.
Does it still exist and how do I find it.

Thanks,

John

Ken Wright

Pivot Table in Excel 2002 XP - Calculated Fields
 
Display the Pivot Table Toolbar using View / Toolbars / Pivot Table, then hit
the big button that says PivotTable / Formulas / Calculated Field

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"John Flynn" wrote in message
...
there was a picot table feature in Excel office 2000
called calculated fields. I can't find it in excel 2002.
Does it still exist and how do I find it.

Thanks,

John



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.583 / Virus Database: 369 - Release Date: 10/02/2004




All times are GMT +1. The time now is 10:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com