In Excel 2016, Version 1705 (Build 8201.2193), if I have a query from Get & Transform that is returned to the worksheet, it reorders the columns to match what is in the query editor every time I refresh - even if I check the box to "Preserve column sort/filter/layout" in External Data Properties. In previous versions, checking this box would maintain whatever column order is in the worksheet and new columns would be added at the end. Is there a new setting somewhere that I can set so it doesn't change the column order each refresh?
Just wanted to follow up on this query. Had anyone had any luck with resolving this? I’ve tried all the external data options and it seems like the button for “preserve column sort/layout” doesn’t do anything in Excel 365. It worked fine in Excel 2013 with PQ addin.