column placement in query

[Churley]

I have a problem when I try to edit a query in Excel.
If I want to add another column and place it between columns A and B, when
the query is brought back into Excel, the new column automatically gets
placed at the end of the data, even though I placed it where I wanted it
within the query.

Any suggestions?

Thank you

 

[par_60056]

I have a problem when I try to edit a query in Excel.
If I want to add another column and place it between columns A and B, when
the query is brought back into Excel, the new column automatically gets
placed at the end of the data, even though I placed it where I wanted it
within the query.

Any suggestions?

Thank you

right click on the query and go to the data range properties.
uncheck Preserve column sort/filter/layout

It is not preserving the column sort order from the query but
preserving the column order on the sheet

 

[Churley]

It works! I have tried to figure this out for a long time. Thank you so much!