I know the usual method of creating calculated field in a pivot, however I am working with a large dataset and need to create 40 calculated fields. I am wondering if it is possible to define all 40 formulae in a worksheet and let excel create the calculated fields for the pivot from there ..any...