Hello, I've recently noticed a problem with some of my worksheets and it seems to be spreading.
When I update (change) a value in a cell that forms part of a range included in a total the total (eg @sum) does not update (new total) unless i re-enter formula by highlighting cell, hit f2 and enter.
Obviously this is of no use to me. Cells are formatted as Accounting or special.
Thanks in anticipation
John