Forum Discussion
Formula unable to see updated data unless I cut and repaste.
I have a fairly large spreadsheet with a bunch of formula cells using simple math functions. When I change the value of one of the input variables, the formula cell is unable to change the result. I ...
Check that you haven't accidentally turned manual calculation on..
Go to the Formula ribbon->calculation option. Make sure Automatic is ticked.
Check that you haven't accidentally turned manual calculation on..
Go to the Formula ribbon->calculation option. Make sure Automatic is ticked.