View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lorenzo lorenzo is offline
external usenet poster
 
Posts: 12
Default 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