Hi,

You must have different sheet for different types of calendar. Even if you
do not want changes to be refreshed across the same month, then you have to
have a different sheet for that particular month and use them in a single
pivot table. If you have a common sheet then it is obvious that refreshing
you data will update all information across the same pivot table.

Have different sheet as amany as possible and hid them. You can refresh each
table idependently.

Challa Prabhu

"jtriggs1941" wrote:

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