(Excel Online) Pivot Table does not group dates as Year and Month like before

Question

I have an existing Excel file with Pivot Table, which then i upload to OneDrive in order for me to access it on the go via Excel mobile app. Today when i refreshed the Pivot Table, the Field got jumbled up and i have identified that Month and Year field is missing. How to solve this issue?

I have tried to create a new table to feed a new Pivot Table which contains several Dates and Currency entry for simulation purpose. Result is the same as my main Excel file which the 2 fields went missing. Is there any recent update to the Excel Online that changed the behavior or does this feature only available for subscribed account?

Answer 1

Hello takoyaqii，

Thank you for using Microsoft products and posting them to the community.

We understand that you are experiencing an error after uploading your file to OneDrive.

In order to better troubleshoot your issue, would it be convenient for you to send us a private message with your file so that we can test it on our end?

I have enabled private messaging with you, you can send me your document via private message, please click on your avatar in the top right corner of the page, and in the small box that pops up, click on the three dots on the right > click on View Private Messages. As shown in the picture below.

Thank you for your understanding and patience. Feel free to reply if you need further assistance.

Lillian | Microsoft Community Support Specialist

Answer 2

Can help me on how to reply to the private message? I did not found any chatbox or button to click to proceed sending you a sample file

Answer 3

Hello takoyaqii，

I apologize for not opening a private message channel with you before. Now you can send your files via the private message button.

Thank you for your understanding and patience.

I look forward to hearing from you!

Lillian | Microsoft Community Support Specialist

Answer 4

Hello takoyaqii，

Welcome to the Microsoft community.

I have received your private message file on my end and have tested it and the test results do not show any anomalies. So I would like to know if you can circle the area where you are having doubts? So that we can further troubleshoot it more clearly.

Thank you for your understanding and patience. If you have any questions, please feel free to reply.

Lillian | Microsoft Community Support Specialist

Answer 5

Hi Lillian, previously there are additional PivotTable Fields labelled as Months and Years, which appeared automatically in the PivotTable panel. I believe these auto-added Fields is where the software recognized that the data that i keyed in are in Date format.

I specifically used the auto-added Fields (Years) to sort my PivotTable as the image attached, so that I can easily knew what year and month does my entry is for.

I found a post online where it mentioned that an empty cell or different format in a table may cause this issue. Thus the reason why I attached those Sample.xlsx where i try to replicate my use case in a new excel sheet, and found out the issue remains.

Hoping to hear from you soon.