Excel pivot does not sort correctly, It thinks a name is a month.

Question

Excel pivot does not sort correctly, It thinks a name is a month.

Bob Harrison 0

My data in Excel has name and data columns. When I put the LastName as the first row for the pivot table, it sorts the name MARCH to the top because it is the name of a month and therefore a date. The column is formatted as text, custon list sorting is turned off, there are no hidden characters.

This is a serious issue because important data is in the wrong place and may be missed. Also, I should not have to be an IT expert to apply a work around just to sort names from A-Z.

Any ideas on how to get this fixed? This is another example of trying to allowing technology predict what to do rather than just doing what it is told. Who is in control?

0 comments

5 answers

Your answer

Answer 1

riny 21,520 Volunteer Moderator

@Bob Harrison Answered in the link below with pictures.

https://techcommunity.microsoft.com/discussions/ExcelGeneral/pivot-table-sorting-is-not-working-name-are-sorting-like-month-names-/4564877

And it seems that AI wasn't all that bad, even though you dismissed it as ridiculous. Step 4 in the AI answer has no effect, but step 5 does. And what comes after is just typical AI adding more text to look smart.

0 comments

Answer 2

Barry Schwarz 6,271

Enter the name March as 'March. The single quote should force the the cell to be treated as text instead of as date.

Bob Harrison 0 Reputation points

2026-10-15T17:41:50.99+00:00

Tried that and all of the other suggestions I listed. When I make a pivot table that has 11,000 rows of data, it should show names and not change because 5 rows out of 11,000 have the name March in it. (I tested by changing one last name to December and it sorted it affter March and before Abbott.) So the pivot table is useless, not better.

Answer 3

Kai-L 20,130 Microsoft External Staff Moderator

Dear Bob,

I understand how worrying it is when names land in the wrong place, especially when important data could be missed. As a forum moderator, I genuinely wish I could directly access your account or delve into the backend systems to diagnose and fix this for you. Unfortunately, my role here is limited to providing general guidance and solutions that can be applied by users. From my research, Excel probably is not converting the surname MARCH into a date. The PivotTable is likely matching MARCH to Excel’s built-in month custom list, which can place it in calendar order ahead of ordinary surnames. Formatting the source column as Text does not prevent that behavior because the value is still text matching a month name.

For you receiving the best suggestion and guidance for this issue, I recommend you publish your workflow in the Excel | Microsoft Community Hub. This forum is dedicated to Excel and is actively monitored by power users, Microsoft partners, and engineers who can provide step-by-step guidance and share best practices.

I apologize for redirecting you to another community, as I may not have the necessary skills and experience to solve your Excel issue.

Thank you for your patience and understanding during this process. For any questions or further assistance in the future, please feel free to reach out again at any time. Not only will I be happy to assist you, but also all the moderators of the Q&A forum will do their best to provide support and guidance.

I hope everything will be resolved soon. Have a great day.

Bob Harrison 0 Reputation points

2026-10-16T16:38:52.1833333+00:00

Thanks for your reply. The issue is when I am working and have a list of employees with information and pop it into a pivot table to summarized it, the last thing I should have to think about is "Did Excel sort this correctly?" For example, let's say the table has hours worked per day and I need total hours. I pop it into a pivot table, put Name into the Rows and Hours into Value. The first person I need is McDonald, so I scroll to his name and see he has 125 hours. The next is March. So I scroll up a bit and March is not there. I report to my boss that McDonald worked 125 hours and March did not work during that period. WRONG INFORMATION because MARCH is up on the top.

It would be great if when I put NAME is the rows, a pop up appears that says similar to, Some data in the NAME field appears to be dates, do you want them sorted to the top as Dates or sorted as Text (Regular words). Something triggers the change in the sorting method, it could just as easy trigger the message.
Kai-L 20,130 Reputation points Microsoft External Staff Moderator

2026-10-16T21:11:49.87+00:00

Dear Bob,

Thank you for explaining the impact so clearly. Reporting that someone didn't work when their hours were simply sorted somewhere else is a real risk, and your idea of a prompt asking whether to sort the field as dates or as text is a sensible fix.

Since this needs a change in Excel itself, the best place to suggest it is directly to the Excel product team. In Excel, go to Help > Feedback > I have a suggestion and include your example. A real scenario like that shows the team exactly why it matters.

Thank you for taking the time to share your feedback.

Answer 4

Bob Harrison 0

The AI answer is ridiculous. It says to manually sort. Might as well go back to my rolodex. It sorted they way I wanted it to.

Bob Harrison 0 Reputation points

2026-10-15T17:36:27.4733333+00:00

Thank you for your reponse. I did pose the question in the Community Hub. No response yet. Another forum had a lot of suggestions but none of them worked. This used to work fine. Microsoft needs to remove whatever they added to create this behavior. Guessing what I want is not helping and causing a waste of time.
Kai-L 20,130 Reputation points Microsoft External Staff Moderator

2026-10-15T17:49:19.39+00:00

Dear Bob,

If none of the solution work, I strongly recommend that you share your detailed experience and feedback directly with the Microsoft product team through their official feedback channels. This is the most effective way to make your voice heard and influence future feature improvements and adjustments.

You can visit the Excel · Community to submit a new idea or vote on existing one. The product team is in charge of the site, and they constantly check customer reviews and feedback. The higher votes, the more attention the related team will pay, and a lot of the features are developed and improved based on customer feedback. As a moderator, I will also pass along your feedback to the appropriate team for further consideration. While I don't directly influence product design, user feedback is actively reviewed and helps prioritize future development. If you’re unable to submit feedback yourself, please feel free to reach out to me, and I’ll be happy to submit it on your behalf.

Thank you for your patience and understanding. I hope you get a fix soon. Feel free to come back here if you need anything else.

Answer 5

For a PivotTable on Windows, the supported ways to control the sort are:

Select a field in the row or column to sort.
Select the arrow on Row Labels or Column Labels.
Select More Sort Options.
Choose one of these:
- Manual to drag items into the order wanted.
- Ascending (A to Z) by or Descending (A to Z) by and then choose the field.
In More Options, clear Sort automatically every time the report is updated if automatic re-sorting is causing the order to change when the PivotTable refreshes.

A few checks are also relevant for unexpected sort behavior:

Leading spaces can affect sort results, so remove them before sorting.
Locale settings can affect sort order.
In general Excel sorting, if values are produced by formulas, recalculation can change returned values and the sort may need to be reapplied.

If the PivotTable still places MARCH unexpectedly, the reliable built-in workaround from the documented options is to use Manual sort in the PivotTable and drag the item to the correct alphabetical position.