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...
What you're showing us definitely is an anomaly. But you're also not showing the whole picture. Without that, nobody can offer any explanation that's any more than sheer speculation. That's probably why you've received no replies despite all the views.
Could I suggest you share a bit more of the pivot table in question. Ideally, unless it has a lot of confidential information, if you could post the actual workbook on OneDrive or one of the other cloud services, and then paste a link here that grants access....this would enable us to do more than idle speculation.
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
