Pivot table formulas

S

sduffield

How do I delete the calculated fields that I added to a pivot table? The
field list for the pivot table doesn't seem to be modifiable.

Thanks,
Sduffield
 
J

Jim Thomlinson

How you do it depends on which version of XL you have but essentially the
spot where you created the calculatied field is the same spot where you will
delete it.

Pivot table | Formulas | Calculated Fields
Select the Calculated Field and then hit the delete button
 

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

Delete Pivot Table Formula 1
Delete calculated field 1
how do I remove #DIV/0! in a pivot table calculation field ? 2
Calculates field in pivot table 2
Pivot Table criteria 2
Problem inserting calculated pivot fields into Pivot Table (2007) 1
Pivot table filter list - listing irrelevant subcategorys 1
Limitations for Calculated Field formulas in Pivot Tables 1

Top