I can't reproduce the error, works for me, did you include the cell with the
formula and is it one cell to the right and on above the list?


Regards,

Peo Sjoblom


"Sarah Bee" wrote:

I have selected a range that is 4 by 4 for the one variable table - in fact I
replicated the table that is in the Help screen for "How to create a one
variable data table."

Sarah

"Peo Sjoblom" wrote:

Note that you have to select a "single rectangle that is more than one row
high and one column wide"

Regards,

Peo Sjoblom

"Sarah Bee" wrote:

I have re-created the example from Microsoft Excel Help from "Creating a one
variable data table", and when I select "Data Table" then select "Column
input cell" I select the cell specified in the example. I receive the message
"Input cell reference is not valid" The same thing happens when I try to
replicate the two variable data table from Microsoft Help.