I have just been upgraded from Windows 2000 to XP. I have
Excel 2002. I have a file that is 18,000 KB.
Since the upgrade Excel takes up to ten seconds to
calculate everytime I enter in a cell or change a
formula.
I did not have this problem before the upgrade.
Any idea what I can do about it?
I would rather not set the calculation to manual, as it
may cause more problems while I am designing my
spreadsheets.

By default Excel automatically calculates when you press [Return]. You
can change the default from Automatic to Manual by clicking menu option
Tools Options Calculation and selecting Manual. When this is
selected your sheet will re-calculate only when you save or when you
press F9. The trick is to keep in mind that your numbers will not
update until you instruct Excel to do so.

Other notes: if you have other sprdshts open and set one of them to
manual, all will change to manual. If you change a sprdsht to manual
and send it to someone, all of *their* open sheets will change to
manual as well.


Dan wrote:
I have just been upgraded from Windows 2000 to XP. I have
Excel 2002. I have a file that is 18,000 KB.
Since the upgrade Excel takes up to ten seconds to
calculate everytime I enter in a cell or change a
formula.
I did not have this problem before the upgrade.
Any idea what I can do about it?
I would rather not set the calculation to manual, as it
may cause more problems while I am designing my
spreadsheets.

Thanks Dave,

I already knew about the automatic and manual calculation
feature.
My question is why it is so slow to calculate after the
upgrade when it is the same file and computer that I had
before it was upgraded.
And what can I do to correct this problem.

Thanks,

-----Original Message-----
By default Excel automatically calculates when you press
[Return]. You
can change the default from Automatic to Manual by
clicking menu option
Tools Options Calculation and selecting Manual. When
this is
selected your sheet will re-calculate only when you save
or when you
press F9. The trick is to keep in mind that your numbers
will not
update until you instruct Excel to do so.

Other notes: if you have other sprdshts open and set one
of them to
manual, all will change to manual. If you change a
sprdsht to manual
and send it to someone, all of *their* open sheets will
change to
manual as well.


Dan wrote:
I have just been upgraded from Windows 2000 to XP. I
have
Excel 2002. I have a file that is 18,000 KB.
Since the upgrade Excel takes up to ten seconds to
calculate everytime I enter in a cell or change a
formula.
I did not have this problem before the upgrade.
Any idea what I can do about it?
I would rather not set the calculation to manual, as it
may cause more problems while I am designing my
spreadsheets.

.

If the only thing upgraded was Windows OS, I suggest you look at that as the
source of your problem.

Perhaps a WindowsXP news group could supply more assistance.

When upgrading to WindowsXP did you run the Upgrade Advisor to ensure that the
existing hardware etc. was compatible?

http://www.microsoft.com/windowsxp/p...eckcompat.mspx

Have you since upgraded to WindowsXP SP2, which can cause problems if
installed on a spyware-ridden and fragmented system?

Gord Dibben Excel MVP


On Wed, 22 Dec 2004 12:19:29 -0800, "Dan"
wrote:

Thanks Dave,

I already knew about the automatic and manual calculation
feature.
My question is why it is so slow to calculate after the
upgrade when it is the same file and computer that I had
before it was upgraded.
And what can I do to correct this problem.

Thanks,

-----Original Message-----
By default Excel automatically calculates when you press
[Return]. You
can change the default from Automatic to Manual by
clicking menu option
Tools Options Calculation and selecting Manual. When
this is
selected your sheet will re-calculate only when you save
or when you
press F9. The trick is to keep in mind that your numbers
will not
update until you instruct Excel to do so.

Other notes: if you have other sprdshts open and set one
of them to
manual, all will change to manual. If you change a
sprdsht to manual
and send it to someone, all of *their* open sheets will
change to
manual as well.


Dan wrote:
I have just been upgraded from Windows 2000 to XP. I
have
Excel 2002. I have a file that is 18,000 KB.
Since the upgrade Excel takes up to ten seconds to
calculate everytime I enter in a cell or change a
formula.
I did not have this problem before the upgrade.
Any idea what I can do about it?
I would rather not set the calculation to manual, as it
may cause more problems while I am designing my
spreadsheets.

.