Forum Discussion
Excel automatically undid changes
JS4269 that's an interesting observation, I've only had it in the context of a circular reference on a particular operation and I now try desperately to avoid such references and immediately correct them if they should occur.
I do hope that Microsoft are listening on this as your experience sheds new light on this old problem, which certainly deserves their urgent attention as it's devastating to lose all your work.
I'm getting many of the odd behaviours detailed above, including no responding when trying to select a cell, pasting text and suddenly getting many undos, having to go into each cell to activate or redo the formula. With some the cells which have been used to join text from a number of cells the result is still right after the undo happens, the reference cells are wrong but when I hover over these cells it shows more recent text but actually won't let me change the text in the cell. This happened once so the detail here may be slightly inaccurate.
I'll try to redo the spreadsheets - start afresh as suggested. Saving and opening the spreadsheets hasn't always returned to pre-undos.