Pivot Table Grouping from OLE DB source

[Guest]

I have a Pivot table whose source data is a worksheet that is populated via a
stored procedure on a SQL Server DB using OLE DB. When I attempt to group by
the date column in the pivot table I get "Excel cannot group that selection."

Is there any way around this?

Thank you

 

[Tom Ogilvy]

Make sure all your source data in that column is stored as an excel date.
Make sure you have no blank cells in that column.

 

[Guest]

All columns have values in them. What is the difference between Excel Date
and regular m/d/yyyy date format?

In Office help I saw that there is a section in the Grouping Items
explanation in Help that says sometimes dates obtained from an external
database cannot be grouped. I've tried copying from the sheet that the
stored proc is read into to another worksheet that ten populates the pivot
tables, but same results.