XL: Error Message: "Input Cell Reference Is Not Valid" (95811)
The information in this article applies to:
- Microsoft Excel 2000
- Microsoft Excel 2002
- Microsoft Excel 97 for Windows
- Microsoft Excel 2001 for Mac
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q95811 SYMPTOMS
If you are using a data table in Microsoft Excel and the row or column
input cell refers to an external reference, you may receive the
following error message:
Input Cell Reference Is Not Valid
CAUSE
The row and column input cell must refer to a cell on the active
worksheet outside of the table range. This feature of data tables is
by design.
WORKAROUND
To avoid the error message, you can use a cell with a linking formula
("=Sheet1!A1") as your input cell. That way the input cell is on the
same worksheet as the Data Table and the "real" input cell is on
another sheet.
| Modification Type: | Major | Last Reviewed: | 5/13/2003 |
|---|
| Keywords: | kberrmsg kbprb KB95811 |
|---|
|