Is there a way to simultaneously put three excel files in a single folder into power query so they appear as separate queries, without wanting to immediately combine them? It is a bit of a chore to put a single file in, save as connection only, put a second file in, save as connection only, etc. Is there a way to do this all at once? Thank you in advance!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Putting Multiple Excel files into Power Query simultaneously without combining them
- Thread starter DrDebit
- Start date
