Microsoft Office Tutorials and References
In Depth Information
Configure When Excel Warns You About Long Operations
Chapter 1: Making Excel More Efficient
4 Make sure that the Alert
the User When a
Potentially Time
Consuming Operation
Occurs check box is
selected.
5 Use the When This
Number of Cells (In
Thousands) is Affected
spin box to specify the
threshold at which Excel
displays the long
operation warning.
Note: The number in the spin box
is shown in thousands. So, for
example, if you enter 1,000 into
the spin box, then the threshold is
one million cells.
6 Click OK.
4
5
Excel now warns you
about time-consuming
operations when the
number of cells affected
will be equal to or
greater than the number
you specified.
6
Did You Know?
Although you’re unlikely to ever come across
such an operation, the maximum value that
you can specify in the When This Number of
Cells (In Thousands) is Affected spin box is
999,999,999. Note, too, that although you can
enter a value as small as 1 in the spin box,
low values are not recommend because they
generate excessive warnings. Unless you have
a very slow computer, do not go under ten
million operations (10,000 in the spin box).
Remove It!
If you have a fast computer with a lot
of memory, then Excel should be able
to handle almost all real-world
calculations relatively quickly, so you
do not need Excel to warn you. In that
case, deactivate the warning by
following steps 1 to 3 and then
clicking to select the Alert the User
When a Potentially Time Consuming
Operation Occurs check box.
 
Search JabSto ::




Custom Search