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:
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.
Additional query words: criteria XL2000 xl2002 xl2001 xl98 xl97
Keywords: kberrmsg kbprb KB95811