Microsoft KB Archive/92673

From BetaArchive Wiki

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


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


you would have to place apostrophes around the filename, as in the following example:



"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
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.