Data Shuttle SharePoint Formatting

N Wills

I was recently advised by the support team that it is not possible to lock formatting on the destination sheet in SharePoint which defeats the purpose of having this as every time the job runs it clear out the formatting and spacing of columns in SharePoint. Ideally, the data shuttle would only update the data points themselves but leave the destination sheet formatting. Or, it could use the formatting in the sheet to reference this instead. As data shuttle is currently constructed for the transfer of data into SharePoint, this creates an annoying extra step that a user would have to take every time they need to use the sheet.