4 thoughts on “Resolving Format Cells Change after Refreshing Data Sources in Power Query

  1. Alternatively, and perhaps easier… you could’ve taken the PowerQuery, loaded it into a PowerPivot model (right there within Excel), and defined its formatting.

  2. How to you preserve other formatting such as Cell color and text type on total ( i.e. BOLD) etc.

Any thoughts? Share it with us here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.