Excel Err Msg: 'Error in Formula' when Using Manual Link

ID: Q92673

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 :