MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Can't group/ungroup data in pivot table

Posted by itzik t. on February 11, 2002 12:55 AM

Dear Sir!
In Excel 97 - i creat a pivot table (3 col.: category,date,amount).
after creating :
1. i grouped the date(in pivot worksheet) col. (by year,mount) .
2. i add new rows
3. return to pivot and refresh data
4. the pivot table now is ungroup
5. i can't grouped it again (error message)

is there any option to do that ?
why after grouping first - can't group again (although trying to ungroup)


Posted by Mudface on February 11, 2002 1:11 AM

I had a similar problem grouping by Date, if ANY of your cells containing the Date source data are empty or are not a proper date, you won't be able to group. Check out the new rows and make sure they all have a vaild date in the right place.