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

On Jun 20, 3:40 pm, Churley wrote:
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

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

" wrote:

On Jun 20, 3:40 pm, Churley wrote:
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