How to remove automatic sorting from the pivot table in MS Excel(via VBA and Excel)

Question

How can we remove the automatic sorting from the pivot table ?
I have some raw data and when I convert it into pivot table, it automatically changes the order of some fields. How to prevent this ?

PFA

As you can see it changed the order of time[row field] automatically. I want the order to be maintained as it was.
How can we achieve this ?

We know it can be achieved by inserting new helpers column but is there any alternative ?

We want to modify only the raw source data without affecting other data. Since this method add and delete columns, it will definitely result in data loss, which we want to avoid.

![](https://learn-attachment.microsoft.com/api/attachments/80744535-8269-4e49-b1f0-b6b9bf60ff17?platform=QnA

Answer 1

Hi,
We already tried this way but it doesn't work.
Is there any other way ?

Additionally, we want to handle this from VBA.

Answer 2

Hi

Those are the only two sort options.

Here's the code for VBA: https://www.codevba.com/excel/pivottable/fieldlistsortascending.htm