Open File Faster

waderw · May 7th, 2002, 08:41 AM

Anyone have any idea on how I can make a Excel file open faster? Probably not possible but just a thought

Mark O'Brien · May 7th, 2002, 08:57 AM

Do you have a particularly slow file or is this just a general question?

waderw · May 7th, 2002, 09:02 AM

Well there is one file that is about 30Mb so it's pretty large. Really just a general question.

Mark O'Brien · May 7th, 2002, 09:35 AM

As a general answer, the more powerful your machine, the faster it will open. I inherited a lovely set of 30+MB files. I had to use an equally lovely, PII 333MHz, 32MB RAM laptop to open them with. It easily took 15 minutes to open up and 5 minutes to register a change. Eventually I got upgraded to a PII 600MHz, 64MB RAM desktop. It only took 3 minutes to open up. This is not a good solution.

A better suggestion would be to make sure that Calculation is set to "Manual" (Tools|Options - Calculation Tab, Check the "Manual" box)

I'm sure other people have some more ideas as well though.

waderw · May 7th, 2002, 09:44 AM

You hit the nail on the head! I am using a PII 450 with 128 ram. I figured it was the pc but was just curious if there was any way of increasing the open/manipulation time.

Thanks,

Brian · May 7th, 2002, 04:38 PM

Turn off all add-ins that you do not use.
(Tools>Add-ins).

James · May 7th, 2002, 04:45 PM

Hi,

I had files that would take up to 15 min. to
open and the same to close. I read a post here that suggested deleting the EMF files in
the temp.directory, found over 3,000 EMF files deleted and everythings back to normal

James

Jack in the UK · May 7th, 2002, 04:48 PM

its worth adding any file NOT DIRECTORY can be deleted extention tmp and emf in tmp is good.

James · May 7th, 2002, 04:56 PM

Hi Jack,

I don't understand what your saying in your post? I just know after i delete the files w/ the .emf extension my file were back to opening and closing in seconds not minutes.

James

Jack in the UK · May 8th, 2002, 05:01 AM

in the temp file there are many files some times these are needed so stuff runs faster, but they will be rebuilt if missing as ageneral rule

TMP extentionions and emf extention live in the tmp file, but your see dir also dont delete them or whats in them windows put them there and chances they might be needed or in use if you delete this is not so good as that file might be active,

ONLY tmp and emf files delete thema nd the PC will power calculation better speed.

May 7th, 2002, 08:57 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Do you have a particularly slow file or is this just a general question? __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

May 7th, 2002, 09:35 AM	#4
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	As a general answer, the more powerful your machine, the faster it will open. I inherited a lovely set of 30+MB files. I had to use an equally lovely, PII 333MHz, 32MB RAM laptop to open them with. It easily took 15 minutes to open up and 5 minutes to register a change. Eventually I got upgraded to a PII 600MHz, 64MB RAM desktop. It only took 3 minutes to open up. This is not a good solution. A better suggestion would be to make sure that Calculation is set to "Manual" (Tools\|Options - Calculation Tab, Check the "Manual" box) I'm sure other people have some more ideas as well though. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

May 7th, 2002, 04:48 PM	#8
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	its worth adding any file NOT DIRECTORY can be deleted extention tmp and emf in tmp is good. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

May 8th, 2002, 05:01 AM	#10
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	in the temp file there are many files some times these are needed so stuff runs faster, but they will be rebuilt if missing as ageneral rule TMP extentionions and emf extention live in the tmp file, but your see dir also dont delete them or whats in them windows put them there and chances they might be needed or in use if you delete this is not so good as that file might be active, ONLY tmp and emf files delete thema nd the PC will power calculation better speed. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

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

May 7th, 2002, 08:41 AM	#1
waderw Board Regular Join Date: Apr 2002 Posts: 85	Anyone have any idea on how I can make a Excel file open faster? Probably not possible but just a thought

May 7th, 2002, 09:02 AM	#3
waderw Board Regular Join Date: Apr 2002 Posts: 85	Well there is one file that is about 30Mb so it's pretty large. Really just a general question.

May 7th, 2002, 09:44 AM	#5
waderw Board Regular Join Date: Apr 2002 Posts: 85	You hit the nail on the head! I am using a PII 450 with 128 ram. I figured it was the pc but was just curious if there was any way of increasing the open/manipulation time. Thanks,

May 7th, 2002, 04:38 PM	#6
Brian Board Regular Join Date: Apr 2002 Posts: 113	Turn off all add-ins that you do not use. (Tools>Add-ins).

May 7th, 2002, 04:45 PM	#7
James Board Regular Join Date: Feb 2002 Location: Huntington Beach, CA USA Posts: 327	Hi, I had files that would take up to 15 min. to open and the same to close. I read a post here that suggested deleting the EMF files in the temp.directory, found over 3,000 EMF files deleted and everythings back to normal James

May 7th, 2002, 04:56 PM	#9
James Board Regular Join Date: Feb 2002 Location: Huntington Beach, CA USA Posts: 327	Hi Jack, I don't understand what your saying in your post? I just know after i delete the files w/ the .emf extension my file were back to opening and closing in seconds not minutes. James