How to remove pivotfields from row and column axis

R

RKAzinhal

Hi!

I am using a PivotTable object in an ASP page.
I would like to have a button to remove all pivotfields that the user has
moved to the row and column axis.
I know how to insert a fieldset into a axis
pTable.ActiveView.ColumnAxis.InsertFieldSet
pTable.ActiveView.FieldsSets("LastName"),
but not how to remove it...

What is the best way to achieve this?

Thank you for your help,
Rafaela
 

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

How to remove external organization from Office. 0
Remove checked items from To Do lists 0
How do I remove the top half of a block interval? 1
I'm trying to remove duplicate phrasing and words using VBA in Word 2
How to remove a bracket that is itallicised for an entire document 1
Format column widths from one table to a separate table on same page 1
How to center adjust text above and image in a two column document. 1
How to filter pivot table programmatically 1

Top