Generated Workbooks.
Dynamically generating the formulae in workbooks from database tables
can produce workbooks that calculate extremely fast, because it is
often possible to avoid using many time-expensive Excel features.
Build Time versus Run-Time:
Many workbooks contain a significant number of formulae and lookups
that are concerned with getting the input data into the right shape
for the calculations, or are being used as defensive measures against
changes in the size or shape of the data.
These things do not change often, so can either be put in a separate
spreadsheet that does not need to be recalculated, or you can use
copy paste special values to eliminate the formulae.
These things do not change often, so can either be put in a separate
spreadsheet that does not need to be recalculated, or you can use
copy paste special values to eliminate the formulae.
FastExcel allows you to use extended calculation modes so that you
can have some worksheets in manual calculation mode, and some worksheets
in automatic calculation mode.
With FastExcel you can also make Excel only calculate the active
workbook when multiple workbooks are open.
|
