I work with a file that takes me at least 10 minutes to open. It is a large
file with a lot of finctions, however, when the originator opens it, it takes
less than 2 minutes. We have the exact same machine (IBM T42). Does anyone
have any ideas?

Thanks!

Mike

First thing I'd try is to clean up the windows temp folder.

Close excel
windows start button|Run
%temp%
is a quick way to get there.

Mike Milmoe wrote:

I work with a file that takes me at least 10 minutes to open. It is a large
file with a lot of finctions, however, when the originator opens it, it takes
less than 2 minutes. We have the exact same machine (IBM T42). Does anyone
have any ideas?

Thanks!

Mike

--

Dave Peterson

Mike,

This does not seem as an Excel problem. Your machine can take more
time to open certain files due to hardware components (slow CPU,
minimum of RAM etc.).
Also look ate the task manager to see if there are inutile processes
that are running and stop the ones you don't need.
This might help.
You can ase well defragment the hard drive, clean and compact the
registry.

FG

But they both have the same exact machine--so it shouldn't be a hardware issue.

But maybe it is another process--To the OP...Maybe shutting off the AntiVirus
(just temporarily) would be worth testing on the slow pc.



"F.G." wrote:

Mike,

This does not seem as an Excel problem. Your machine can take more
time to open certain files due to hardware components (slow CPU,
minimum of RAM etc.).
Also look ate the task manager to see if there are inutile processes
that are running and stop the ones you don't need.
This might help.
You can ase well defragment the hard drive, clean and compact the
registry.

FG

--

Dave Peterson

Dave,

Actually I will be surprised if the entry level BM T42 opens fast a
large file with multiple formulas.
Some of them were shipped initially with only 256 MB of RAM at a very
low speed compared to todays' machines.
Maybe his friend is a tech guy and added extra 512 RAM (at least), he
is disabling the recalculation feature and stopping all the inutile
processes.
Also it is good to note that sometimes a serie of production is
custmized with additional option if requested by the buyre.
So maybe they are bothe T42 Architecture but wih different somponents.
He got the entry level of T42 and the other was upgraded ... I guess.

Regards,
FG

Where I worked, each pc that was distributed at the same time had the same
hardware configuration and same harddisk image.

It made the life of the IT folks much easier--not too bad for the typical user,
but irritating for the power user who needed a non-standard configuration.

I thought 2 minutes to open a file was pretty slow.

To the OP:
One more thought. Where is the file located? Any chance that the user with the
slow opening workbook is having network problems?

"F.G." wrote:

Dave,

Actually I will be surprised if the entry level BM T42 opens fast a
large file with multiple formulas.
Some of them were shipped initially with only 256 MB of RAM at a very
low speed compared to todays' machines.
Maybe his friend is a tech guy and added extra 512 RAM (at least), he
is disabling the recalculation feature and stopping all the inutile
processes.
Also it is good to note that sometimes a serie of production is
custmized with additional option if requested by the buyre.
So maybe they are bothe T42 Architecture but wih different somponents.
He got the entry level of T42 and the other was upgraded ... I guess.

Regards,
FG

--

Dave Peterson