I have an Excel Workbook with 21 worksheets. One sheet summarises the data into a table with 9 columns and 512 rows. I have set up a power query to retrieve this table into another workbook, but the query takes nearly 3 minutes to refresh. This is too long. The query appears to be reading all the sheets in the workbook. I have tried saving the single sheet as a CSV file and using this as the data source for my query. That query refreshes in 2 seconds. Before I set this up as 'the solution', do any of the esteemed power users in this forum have any suggestions for improving the refresh speed of the query from the original Excel workbook?
Bookmarks