What happens to the formatting in an Excel file when data is refreshed through a Web Query?

When data is refreshed through a Web Query in an Excel file, the formatting is lost. A Web Query primarily focuses on importing or updating the data from the specified web source without taking into account any of the previous formatting applied to the cells in the Excel spreadsheet. This means that any custom styles, colors, cell borders, or fonts that were previously applied will not be retained after the refresh.

Understanding this process is crucial, especially when significant data manipulation and presentation rely on these formatting elements. Therefore, users often need to reapply their formatting after a refresh to maintain the visual integrity of their spreadsheets.