Forum Discussion
Force Closing after Clicking "Show Calculation Steps"
...whenever I click Show Calculation Steps, no calculation step window appears and the Excel window freezes for a couple of seconds, then closes. When I open the closed file again, there's a recovery version.
I have this issue also, not sure when it started as I normally don't need it. I have checked and for I don't have any add-ins active, so didn't need to disable. I have done the Microsoft 365 online repair. It finised in about 10 minutes. The issue still persisted after that.
The formula I have in the cell that has the error is: =I7((I7-G20)/(G12))*G14 (this formula is located in a merge cell K4 and K5)
I found the error in the formula. The multiplication symbol between the first 'I7' and '(' is missing and when I put it there the error is gone. However, eventhough I managed to find the error in my formula, it should not crash when asking to show calculation steps.