Forum Discussion
Solved
"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 ...
- 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.
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.- Thank you for your ideas- I was able to locate the problem. It was a macro that for some reason was running even after the file was saved as .xlsx? Not sure how that was happening but I edited the macro and now the undo is working normally. Thank you for all the help.