Problem With Column Order After Access Report Transfer To Excel

[BenSC]

Dear All,
I am using the "Analyze With Excel" button to convert an Access report into an Excel spreadsheet. However several of my fields don't appear in the column order that I would expect. This only seems to apply to fields, which were added after the main bulk of my fields, so I'm thinking the problem is related to when the fields were added to the report.
However, I can't find any field property that relates to ordering the fields.

Does anyone know what causes this?

Thanks in advance
BenC

 

[jjob]

You may find that the column order is more to do with the report source - eg is it a Table or a SQL query - check and see it the excel order is related to these, it appears to be in my apps.