Trace Precedents, Trace Dependents, and Remove Arrows should be integrated into the Undo stack, not clear it
For example, use the formula =A1 in B1. If you use Trace Precedents on B1 or Trace Dependents on A1, you will lose your Undo history. If you make further edits and then use Remove Arrows, you will also lose your Undo history. My suggestion is that these actions should be Undo-able. That is, they should be integrated into the Undo stack rather than clear it.
5 comments
-
Daniel Wise commented
Frustrating to lose undo history when QAing a complicated workbook.
-
Daniel commented
I have been caught losing my Undo history by the "Trace..." commands. I agree it would be nice not to lose them.
-
Anonymous commented
I use the auditing function a lot on large multi-tab spreadsheets. Haven't been caught yet trying to undo a change after tracing precedents, but it would be best to not be prevented form doing so.
-
Bill commented
MS should fix this defect in Excel.
-
Eric Franklin commented
This could even be made an option that could be turned off/on as the user saw fit.