Macro for dynamic links?

[ExcelNUBs]

I was wondering if there was a macro or a way to link large amounts of data together, Other than linking sheet to sheet on excel? Every time I switch files it takes an extremely long time to load, sometimes to the point of me thinking it has frozen.

Thanks.

[Dennis7849]

Speed is normally a function of about 4 things.

In order by importance:
1. How fast your computer is.
2. How large the file is.
3. How much RAM space your computer has.
4. How fast your hard disk drive is.

If your computer is fast for most things, I would check the Excel file size.

[ExcelNUBs]

It's definitely the size of the file.

I'm assuming this means there is no macro for this?