That is what I have done on each tab. I was hoping to be able to refresh one
tab at a time instead of all copies of each table refreshing when I do one.


"Roger Govier" wrote:

Hi

Could you not drag Month to the page Area, then just use the dropdown to
select which Month you want to view?

--
Regards

Roger Govier


"jtriggs1941" wrote in message
...
I have ten different pivot tables on one spreadsheet all based on the
same
data. I made 11 copies of the spreadsheet to make one tab for each
month of
the year. I then changed the month on each table on each tab to
capture just
the month I wanted. Now when I click in table 1 on the January tab to
refresh
it, it tries to refresh table 1 on every month's tab. Is there anyway
around
this? I really don't want to recreate 10 pivots each for 12 months!

Thanks,
Terri