MS Query/Excel 2007

[shersted]

Have a rather simple problem I can't seem to overcome when using MS Query with Excel 2007. I've set up a query (.dqy) that works fine and returns proper data. But whenever I go back to that connection/query and add a new field to the query and place it in a specific spot, I can never get that field to show up in Excel where I placed it in the query. When I add a new field, it's always returned to Excel at the end of the spreadsheet. So then I move it to the place I want inside the spreadsheet but then that field will not refresh properly. How to a perform this very simple task? Many thanks