Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Mid Function Problem | Excel Discussion (Misc queries) | |||
VBA Function that ignores dates in a Holiday Table | Excel Worksheet Functions | |||
function defaults change in Pivot Table..why? | Excel Discussion (Misc queries) | |||
Solver problem where 'IF Function' is bad | Excel Discussion (Misc queries) |