The One with Celia Alves
Power Query Magic - A podcast by Wyn Hopkins
![](https://is1-ssl.mzstatic.com/image/thumb/Podcasts125/v4/1d/d8/84/1dd88421-c91f-b912-f131-9d49c82e3635/mza_8888533022617841214.jpg/300x300bb-75.jpg)
Categories:
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)