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