In this video, I will demonstrate that when you create a query with Power Query to look into the different sheets of an Excel file to extract the data in them, the query may not work the next time you run it if you added extra columns to any of those worksheets or to a new one. I then show the solution that I found for this challenge.
Selecting all Columns of a spreadsheet with Power Query does not get dynamic
About the Author: Celia Alves
Celia Alves is a Microsoft MVP & Certified Excel Expert, specialized in developing highly complex solutions for Businesses combining VBA, Power Query and Power Pivot to automate tasks, analyze data and model business situations. She is originally from Portugal where she got her Bachelor and Master’s degrees from the University of Lisbon, both in Mathematics and Education and taught Mathematics in middle and high school for almost 2 decades. In 2013, Celia moved to Canada, where she re-skilled herself and built a new career as an Excel consultant. Celia is also the founder and leader of the MS Excel meetup group in Toronto.