Video: Enable Background Refresh property in Power Query in Excel
Van: Celia Alves - Solve & Excel
Duur: 20:33
Uitleg over wat de optie "Vernieuwen op de achtergrond gebruiken" inhoud, Draaitabellen en tabellen en VBA. Power Query met steeds meer bestanden (in een map)
This video is about the "Enable Background Refresh" property in Power Query in Excel. I will go through a couple of examples to demonstrate what this property does to query refreshing behaviour and to explain why it is important to pay attention to how we choose to set this property in our Power Query projects.
0:00 - Introduction 0:38 - What is and where to find "Enable Background Refresh Property"? 4:10 - Power Query Tables and Pivot Tables 10:14 - Power Query Tables and VBA 18:14 - Excel UserVoice idea to vote 18:45 - Excel Date Picker and Excel Fake Data add-ins
Functies: -
