Make Power Query refresh before PivotTables | Reduce refresh to one click | Excel Off The Grid
★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy
★ About this video ★
By default, PivotTables refresh before Power Query. Which is an issue if our PivotTable is based on a query Table. It means we need to click twice. In this video, you will learn the settings to apply so that PivotTables refresh after queries have finished.
0:00 Introduction
0:14 The Problem
1:22 The Solution
2:36 Conclusion
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: / exceloffthegrid
#MsExcel #PowerQuery