Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL: Error Message: "Input Cell Reference Is Not Valid"

XL: Error Message: "Input Cell Reference Is Not Valid"

View products that this article applies to.

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

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Keywords: KB95811, kbprb, kberrmsg

↑ Back to the top

Article Info
Article ID : 95811
Revision : 3
Created on : 9/19/2011
Published on : 9/19/2011
Exists online : False
Views : 462