Datasheet

18
22
33
11
The Excel Options dialog
box appears.
3 Click the Advanced tab.
1 Click the File tab.
2 Click Options.
To avoid wasting time waiting for a long
workbook recalculation to finish, you can
configure Excel to warn you when an
operation might take an excessively long time.
In a typical worksheet with only a few
formulas, the number of operations required to
recalculate the worksheet might run into the
dozens or hundreds, which Excel can handle
instantly. A mid-size worksheet might require a
few thousand or even a few tens of thousands
of operations to recalculate, but even such
larger sheets typically complete recalculation in
a second or two.
In a massive worksheet that contains many
linked formulas or one or more large data
tables, the number of operations required to
recalculate the sheet can run into the millions.
If that number exceeds 33,554,000 operations,
Excel warns you that the recalculation might
take some time. You can configure that
threshold to a lower or higher number.
If a large data table is causing slow workbook
recalculations, you can configure Excel to bypass
data tables when it recalculates workbooks. For
more information, see Chapter 4.
Configure When Excel Warns
You About Long Operations
03_577769-ch01.indd 1803_577769-ch01.indd 18 3/27/10 9:00 AM3/27/10 9:00 AM