Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. -- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |