MS Excel recalculations

Article View: comp.sys.mac

Article #28004

#28004

From: Doug Moore
Date: Thu, 12 May 1988 04:19

16 lines
1119 bytes


I don't own Excel, but advise someone who does.  So I don't have the manual.

Excel 1.04 is being used to maintain a database and keep some statistics derived
from it.  The database has 7 or 8 columns of input and 4 columns calculated
from the other 7 or 8.  The daily routine is
(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
recalculated?  Suggestions?  Or is this what one deserves for buying from MSoft?

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

Technical Details

Message-ID: <17102@cornell.UUCP>

Path: arc1-ca.pugleaf.net!utzoo!attcan!uunet!oddjob!ncar!boulder!sunybcs!bingvaxu!leah!itsgw!batcomputer!cornell!moore

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!utzoo!attcan!uunet!oddjob!ncar!boulder!sunybcs!bingvaxu!leah!itsgw!batcomputer!cornell!moore
From: moore@svax.cs.cornell.edu (Doug Moore)
Newsgroups: comp.sys.mac
Subject: MS Excel recalculations
Message-ID: <17102@cornell.UUCP>
Date: 12 May 88 04:19:27 GMT
Sender: nobody@cornell.UUCP
Reply-To: moore@cs.cornell.edu (Doug Moore)
Distribution: comp
Organization: Cornell Univ. CS Dept, Ithaca NY
Lines: 16