Grouping in Pivot Tables

I hope someone can help me with this. I have a pivot table that tracks
golf scores for a number of players on a number of courses. Players
runs down the side (i.e., row headings), date across the top (column
headings) and course is the page heading. The data section contains
average scores. I grouped the dates by month, and all was working well.
Then I added a few records to the list that is the data source for the
table. These records included a new course. When I updated the pivot
table, the dates became ungrouped (i.e., now there is a column for each
individual date, rather than for each month), and when I ask to group
the dates again, I get the message that the selection cannot be
grouped. Does anyone know why this changed, and how I can group the
dates?

Thanks for any help.

August West wrote:

 > I hope someone can help me with this. I have a pivot table that tracks
 > golf scores for a number of players on a number of courses. Players
 > runs down the side (i.e., row headings), date across the top (column
 > headings) and course is the page heading. The data section contains
 > average scores. I grouped the dates by month, and all was working well.
 > Then I added a few records to the list that is the data source for the
 > table. These records included a new course. When I updated the pivot
 > table, the dates became ungrouped (i.e., now there is a column for each
 > individual date, rather than for each month), and when I ask to group
 > the dates again, I get the message that the selection cannot be
 > grouped. Does anyone know why this changed, and how I can group the
 > dates?

Are you sure there is not at least one date in the newly added lines that is
formatted as text or something of the kind and not as a date? That would
bring in that kind of trouble: as there is one entry that can't be
considered as a date, there is no grouping of such a selection, of course.
And this is a situation where I can reproduce what you describe...

If you have checked this and it didn't bring some better, could you describe
how you entered the new data (copy/paste, import...), how you proceeded to
updated your pivot table in order to include the new one? Did you use the
PivotTable Wizard again, click on the "Back" button and simply modified the
cells references?


---------------------------------------------------------
Please reply to the newsgroup, and within the same thread.
Merci de répondre au groupe, et dans l'enfilade.

--
Bernard Rey - Toulouse / France
MVP - office:macintosh <a style='text-decoration: underline;' href="http://faq.office.macintosh.free.fr" target="_blank">http://faq.office.macintosh.free.fr</a><!-- ~MESSAGE_AFTER~ -->