Change PivotTable Field By Code

Posted to microsoft.public.excel.programming

Curious[_6_] Curious[_6_] is offline

external usenet poster

Posts: 22

Change PivotTable Field By Code

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using a field name in an IF function for a calculated field in a PivotTable	Joel P	Excel Worksheet Functions	0	March 29th 07 12:48 AM
Pivottable Field items code -problems	Rayo K	Excel Programming	2	April 27th 06 10:54 PM
How do I use a keyboard to change a PivotTable or delete a field?	[email protected]	Excel Discussion (Misc queries)	1	February 4th 06 07:37 PM
How do I use a keyboard to change a PivotTable or delete a field?	[email protected]	Excel Discussion (Misc queries)	1	February 4th 06 05:10 PM
PivotTable - PivotTable Field name is not valid - error!	miker1999[_17_]	Excel Programming	1	June 10th 04 10:30 AM

All times are GMT +1. The time now is 07:07 PM.

Menu

About Us