Export (0) Print
Expand All

3.2.3.1.5 External Name Formulas

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!" ;
Show:
© 2014 Microsoft