Microsoft Excel taking 100% processor time for 2~3 minutes for few excel sheets

[ping]

Hi,

I experienced slowness in opening certain excel sheet, which is around
10MB in size. The excel sheet is created using Excel 2000. Have tried
upgrading to Excel 2003 with latest service packs but it doesn't help.
Suspect it is the recalculation that is taking up the processors. It is
a 1.5Ghz P4 with 512MB RAM.

Any optimization/repair can be done on the excel sheet? or some option
to reduce the recalculation intensity?

Thanks.

 

[Niek Otten]

For lots of information about calculation speed, visit Charles William's site:

www.decisionmodels.com

--
Kind regards,

Niek Otten


| Hi,
|
| I experienced slowness in opening certain excel sheet, which is around
| 10MB in size. The excel sheet is created using Excel 2000. Have tried
| upgrading to Excel 2003 with latest service packs but it doesn't help.
| Suspect it is the recalculation that is taking up the processors. It is
| a 1.5Ghz P4 with 512MB RAM.
|
| Any optimization/repair can be done on the excel sheet? or some option
| to reduce the recalculation intensity?
|
| Thanks.
|