How would I set up links to the other spreadsheets, I have over 2000 excel
spreadsheets to upload into one spreadsheet.

"Jim Jackson" wrote:

Is it possible that setting up links to the other spreadhseets would work?
That way you could just click "Yes" to update links when opening the one
spreadsheet.

Best wishes,

Jim

"Excel Macros" wrote:

I have a large number of excel files and I want to use a macro to upload the
data from these files into another excel spreadsheet. The macro that I
currently use requires that I upload these files one at a time. The number of
files is so large that this is too time consuming.