updating function

[amitash]

i use a module for summing up cells that are not white (colored)

it works but when i change the one of the cells' color the function wont update/

only after I change one of the colored cells' value' the function updates...


what can I do?

[martindwilson]

Try f9 to force recalculation

[amitash]

it doesnt work......

anybody????

[martindwilson]

try
<ctrl>+<alt>+<f9>.

[amitash]

works!!!!


thanks.