remove a calculated field from a pivot table in Excel 2003

N

NEvans009

Can anyone tell me how to remove a large number of calculated fieldse from a
pivot table in Excel 2003 ? Thanks.
 
V

vitruvian

Can anyone tell me how to remove a large number of calculated fieldse from a
pivot table in Excel 2003 ? Thanks.
Click to expand...

Hi NEvans,



Open the PivotTable you are using, and if you have the PivotTable
toolbar (if not goto View > Toolbars > PivotTable)

This will delete the calculation (you will not be able to get it
back... Look at the next one if this is not what you want)
Select PivotTable > Formulas > Calculated Field

Select the one you want to delete from the drop down list and click
Delete then click OK

And it shall be removed


If you only want to remove it from the PivotTable so you cant see it
in the table, you should have a drop-down list called "Data" or
something similar... look for the name that corresponds to the one
that you want to remove, and deselect it from the drop down list and
click OK


Hope this is what you are after
 
N

NEvans009

Thanks. I was hoping to delete many fields at once but atleast I can start
the process off 1 by 1.
 
D

Debra Dalgleish

You could remove the fields with a macro. For example:

Sub RemoveCalsFields()
Dim pt As PivotTable
Dim pf As PivotField

Set pt = ActiveSheet.PivotTables(1)

For Each pf In pt.CalculatedFields
pf.Delete
Next pf

End Sub
 
Top