Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Fixing Formula Boo-Boos
✓ Check Status: Provides status about links. A number of values are
possible (such as OK, Unknown, Error: Source not found, Error: Worksheet
not found, and so on). In the Edit Links dialog box (refer to Figure 4-7),
Status is a column in the middle of the dialog box. Each link receives its
The Edit Links dialog box shown in Figure 4-7 also has the StartUp Prompt
button in the lower left. Clicking this button leads to a choice of what the
workbook should do when opened and there are no external links. The choices are:
✓ Let users choose whether to display the alert or not.
✓ Don’t display the alert and don’t update automatic links.
✓ Don’t display the alert and update links.
Using the Formula Error Checker
Some errors are immediately apparent, such as mismatched parentheses
explained earlier. Other types of entries are not blatant errors but instead
resemble errors. In this case, Excel alerts you to the possible problem and
lets you choose how to handle it.
Figure 4-9 shows a few numbers and a sum at the bottom. The formula in cell
B10 is =SUM(B4:B9). There is nothing wrong here, no possible error yet.
Note that in Figure 4-9 the headings row is not adjacent to the rows of
information. Rows 2 and 3 are in between the headings and the data. This is not
unusual, because this leads to a clean-looking report.
However, watch what happens if a value is accidentally entered into the area
between the headings and the data. The formula in cell B10 calculates values
starting in Row 4. When a value is entered in cell B3, Excel alerts you that
there may be an error. You can see this in Figure 4-10. A small triangle is now
visible in the upper-left corner of cell B10 — the cell with the formula.