Two automations to share Power Query results without allowing to refresh the query – T0022

Power Query is all about creating a refreshable connection to a data source and making it easy for us to update the query results. However, sometimes we want to preserve those results without being replaced by future changes in the data source. We invite you to watch this video and learn how to break the link to source data in Power Query.

Find more information about the Enable Background Refresh Property:
   • Understand the Enable Background Refr...  
https://solveandexcel.ca/2020/09/11/e...
________________________________________________________
Learn how to AUTOMATE YOUR EXCEL REPORTS in minutes instead of hours without copy-paste or coding: https://snapreportschamp.com/course

Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
https://solveandexcel.ca/dynamic-depe...
___________________________________________________________________

Chapters:
0:08 – Introducing topic and explaining need of disconnecting Power Query table from data source
4:28 – How to disconnect a Power Query Table from the data source
5:30 – Unlink Table from Data Source vs Load as Connection Only
6:59 – VBA to Refresh Power Query Table + Unlink Table from Data Source on a copy of the original file
24:11 - VBA to Refresh Power Query Table + Copy Table data to a new file without including the query
30:55 – Conclusion
…

Join my Telegram Group at https://t.me/celiaalvessolveexcel to access exercise files and other content.

Subscribe to my NEWSLETTER for exciting news about the Excel world: https://bit.ly/learnfromcelia

Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer

Solve & Excel Consulting - https://solveandexcel.ca

LinkedIn:   / celiajordaoalves  

Facebook:   / solveandexcel  

Twitter: @celia_excel

Instagram: @solveandexcel


#excel #msexcel #powerquery #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA