Path: utzoo!utgpu!water!watmath!clyde!att!osu-cis!tut.cis.ohio-state.edu!walnut.cis.ohio-state.edu!jac
From: jac@walnut.cis.ohio-state.edu (Jim Clausing)
Newsgroups: comp.sys.mac
Subject: Re: MS Excel recalculations
Message-ID: <13276@tut.cis.ohio-state.edu>
Date: 13 May 88 17:42:00 GMT
References: <17102@cornell.UUCP>
Sender: news@tut.cis.ohio-state.edu
Distribution: comp
Organization: The Ohio State University Dept of Computer and Information Science
Lines: 29

In article <17102@cornell.UUCP> moore@cs.cornell.edu (Doug Moore) writes:
[...]
>Excel 1.04 is being used to maintain a database and keep some statistics derived
[...]
>(a) Insert 10 or so new lines into the database
>(b) Wait, while each of the 4 columns is recalculated, to no purpose,
>    for each of the entries already in the database.
>(c) Add the new entries, etc.
>How can we avoid step (b)?  How does Excel decide when something must be
[...]

One thing you can do (unfortunately, you need to do it every time you
open the spreadsheet), is to go over to the Options menu and select
Calculation... (the last item in the list), this brings up a dialog
box and here set it to manual calculation.  Insert your new rows
and fill in the entries, then type command-= to do all of the recalcs
at once.  I end up having to do this with my gradebook which I keep
in an Excel spreadsheet anytime I need to add a new assignment or
student (I have macros to automate the process of course).  Perhaps
someone else can be of more help as to how or why Excel does what it
does, but I think this will get you through the above problem.

>Doug Moore (moore@svax.cs.cornell.edu)

-=-
Jim Clausing  -- "Is it time for a colorful metaphor?"
CIS Department			
Ohio State University		jac@tut.cis.ohio-state.edu
Columbus, OH 43210	GEnie:		J.CLAUSING