Excel Err Msg: 'Error in Formula' when Using Manual Link |
The information in this article applies to:
- Microsoft Excel for the Macintosh, versions 2.2, 3.0, 4.0
- Microsoft Excel for Windows, versions 2.x, 3.0, 4.0
SUMMARY
If you create a link formula to a worksheet named C or R and you do not place apostrophes around the filename, you will receive the following error message:
Error in formula
This error message occurs because Microsoft Excel reserves the letters C and R for R1C1 reference style.
For example, to use the following formula
=C!$A$1
you would have to place apostrophes around the filename, as in the following example:
='C'!$A$1
REFERENCES
"Microsoft Excel User's Guide 1," version 4.0, page 268
Additional query words: 2.0 2.00 2.10 2.1 2.10 2.20 3.0 single quote quotation marks
Keywords :
Version :
Platform :
Issue type :
Technology :
Last Reviewed: March 29, 1999 |