3.2.3.1.5 External Name Formulas

  • Article

External name formulas are restricted to cell references within the same external book.

 external-name-formula=
 ["="], external-name-expression ; 
 external-name-expression=
 same-book-prefix, A1-reference |
 external-name-error-constant ;
 same-book-prefix= same-book-single-sheet, "!" |
   same-book-sheet-range, "!" ; 
 same-book-single-sheet= sheet-name |
   apostrophe,  sheet-name-special,  apostrophe ;
 same-book-sheet-range= sheet-name, ":", sheet-name |
 apostrophe, sheet-name-special, ":", sheet-name-special,  apostrophe ; 
  
 external-name-error-constant=
 "#REF!" ;