|
PureBytes Links
Trading Reference Links
|
Excel is reasonably smart about determining what needs recalculating when you change a cell or fomula so it relates to the dependencies of the cell you changed. Some may be simple dependencies that are fairly quick to recalc other may be more complex. I second Patrick's suggestion that you go to manual recalcs.
> -----Original Message-----
> From: Patrick White [mailto:spy@xxxxxxxxx]
> Sent: Sunday, February 07, 1999 3:14 PM
> To: omega-list@xxxxxxxxxx
> Subject: Re: Excel performance question
>
>
> 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
> >
> >
>
|