Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/92673

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 18:33, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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