When I refresh a query in Excel 2016, the formatting of columns is lost. I have set all properties to retain as far as I am aware, i.e. External Data Properties , i.e. "Preserve column/filter/layout" and "Preserve Cell Formatting" are both checked. I can't find any other settings that would impact this. Is there somewhere else I need to enforce this?