Example: I have a formula in column C that is a function of values in columns A and B. When I change a value in A or B and press enter, the value in C auto-updates. However, when I Ctrl-Z, the value in Column C does not automatically revert back to the original value before my change. In the past, I have used undo/redo as a quick check on how my changes affect the formula, but that no longer seems to work. Any ideas?
My workbook calculation is set to 'Automatic'. I have Excel 2016.
Since it's such a seemingly-simply problem, this will help find the issue:
That must work - so after that try the non-working workbook, if that one's still not working, copy & paste values and formulas to the "working workbook". The problem should now be resolved.