Table function, 2 variables. Problem with update/refresh

[lorenzo]

Hi all!
i build a table that seems to work properly.

On the vertical axis i have 3 values and 5 on the horizontal.
No problems at all.

BUT
if i want to change 1 of the 3 values on the axis some weird happens.

if i link 1 value on the axis (let's say the middle value on the
vertical axis)
to another cell, the table updates, but with wrong values.
Instead if I TYPE the new value (exactly the same value) the table is
update properly.

It seems that the difference is not the number shown on the axis, but
the way i put it in the cell: if a create a reference to another cell,
doesn't work. If i write in the same value i see in the cell i want to
reference, no problem.
I tried to press F9 to update, but the result doesn't change.

i don't know if i have been clear...
thanks in advance

 

[Guest]

Venturing some thoughts ..

I'm not sure that this has anything to do with the Data > Table feature.
From the sounds of it, it could be simply a case of text numbers in the
source cells.

Try adding a zero "+0" in your link formulas,
eg use: =Sheet2!A1+0 instead of: =Sheet2!A1.

The "+0" may suffice to coerce the text numbers
to real numbers for correct evaluations.

 

[lorenzo]

thanks...but doesn't work...

it's very strange...

 

[Max]

Another thought. Could it be a situation that the source cell's underlying
value (that which you link to) is actually not say, an integer, but looks
like one because the cell with the link formula is formatted to display with
zero dp ? Eg: the source value is actually say: 1.597 but it looks like its
a: 2 in the linked cell. And depending on the scale of the ensuing calcs by
the data table, the discrepancies could be magnified even further.

 

[lorenzo]

thanks,
but the number in the cell and the number i write are exactly the same!
Also some of my colleagues (building the same model) noticed the same
behaviour, but nobody could explain it!

 

[Max]

I'm out of guesses here. If you could post a link to a sample copy of the
file, I could take a look.