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.