View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dean[_8_] Dean[_8_] is offline
external usenet poster
 
Posts: 407
Default More Data Table Problems

Some of my 2-dimensional data tables stopped working when I made some
changes to a file. Am I right that the column and row input row variables
CAN be used in the row across the top and column down the side? That is,
none of these needs to be a number?

For example, I have a 5X5 data table with the row variable being cell D4,
and the entries across the top are d4-100,000, d4 - 50,000, d4, d4+50,000,
d4 +100,000. Is this legal? Strangely, a value does appear beneath the 4th
entry (d4+50,000), but not below any of the others - they all show "#Value".
I'm talking about the first row here and coincidentally, the column entry is
a number there, whereas for the other rows, they are equations.

In the 2nd row, they all show #value. If I change one of the column
scenarios to be tied directly to the column input variable, it does not help
and, from the answer showing in the top left corner of the data table, I
know this does have a real answer.

Do data tables have known problems? It seems like they are finicky?

I tried erasing it and copying it in from the older file that did work, but
it did not copy the data table matrix formulas. Then I just tired redoing
the data table, but that did not help either.

Thanks!
Dean