You seem to be interpreting what a data table does a bit differently than I
do. With a 2 way table you designate 2 cells outside of the table as input
cells. Those input cells drive some formula that references them. The top
left corner cell of your data table can be that cell or directly reference
it. The top row and first column of the data table (except for the top left
cell) provide values to be plugged into the 2 input cells behind the scenes
by Excel. From that point of view it makes no different if the values of
the top row and left column of the data table are as a result of directly
entering a constant, or as a result of a formula being calculated. All that
matters is the cell's value. If the value is '2' it can be because the cell
held '2' or =1+1 or =B12 where B12 is 2.


"DA" wrote in message
...
Thanks for your reply, Jim. So, you see no problem with EXCEL
'breaking the link' between a cell and its precedent cells and simply
testing values in the former? To me, this is a dicey proposition. In
fact, that cell may never be able to have one of those values,
considering the cells that drive it.

Thanks,
Dean