I am running a 450 MHZ P2 machine with 384 MB memory and XP Pro. I
have a large spreadsheet that takes nearly two minutes to recalculate
when I switch tabs. I was running Excel 2000 SP3.

My friend is running a 600 MHZ P2 machine with 256 MB memory and XP
Pro. Using the spreadsheet that I mailed him, he can do the same task
in 20 seconds or less. He is running Excel 2000, native installation.

I found something about updating the registry with a "CHARLOTTE" entry
if you had SP3 on Excel. I tried that, same response time. I
removed/reinstalled Office; same response time. I verified that the
Excel was a clean install.

I applied SP1; same response time. There is no SP2. It jumps next to
SP3.

Tony

Hi Tony,

There is a list of many of the things that can slow down Excel on my
bottlenecks page at
http://www.DecisionModels.com/optspeedd.htm

hth
Charles
______________________
Decision Models
The Excel Calculation Site
www.DecisionModels.com

"tommy bobit" wrote in message
...
I am running a 450 MHZ P2 machine with 384 MB memory and XP Pro. I
have a large spreadsheet that takes nearly two minutes to recalculate
when I switch tabs. I was running Excel 2000 SP3.

My friend is running a 600 MHZ P2 machine with 256 MB memory and XP
Pro. Using the spreadsheet that I mailed him, he can do the same task
in 20 seconds or less. He is running Excel 2000, native installation.

I found something about updating the registry with a "CHARLOTTE" entry
if you had SP3 on Excel. I tried that, same response time. I
removed/reinstalled Office; same response time. I verified that the
Excel was a clean install.

I applied SP1; same response time. There is no SP2. It jumps next to
SP3.

Tony

Charles,

I checked the list of tips. Unforutnately, I had already done most of
them and the others were already as suggested. No improvement.

I have kept your email address and will let you know what the fix is
(if I ever find it).

Tony

On Mon, 15 Sep 2003 09:17:23 +0100, "Charles Williams"
wrote:

Hi Tony,

There is a list of many of the things that can slow down Excel on my
bottlenecks page at
http://www.DecisionModels.com/optspeedd.htm

hth
Charles
______________________
Decision Models
The Excel Calculation Site
www.DecisionModels.com

"tommy bobit" wrote in message
.. .
I am running a 450 MHZ P2 machine with 384 MB memory and XP Pro. I
have a large spreadsheet that takes nearly two minutes to recalculate
when I switch tabs. I was running Excel 2000 SP3.

My friend is running a 600 MHZ P2 machine with 256 MB memory and XP
Pro. Using the spreadsheet that I mailed him, he can do the same task
in 20 seconds or less. He is running Excel 2000, native installation.

I found something about updating the registry with a "CHARLOTTE" entry
if you had SP3 on Excel. I tried that, same response time. I
removed/reinstalled Office; same response time. I verified that the
Excel was a clean install.

I applied SP1; same response time. There is no SP2. It jumps next to
SP3.

Tony