Re: Pivot table: filter dates and group by year
Sorry - this isn't helping as much as I thought. Possibly because I'm using XL2007?
According to this KB >> APPLIES TO:
Microsoft Excel 97 Standard Edition
Microsoft Excel 95 Standard Edition
Microsoft Excel 5.0 Standard Edition
Microsoft Excel 98 for Macintosh
I created a new pivot table from scratch on a different worksheet. But yes, it does refer to the same data table on a sheet in this workbook.
And when I grouped these dates by month, lo and behold it also changed all four pivot tables on another sheet, which had been grouped by year!
Fortunately, I did find an Ozgrid reference to this:
This workaround did work and fixed my issue.