Understand the Enable Background Refresh property in Power Query in Excel скачать в хорошем качестве

Understand the Enable Background Refresh property in Power Query in Excel

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. Links Mentioned: Uservoice idea - make "Enable Background Refresh" unchecked by default - https://excel.uservoice.com/forums/30... Date Picker add-in by Sam Rdakovitz - https://samradapps.com/datepicker Video Tutorial by MrExcel:    • Excel - Free Date Picker Tool - No Office ...   (Subscribe to MrExcel Youtube Channel!) Fake Daya add-in by Sam Rdakovitz - https://samradapps.com/fake-data Video Tutorial by MrExcel:    • Excel - Creating Fake Data in Excel Made E...   (Subscribe to MrExcel Youtube Channel!) 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 ---------------------- My Contact information: Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer Solve & Excel Consulting - https://solveandexcel.ca/ LinkedIn:   / celiajord.  . Facebook:   / solveandexcel   Twitter: @celia_excel Instagram: @solveandexcel -------------------------- Learn Excel and connect with a community of Excel professionals and enthusiasts: MS Excel Toronto Meetup Group - https://www.meetup.com/MSExcelToronto/ Learn how to automate your Excel Reports: https://snapreportschamp.com/