[[email protected]]

On Wednesday, March 24, 2010 at 5:58:06 AM UTC-4, Me! wrote:
Hi,

I have a pivot table where the ROW field is a date that is grouped by month
& year.

However, when I change the data source to include additional rows that I
have added to the underlying data & refresh the pivot, the grouping is
ungrouped, so my aggregagation by month becomes aggregation by date.

this is a huge problem as it adds hundreds of rows to my pivot table which
then runs over another pivot table.

Does anyone know how I can retain the row grouping on updating the data
source & refreshing.

Thanks,

Jason

Hi Jason

I realize you have posted this back in 2010, but I do nto see anything else more recent.

I am having the same problem and Jason's instructions to correct the issue has not helped. My table/range includes the file name and the complete data range of the table, yet, the dates are still ungrouping when refreshed. Can you advise how you corrected this aggravating problem?