How to Import Excel Files with Power Query; BUT there's a PROBLEM
Here is a how-to for importing Excel files from a folder using Power Query (Get and Transform). It’s fairly easy to do. HOWEVER, in this example, I’m sharing a folder with someone who starts putting goofy stuff into the folder and they break the Power Query query and the process. Now what? One move is … Read more