Table function, 2 variables. Problem with update/refresh
 

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

Table function, 2 variables. Problem with update/refresh
 

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"lorenzo" wrote:
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

Table function, 2 variables. Problem with update/refresh
 

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

it's very strange...

Max wrote:
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.
--

Table function, 2 variables. Problem with update/refresh
 

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"lorenzo" wrote in message
ps.com...
thanks...but doesn't work...

it's very strange...

Table function, 2 variables. Problem with update/refresh
 

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 wrote:
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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"lorenzo" wrote in message
ps.com...
thanks...but doesn't work...

it's very strange...

Table function, 2 variables. Problem with update/refresh
 

I'm out of guesses here. If you could post a link to a sample copy of the
file, I could take a look.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"lorenzo" wrote in message
ups.com...
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!