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