I currently have a spreadsheet called Report.xlsx that is connected to a .csv file which serves as an external data source. Report.xlsx is set to refresh with the latest information upon opening. However, there are certain columns which have a required format, for example, under the column called Time, the cell format should be [h]:mm:ss. This is a custom format that can be found under the Number tab. When the refresh occurs, the formatting is lost and is changed to m/d/yyyy h:mm. Is there a way to preserve the formatting that I set it to after a refresh or will this always have to be changed manually?

If you require any clarification, please let me know.