earthworm
Well-known Member
- Joined
- May 19, 2009
- Messages
- 766
- Office Version
- 2019
- 2016
- Platform
- Windows
I have 30 files . Each files contains data of approx 6 Million. I imported the folder through Power query. Then I get and transform data and then I used the formula Excel.Workbook(Content). When I am expanding the column power query is taking too much time in loading file before I move to next step of expanding the column to show data. Is there any faster way ? Because I have to wait for hours before moving to next step. Please advice