The One with Celia Alves
More Power Query Magic ⏬Show Notes and Links ⏬
Podcast version is available on Apple / Spotify and other podcast platforms including
https://powerquerymagic.podbean.com/e...
*****************************************************************
Celia has a very different backstory to many guests, such a twisting tale of chance and hard work coupled with a dedication to automate everything and find a better way.
As always I thoroughly enjoyed chatting with my guest. Thank you Celia.
Check out Celia's favourite and extremely useful blog post on allowing a single refresh when combining loaded tables with Pivot tables
• Understand the Enable Background Refresh p...
https://solveandexcel.ca/2020/09/11/e...
And her most popular here
• How to change the display language in Excel
https://solveandexcel.ca/2020/10/23/h...
You can also find Celia here:
/ celiajordaoalves
/ celia_excel
The Dataflow Connector code I mention briefly is = PowerPlatform.Dataflows(null)