how do I improve performance when updating external links?

[Guest]

I have a 1500+ row by 36 column spreadsheet. I link in three different
spreadsheets (each representing approximately 25% of the columns). Two files
link fairly quickly (30 seconds or so). The third file takes 5-7 minutes.
How can I improve the performance of the linking process? The three external
files are all on the same network folder.

 

[Mikeopolo]

I've found that performance is much quicker when the linked files are
open at the same time

Regards
Mike

 

[Dave Peterson]

I'd open the files, too.

Or move them to a local folder on my harddrive.