Forum Discussion
Office 365 excel pivot sorting bug
Hi I'm using Excel office 365. Seems sorting Error in pivot table, for alphabet (a,b,c,d,e,f) sorting showing as (a,d,b,c,e,f) Row Labels A D B C E F G H Grand Tot...
I refresh the pivot table and then the order is A, B, C, D, ...
Interesting. I was not able, on my Mac--with the latest software--to get it to do anything with data refresh.
That's data model PivotTable. And Mac still doesn't support data models. Thus no way to refresh on that platform.