Debra Dalgleish has extensive examples on working with Pivot Tables, both
manually and programmaticlly.

This is a likely place to start

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

You can also go to here index page and look under P
http://www.contextures.com/tiptech.html

--
Regards
Tom Ogilvy

"Marcos Rodríguez" <Marcos wrote in
message ...
I'm from the Dominican Republic and I work as a Media Analyst at an
Advertising Agencies. I need some help regarding the use of pivot tables.
The thing is I have a workbook with several worksheets and pivot tables
which I refresh at least monthly. There are some graphs that are linked
to the results of these pivot tables. As I told you, I update this
databases monthly, in order to elaborate monthly Competitive Advertising
Reports. Each time I do this i have to manually change the field month
for the current month. For instance it's January now and last month was
december, so I have to change the month in the drop-down menu for this
field for all pivot tables that apply. I was wondering if you could help
me out creating a macro to do this automatically.

One problem might be that not all pivot tables have the field month,
so
if I try to apply this setting for all pivot tables VBA will return me
an error, right?

Please help... It will be greatly appreciated,

Marcos Rodríguez