Microsoft KB Archive/60483

{| = Excel: Name Defined As Constant Won't Link to Closed Worksheet =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q60483

SUMMARY
Linking to closed worksheets requires that the links contain only simple references (absolute references with no formulas).

Page 434 of the &quot;Microsoft Excel Reference&quot; manual gives the following example of a simple external reference:

=BUDGET!Inflation (if the name Inflation refers  to a cell, range, or constant) This is incorrect. If the above defined name &quot;Inflation&quot; refers to a text string or constant value, Excel gives the error message &quot;'Inflation' on 'Budget': not defined or too complex&quot; when the document named &quot;Budget&quot; is not open.
 * }