There is more than one way to export. Can you describe the exact steps that you used?
Is this a calculation field or a text field that's failing to export data?
File, Export Records, Save as Type Excel xslx (given filename), then Field export order I have (firstname, Lastname, business, address, city, state, zip).
I have checked and unchecked the Apply current layouts data formatting.. both have same result.
It is a text field
Do you understand how the "group by" fields setting works?
It takes multiple records in your source table and exports a single row of data to the excel file for that group of records.
Thats it. I didn't pay any attention to that area, as it seemed to put that info in itself. I cleared everything out of there and now it works fine. Thank you!