Forum Discussion
Pivot tables
what has changed in Microsoft to cause all my pivot tables to stop putting amalgamated months and changing to individual dates I am sorting on Invoice dates to see what has been spent month on mont...
Debbie1064 I suspect the the new data contains texts that may look like dates in the invoice date column. Then Excel can no longer group the data based on a date hierarchy.
Riny_van_Eekelen - Many thanks, i'll go and check the data.