MS Query and Excel - Added field to query but column doesn't appear on spreadsheet.

[CarolCook]

Using Excel 2007 and a fairly straightforward query which pulls data from ODBC. I have edited the query to add a new field but regardless of where I put it, I don't get a new column on the worksheet with the new values. If I use the query editor, it does show data but this is an already heavily formatted spreadsheet and I need to use the existing format. Is there any way to control column contents - i.e. tell Excel to show a field from the query?

 

[SkipVought]

Hi,

Anwsered in your forum68 thread.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}