I have a macro spreadsheet, that has started to not recalculate the sum when data is altered.
The sheet is set for automatic calculation and the setting for automatic calculations are in place.
But when data is changes the =SUM formula does not alter unless the cell is edited by using Function F2 which then changes the total to the correct new number?
What is the corruption and how can it be rectified?