Changes and formatting in my query aren't there the next time I run it.

Excel doesn't save formatting changes in queries When you return data to Microsoft Excel, you save the query definition as part of the worksheet, but you don't automatically save a separate query file. When you then edit the query for the external data range, changes to formatting and column headings that you made in Microsoft Query aren't preserved.

Formatting changes aren't saved in .dqy query files When you save a file in .dqy format, changes to formatting and column headings aren't preserved.

Formatting changes are preserved in .qry files To preserve formatting in Microsoft Query, make your formatting changes, click Save As on the File menu in Microsoft Query, and click Query Files (*.qry) in the Save as type list. When you reopen the query file, you will see your Microsoft Query formatting.