When I update figures in a spreadsheet column it won't update totals and if I click and hold to copy formula it shows the total from the source column.
However, when I save and re-open everything is right.
Any help gratefully received
Replies (2)
Please login or register to join the discussion.
It could be that you've accidentally switched off automatic calculation (Formulas -> Calculation options) or there is a problem somewhere, like a circular reference, in which case excel will have switched off automatic calculation until the circular references are resolved.
HTH
P