Last week during one of my Power Query training courses, a number of questions were asked relating to Query Refresh. I thought that they, together with the answers, would provide a good topic for this week’s YouTube video. The questions were:
- How do I exclude a Query from being refreshed when Refresh All is clicked?
- How do I prevent column widths changing when the Query is refreshed?
- How do I stop formatting that I’ve applied to cells being lost when the Query is refreshed?