Microsoft Office Tutorials and References
In Depth Information
Configure When Excel Warns You About Long Operations
Configure When Excel Warns
You About Long Operations
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.
1 Click the File tab.
2 Click Options.
The Excel Options dialog
3 Click the Advanced tab.