"R1C1 is not a valid reference" in AutoTemplate Wizard
Article ID: 134612
Article Last Modified on 8/15/2005
APPLIES TO
- Microsoft Excel 95 Standard Edition
This article was previously published under Q134612
SYMPTOMS
In Step 3 of the AutoTemplate Wizard, you may receive the following error
message after you specify a cell in the Cell Field:
R1C1 is not a valid reference
CAUSE
This error message will occur when you reference a cell using the R1C1
notation in the Cell Field in Step 3 of the AutoTemplate Wizard. An R1C1
reference is created when you do either of the following:
- Type an R1C1 style reference in the field. For example:
-or-
- Select a cell on a worksheet while the Reference Style option is set to
R1C1.
RESOLUTION
When you specify the worksheet cell in Step 3 of the AutoTemplate Wizard,
use any of the following methods to specify the A1 Reference Style:
Method 1:When you type the reference into the field, use the A1 notation.
For example, use this notation:
'Sheet1'!$A$1
When you select the cell with the mouse, set the Reference Style
on the General tab in the Options dialog box to A1 before
you start the AutoTemplate Wizard.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. Microsoft is researching this
problem and will post new information here in the Microsoft Knowledge Base
as it becomes available.
REFERENCES
For more information about the Template Wizard, type the following in the
Answer Wizard and press Search:
In the list of topics, double-click the following:
How Do I
Create a template to export worksheet data to a database
Additional query words: XL7
Keywords: KB134612