Refreshing power query re-orders adjacent columns

[Sevalle]

Hi,

I used Power Query to extract data from a file and reformat it into something easier for the user to understand.

I then added additional fields to the output table and asked the user to fill out these fields with details not available in the original data source, one of these fields uses a formula to add a default answer: "Y" as the majority of entries would have that as the answer.

One user sorted column A (Name) before entering the details

Now, weirdly, when the power query that generated columns A and B is refreshed it completely changes the order of the cells in column C & D

I can get around this by asking the users not to sort columns A & B or by adding the sort to the query itself, but I'm wondering if there is a better way.
The actual data set has several columns and i'd like to avoid putting restrictions on the user.

Any ideas/help regarding this would be greatly appreciated.

 

[Shortmeister1]

Have a look at the table design tab and select properties. Check the "Preserve Column Sort Order/Filter" option. I suspect that might be where the problem is.

 

[Shivex]

Have a look at the table design tab and select properties. Check the "Preserve Column Sort Order/Filter" option. I suspect that might be where the problem is.

You, Sir, just saved me a whole lot of headaches ???