How to speed up Excel links?

richard888 · Mar 27th, 2002, 10:15 AM

I have an extremely large spreadsheet that contains links to 300 other separate spreadsheets. Obviously this takes 2-3 minutes to start up and to calculate. How can I speed this process up? (I know I can tweak the calculation setting to manual, but the links must be updated). Maybe, I'll just have to bear with it until Intel come out with a 10 GHZ chip! Any ideas would be welcome.

Chris Davison · Mar 28th, 2002, 12:44 PM

no replies, so I'll stick my oar in......

are the 300 other files on your network ?

if possible, pop them on your hard drive ?

And, not exactly what you asked, but, con-incide the loading of your file with your coffee break or something so it's not lost time, per se.

(I know Jack in the UK does this with very large files - he rearranges all his MS Word tutorials while it's loading...)

big

Juan Pablo González · Mar 28th, 2002, 12:47 PM

Wow, 300 files... that's A LOT ! that's impossible to rearange ? reduce File count ? are all links absolutely necessary ? do you need "live" formulas ?

Mark O'Brien · Mar 28th, 2002, 12:50 PM

Become friends with someone that knows Access.

Mar 28th, 2002, 12:47 PM	#3
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Wow, 300 files... that's A LOT ! that's impossible to rearange ? reduce File count ? are all links absolutely necessary ? do you need "live" formulas ? __________________ Regards, Juan Pablo González http://www.juanpg.com

Mar 28th, 2002, 12:50 PM	#4
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Become friends with someone that knows Access. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 27th, 2002, 10:15 AM	#1
richard888 New Member Join Date: Mar 2002 Posts: 1	I have an extremely large spreadsheet that contains links to 300 other separate spreadsheets. Obviously this takes 2-3 minutes to start up and to calculate. How can I speed this process up? (I know I can tweak the calculation setting to manual, but the links must be updated). Maybe, I'll just have to bear with it until Intel come out with a 10 GHZ chip! Any ideas would be welcome.

Mar 28th, 2002, 12:44 PM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	no replies, so I'll stick my oar in...... are the 300 other files on your network ? if possible, pop them on your hard drive ? And, not exactly what you asked, but, con-incide the loading of your file with your coffee break or something so it's not lost time, per se. (I know Jack in the UK does this with very large files - he rearranges all his MS Word tutorials while it's loading...) big