Excel97 faster than Excel2000!!

[Guest]

Hi!

It seems that Excel 97/SR-1, is faster than Excel 2000/SP-3 - with the
latest patchs installed. Our doubt is: what we can do to make Excel 2000 as
fast as Excel 97, at least!

Monthly, we need to actualize a complex book sheet - with a lot of external
links - using 'Replace...' function on the entire sheet, from past month to
the actual one - [May.xls]$A$1 --> [Jun.xls]$A$1.

We stated that on Excel 97 over Windows 95 or Windows NT, this operation
lasts for 1 minute approx. But exactly the same action, lasts for more than
10 minutes on Excel 2000 over Windows 2000!

We have tried to configure Excel 2000 for the manual formula calculation,
but with no effect. We've also solved the lost links and cells without
reference we had, but the execution time is exactly the same.

Anyone has found a similar situation before?

Thank you very much in advance!

 

[DNA]

That's odd that a 95 machine would run quicker than a new OS and a newer
version of Excel...

Have you checked available memory, HD space, etc.?

 

[Mike Middleton]

ALRSA -

(1) Maybe Excel 97 SR-1 is faster because it's not performing all of the
calculations. I strongly strongly strongly recommend SR-2.

(2) For speed and calculation advice, see various pages at
www.decisionmodels.com.

- Mike
www.mikemiddleton.com

 

[Guest]

I've fond on the same machine, older programs always run faster. The bloat
caused by all the new "features" comes at a cost. Your big problem is
Windows 2000- performance wise, it will kill an older machine that runs fine

ALRSA -

(1) Maybe Excel 97 SR-1 is faster because it's not performing all of the
calculations. I strongly strongly strongly recommend SR-2.

(2) For speed and calculation advice, see various pages at
www.decisionmodels.com.

- Mike
www.mikemiddleton.com

Hi!

It seems that Excel 97/SR-1, is faster than Excel 2000/SP-3 - with the
latest patchs installed. Our doubt is: what we can do to make Excel 2000
as
fast as Excel 97, at least!

Monthly, we need to actualize a complex book sheet - with a lot of
external
links - using 'Replace...' function on the entire sheet, from past month
to
the actual one - [May.xls]$A$1 --> [Jun.xls]$A$1.

We stated that on Excel 97 over Windows 95 or Windows NT, this operation
lasts for 1 minute approx. But exactly the same action, lasts for more
than
10 minutes on Excel 2000 over Windows 2000!

We have tried to configure Excel 2000 for the manual formula calculation,
but with no effect. We've also solved the lost links and cells without
reference we had, but the execution time is exactly the same.

Anyone has found a similar situation before?

Thank you very much in advance!

 

[Guest]

Hi DNA,

We've checked free memory, HD space, Windows memory configuration -
performance options asigned to applications -, virtual memory... We've also
tried the same action in differents moments - with more users connected and
other times with nobody in the system -, but always the same timing.

Thanks for your time!

"DNA" escribió:

 

[Guest]

Hi Mike,

(1) Perhaps the question - as you commented on your fisrt point - is the
different Excel configuration between the PC running Excel 97 and the PC
running Excel 2000, that's right.

(2) At first sight, it seems that the configuration is the same, but we'll
look more accurately at Decision Models site.

Thanks a lot!

"Mike Middleton" escribió:

ALRSA -

(1) Maybe Excel 97 SR-1 is faster because it's not performing all of the
calculations. I strongly strongly strongly recommend SR-2.

(2) For speed and calculation advice, see various pages at
www.decisionmodels.com.

- Mike
www.mikemiddleton.com

Hi!

It seems that Excel 97/SR-1, is faster than Excel 2000/SP-3 - with the
latest patchs installed. Our doubt is: what we can do to make Excel 2000
as
fast as Excel 97, at least!

Monthly, we need to actualize a complex book sheet - with a lot of
external
links - using 'Replace...' function on the entire sheet, from past month
to
the actual one - [May.xls]$A$1 --> [Jun.xls]$A$1.

We stated that on Excel 97 over Windows 95 or Windows NT, this operation
lasts for 1 minute approx. But exactly the same action, lasts for more
than
10 minutes on Excel 2000 over Windows 2000!

We have tried to configure Excel 2000 for the manual formula calculation,
but with no effect. We've also solved the lost links and cells without
reference we had, but the execution time is exactly the same.

Anyone has found a similar situation before?

Thank you very much in advance!

 

[Guest]

Hi Marvin,

Unfortunately, we fear that as Windows becomes 'better', 'faster', 'easier',
through the years, the amount of hardware resources and the lack of knowledge
of 'how this OS really works', can cause this kind of situations - old W9x
with older programs, runs much faster than new W2K-WXP with newer program
versions.

Anyway, thanks for your time!

"Marvin P. Winterbottom" escribió:

I've fond on the same machine, older programs always run faster. The bloat
caused by all the new "features" comes at a cost. Your big problem is
Windows 2000- performance wise, it will kill an older machine that runs fine

ALRSA -

(1) Maybe Excel 97 SR-1 is faster because it's not performing all of the
calculations. I strongly strongly strongly recommend SR-2.

(2) For speed and calculation advice, see various pages at
www.decisionmodels.com.

- Mike
www.mikemiddleton.com

Hi!

It seems that Excel 97/SR-1, is faster than Excel 2000/SP-3 - with the
latest patchs installed. Our doubt is: what we can do to make Excel 2000
as
fast as Excel 97, at least!

Monthly, we need to actualize a complex book sheet - with a lot of
external
links - using 'Replace...' function on the entire sheet, from past month
to
the actual one - [May.xls]$A$1 --> [Jun.xls]$A$1.

We stated that on Excel 97 over Windows 95 or Windows NT, this operation
lasts for 1 minute approx. But exactly the same action, lasts for more
than
10 minutes on Excel 2000 over Windows 2000!

We have tried to configure Excel 2000 for the manual formula calculation,
but with no effect. We've also solved the lost links and cells without
reference we had, but the execution time is exactly the same.

Anyone has found a similar situation before?

Thank you very much in advance!