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...
Sharing sample Excel file. Please note the issue with pivot table sorting in the Office 365 Excel version.
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.
- I'm with Detlef. for me, refresh or re-doing the sort causes it to resort correctly and i tried both desktop and online version
m_tarler , yes, online version shall allow data model refresh
That's data model PivotTable. And Mac still doesn't support data models. Thus no way to refresh on that platform.
