I tried to reply on this thread but it is locked:

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.