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.