Hi there,

I have 64 files in an identical structure, however with differing number of rows. I need to be able to run pivot tables across the combined data in the multiple files. The data in the 64 files constantly change hence it is not feasible to cut and paste. Is there a way to link the files dynamically? Do I need to use Access? If so how? PLEASE HELP!

Thanks