Hi All,
Ok, I have never seen this one before. I have a cell that contains a simple sum formula of the cells above. When I change the value in one of the cells above the sum cell, the new result is superimposed over the old sum value, making the result hard to read because the old value has remained in the cell. When I page down and then page back up the normal refresh of the cell occurs. Stumped on this one, using XL2007.
Thanks, TC
Ok, I have never seen this one before. I have a cell that contains a simple sum formula of the cells above. When I change the value in one of the cells above the sum cell, the new result is superimposed over the old sum value, making the result hard to read because the old value has remained in the cell. When I page down and then page back up the normal refresh of the cell occurs. Stumped on this one, using XL2007.
Thanks, TC
Last edited: