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:

(Subscribe to MrExcel Youtube Channel!)

(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
Twitter: @celia_excel
Instagram: @solveandexcel

--------------------------
Learn Excel and connect with a community of Excel professionals and enthusiasts:

[GrainneDuggan_Excel]

Excellent topic Celia! I have the double refresh issue in a few of my workbooks but had no idea why it did that. Such a great fix once you know it!

[ahadalavi]

Another wonderful video, thank you for explaining in detail. It was confusing why on some files in spite of clicking refresh all button still I had to click once more to have everything updated.

[fajall]

Excellent. I agree with you: 99% of my PQ files have pivot tables included.
I'm doing two refreshes all time mechanically

[kebincui]

Excellent tutorial. Thanks Celia for your kind sharing 👍👍

[chavelooo]

I just simply love your videos, clear and simple. I really like learning power query with you.

[adaeben]

how to refresh power query while workbook protected

[judytran]

Can you show us how to use “definition” tabt within query properties

[allabout]

Hi Celia, Have question. I work with lage data sources. Each time when I am making modification in power query step query is reffreshing each time and it take really long time. Is i possible to stop/disable this auto refreshing?

[jesuseduardobittersuarez]

I cannot refresh at all in my pc, it loads the table when I create it from other excel workbook but if I try to refresh it wont aloud it, cannot connet to origin =( help excel 2016

[fantasticprajwal]

How to update original file while power query refresh and transfer data to other file
It's placing lock on original file so not able to update original file

[anishjain]

Hello Ma'am, Every time I refresh the power query, the query table gets highlighted. I just want to get rid of this and stay on the sheet wherever I was just before the refresh. please help me with this.
Regards.

[Joann]

Hi Celia! thanks for great video. I would like to ask if background refresh works when the file is not open, is it possible?