I tried to reply on this thread but it is locked:
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_2016/formatting-of-columns-is-not-retain-when-i-refresh/5dc6f34e-fe76-4f22-ba55-119da59f836c
You basically need to Check OR UNcheck the following:
- Preserve column sort/filter/layout
- Adjust column width
- Preserve cell formatting
These settings are in relation to the Data on the connector meaning it will preserver that back end formatting. Hope that makes sense and helps someone.