|
PureBytes Links
Trading Reference Links
|
I'm using Excel to do some number crunching from several system print
statements. The file is rather large, about 29,000 KB or 1.5 million cells, on
my amd 233 mmx laptop with 96 megs of ram.
What I'm wondering is why sometimes, about a third of the time, when I add an
equation to a cell, delete a cell, or the like, the computer takes about 10
minutes to "calculate Cells: xx%". Other times it takes about 15 seconds.
Defragmenting the hard drive hasn't helped.
Curiously, after the screen goes blank (from the power saving feature), and I
touch a key to activate the screen again, the cells are already recalculated.
This has proved to be the fastest way to get rid of the hourglass and get on
with my work.
I've had no other performance problems and wonder, aside from the size of this
file, what might be causing this.
I'd appreciate any thoughts as to why this sometimes happens and what I might
be able to do to have consistent improved performance.
Thanks much,
Dan Poiree
|