|
PureBytes Links
Trading Reference Links
|
Dan,
Sounds like you have too many formulas in your cells. I would set
calculation in that workbook to manual. Then just hit F9 after you have made
your changes to recalculate all at one time, instead of every time you
change something in your sheet.
If you want auto calculation, you might try converting some of the formulas
into values by copying them and pasting as values.
Patrick White
-----Original Message-----
From: DPoiree@xxxxxxx <DPoiree@xxxxxxx>
To: omega-list@xxxxxxxxxx <omega-list@xxxxxxxxxx>
Date: Sunday, February 07, 1999 3:09 PM
Subject: Excel performance question
>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
>
>
|