Hi all, I currently have a summary sheet with links to about 40 workbooks (this will increase over time) which are each approx 1.5mb in size. The trouble is re-freshing the data is currently taking some time each time the summary is opened. I was planning to dump the relevant data as a value from the 40 or so workbooks each time they are saved so that a refresh would not be needed. However I wondered whether there is a better method that anyone has found for linking multiple large spreadsheets to a summary?

Thanks for your time,
rrenis