Excel problem

Won't update formula

Didn't find your answer?

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.

avatar
By pjd17mini
04th Jan 2018 12:16

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

Thanks (2)
Replying to pjd17mini:
joe
By Smokoe Joe
04th Jan 2018 12:28

That was it, thought there was something like that but didn't know where to look, many thanks.

Thanks (0)