Microsoft KB Archive/95811

= XL: Error Message: &quot;Input Cell Reference Is Not Valid&quot; =

Article ID: 95811

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 2001 for Mac
 * Microsoft Excel 98 for Macintosh

-



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 (&quot;=Sheet1!A1&quot;) as your input cell. That way the input cell is on the same worksheet as the Data Table and the &quot;real&quot; input cell is on another sheet.

Additional query words: criteria XL2000 xl2002 xl2001 xl98 xl97

Keywords: kberrmsg kbprb KB95811

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.