Macro to clear then reinsert pivot table datafield

  • Thread starter Thread starter Fullam
  • Start date Start date
F

Fullam

Hi,

I want to be able to clear all the field buttons from the datafield in
a pivot table and then reinsert as this will help get me round the
issue of losing datafield data when it is hidden.

Is there a way of clearing all of the datafield for this macro ?

Cheers
Greg
 
If your modiying the pivot table with code, why not just create a new one
after you clear out the old one.
 

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 Tables - using .AutoShow 1
Pivot Table Layout 1
Datafields disappear in PIVOT table 0
Changing Names of Pivot datafields 3
Coloring a datafield when nr of characters is more then 40 4
Pivot Table Calculated Datafield Caption Problem 2
merge data from two pivot tables? 1
Two Pivot Table VBA Questions 2

Back
Top