Forum Discussion
Copying several files including power query into a new folder
Hello, I was looking for help about how to copy a folder with 3 excel workbooks that hold the data in 3 corresponding sheets, 1 Power Query workbook, and 1 workbook that has a pivot table and cha...
Hi cpartridge
I was thinking it would be better to separate out this big workbook out into several workbooks, so they would run faster
This won't run faster but slower. In a nutshell: getting data from 3 tables within the same workbook is faster than getting Tablex from Wbook1, Tablex from Wbook2 and Tablex from Wbook3
- Great! This is a key question I had. So, I think I may keep everything as one work book then.
