Change PivotTable Field By Code

C

Curious

Here is the situation:

Every worksheet has 12 pivottables for 12 months.

ActiveSheet.PivotTables("PivotTable1").PivotFields("Jan-06")
ActiveSheet.PivotTables("PivotTable1").PivotFields("Feb-06")

I want to re-use this model for 2007.

How could I update the PivotFields to
ActiveSheet.PivotTables("PivotTable1").PivotFields("Jan-07")
ActiveSheet.PivotTables("PivotTable1").PivotFields("Feb-07")

Thanks in advance.

H.Z.
 

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

Update Pivot Table Filters based on a Cell Value in Excel 2007 0
VBA Filtered Pivot Table Showing "Multiple Values Selected"; Only One Value Selected 0
Programming a pivot 0
MC3 0
Pivot Table - Add calculated field using field number (index) vs n 0
Code problems for pivot table 1
Pivot Tables using VBA 0
Can't change pivotfilter value1 parameter in code 0

Top