Forum Discussion
Excel automatically undid changes
HelenaDavidson We have a spreadsheet that is automatically updated by a utility. It creates circular references every day, and the spreadsheet has to be edited and tweaked up to make it pretty everyday regardless of whether there are circular references or not. You have to open it, fix all the circular references, save it, and close it. Then when you open it again, you can work like normal without issue. If you leave a circular reference or don't get them all fixed before Excel checks for them again (I don't know if there is a timer for this or something else triggers it), all your changes will all get backed out and you have to start over. Based on the other comments, I agree that it's caused by the circular references and whatever process Excel uses to find them. I hope it gets fixed too.
- I thought I was going crazy - when there were things in other workbooks I had opened were Undone when a circular reference happened in a different one. I hope there is a fix soon that maybe asks with a dialog box before it magically undoes whatever - also not undoing things from the other open workbooks / worksheets
