Using Monkey Tools - Query Monkeys (Pro) - Rapid Connection Only Queries with Table Monkey
Monkey Tools contains a collection of Query Monkeys who will inject useful Power Queries into your workbooks on demand.
Not every Excel table needs to be loaded to the Data Model... In this episode of Using Monkey Tools we will leverage the Table Monkey to rapidly connect Connection Only queries for every Excel table in the workbook. Hold on to your hat, as there is simply no faster way that this can be done!