Forum Discussion
marcob8986
Apr 15, 2021Copper Contributor
Get a table from each Excel file in folder | speed up the process
Hi, I've setup a query to read the content of a Table inside several Excel files in a folder. My problem is that those files are quite big (3MB+ each) and when the folder contains many files the pr...
mathetes
Apr 15, 2021Gold Contributor
Have you tried linking without the use of macro or VBA? Just link directly via a formula? I have a master sheet for tracking investments that links to multiple "source files" solely by using the FILTER function and pointing to the various source files. The source files, in my experience, do need to be open in order for the refreshed data to appear....but (also in my experience) the use of VBA or a macro often slows down the process. So whenever possible, I use Excel's built-in functions instead.
marcob8986
Apr 21, 2021Copper Contributor
There is no vba code involved here....