Forum Discussion
"Calculate" Emptying Undo Stack
I have a fairly complex excel workbook that is used as a "Template". All copies of this document are having this same issue.
There is never an ability to Undo in the workbook. At first I thought it could be due to a macro, but I have since realized that the undo stack is emptied every time the workbook calculates (i.e. every time a cell is edited, it immediately clears the undo stack once you press "Enter"). If I turn on manual calculation, undo stays available up until "Calculate" is pressed.
I don't have any macros that are set to run upon calculation, so I'm not sure what is causing this.
Also, if I have this workbook open, the issue begins happening even in a new blank workbook. I can't find any reason behind why calculating the workbook would cause the undo stack to empty.
- I don't know either but some things I would further try to narrow it down is save the workbook as xlsx (i.e. remove the macro functionality), also you can use this tool to find and inspect and remove any external references throughout the book: https://manville.org.uk/software/findlink.htm
and you could try moving/copying sheets to a new workbook (1 at a time) and see if the problem follows.
Again these are just a few ideas how to hopefully narrow down the source of the problem.
4 Replies
- it sounds like you have macros in the sheet, so try opening the workbook with macros disabled and see if that still happens. At least that can help verify that it is a macro causing the effect. When looking for a macro that might be causing it remember you need to open each object (workbook and each worksheet) and not just the module sheet(s).
mtarler thank you for your response! I agree, the likely culprit seems like a macro, but I have tried opening with macros disabled and had the same result. I also have gone through each worksheet and each module to make sure no macros would be running upon calculation of the workbook and found nothing. Not sure what else could be causing it, though?
- I don't know either but some things I would further try to narrow it down is save the workbook as xlsx (i.e. remove the macro functionality), also you can use this tool to find and inspect and remove any external references throughout the book: https://manville.org.uk/software/findlink.htm
and you could try moving/copying sheets to a new workbook (1 at a time) and see if the problem follows.
Again these are just a few ideas how to hopefully narrow down the source of the problem.
