I have an Excel database and am doing queries against it using MS Query. I
would like to preserve formatting, validation and cell comments from the
original workbook. When I do the query, all of my data is correct but comes
into my new spreadsheet as, what seems, unformatted data.

I've got the 'preserve cell formating' check box check in the 'External Data
Range Properties' window. I thought this might do it...

Is it possible to preserve cell comments and validation when doing a query
from an Excel database to different Excel worksheet? Is there a better way
perhaps?

Thanks,

Scott