How to clear the Pivot Table in VBA?

**lazyme** · 10-01-2007, 01:10 PM

Instead of clearing all the current fields in a pivot table one by one, is there a code to clear all the fields all at once?

If the fields are cleared one by one, if user edits the pivot table, the code will produce an error if such field is not added to the table.

Thanks in advance

**lazyme** · 10-02-2007, 12:16 PM

Must be a difficult topic.

Does anyone have any clue or tips?

**lazyme** · 10-02-2007, 07:06 PM

bump.

**VBA Noob** · 10-02-2007, 07:12 PM

You could look at the pivot section here

http://www.contextures.com/tiptech.html

and the examples from the same site.

http://www.contextures.com/excelfiles.html#Pivot

Sure you will find something you can use

VBA Noob