All content for Power Query Magic is the property of Wyn Hopkins and is served directly from their servers
with no modification, redirects, or rehosting. The podcast is not affiliated with or endorsed by Podjoint in any way.
Meet the Power Query Magicians from around the world
As always I thoroughly enjoyed chatting with my guest. Thank you Celia.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.Check out Celia's favourite and extremely useful blog post on allowing a single refresh when combining loaded tables with Pivot tables
https://youtu.be/JCNSVWY2NYw
https://solveandexcel.ca/2020/09/11/enable-background-refresh-property-in-power-query-in-excel/
And her most popular here
https://youtu.be/OQE9qMbofCw
https://solveandexcel.ca/2020/10/23/how-to-change-the-display-language-in-excel/
You can also find Celia here:
https://www.linkedin.com/in/celiajordaoalves/https://twitter.com/celia_excelThe Dataflow Connector code I mention briefly is = PowerPlatform.Dataflows(null)
Power Query Magic
Meet the Power Query Magicians from around the world