Microsoft Office Tutorials and References
In Depth Information
Figure 22-5: Excel's way of asking whether you want to update links in a workbook.
First, try choosing File ⇒ Info ⇒ Edit Links to Files to display the Edit Links dialog box. Then select each link and
click Break Link. If that doesn't solve the problem, this phantom link may be caused by an erroneous name.
Choose Formulas ⇒ Defined Names ⇒ Name Manager, and scroll through the list of names in the Name Manager
dialog box. If you see a name that refers to #REF!, delete the name. The Name Manager dialog box has a Filter
button that lets you filter the names. For example, you can filter the lists to display only the names with errors.
These phantom links may be created when you copy a worksheet that contains names.
See Chapter 3 for more information about names.
Logical value errors
As you know, you can enter TRUE or FALSE into a cell to represent logical True or logical False. Although
these values seem straightforward enough, Excel is inconsistent about how it treats TRUE and FALSE.
Figure 22-6 shows a worksheet with three logical values in A1:A3 as well as three formulas that sum these lo-
gical values in A5:A6. As you see, these formulas return three different answers.
Figure 22-6: This worksheet demonstrates an inconsistency when summing logical values.
The formula in cell A5 uses the addition operator. The sum of these three cells is 2. The conclusion: Excel treats
TRUE as 1, and FALSE as 0.