Calculated fields

N

nc

I am having problems deleting calculated fields. I can delete a few
manually, then it crashes the workbook? Has anyone had this problem.

I tried to delete all the calculated fileds, using macro the following macro
form Excel Help

Private Sub DeleteCalcFields_Click()

For Each fld In _
Worksheets("Create calc
fields").PivotTables("PivotTable1").CalculatedFields
fld.Delete
Next

End Sub

Once I run this macro I cannot access calculated fields at all.

Any help is appreciated.
 

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

Pivot table calculated field 3
Clearing Fields in a Word Form 5
Need Help with Macro Security 1
Improving Macro That Keeps First Letter 0
Keep First Letters, with exceptions 0
Getting Radio Buttons to work, that are inserted via AutoText 0
Auto Calculate selected worksheets 5
"Fields Nested Too Deeply" Error in Simple Word Document 5

Top