Pivot Tables

F

Fiona

Monthly dump info from Access into Excel and then do a
pivot table. I am able to refresh the data in the pivot
table from the raw data fine, but I can't group on the
Date field. The raw data has each day in the month and I
group it into a month. When I try to group the Date
field I get the error "Cannot group that selection." Any
help would be appreciated. Thanks
 
P

Peo Sjoblom

The dates have to be numeric, that way you will get the option of grouping
by month,
week etc. If they are dates and look numeric as in 12/15/03 or similar
depending on the region, select an empty
cell, copy it, select the imported dates in the table and do edit>paste
special and check add
Now try again..
 
Top