Forum Discussion
Excel shutdown when a macro is running
There could be several reasons why Excel is shutting down when you try to run a macro.
One possibility is that there is a bug in Excel or that your Excel installation is corrupt.
Another possibility is that the file itself is corrupted.
You could try testing if the file works on another computer.
If it does, then your Excel installation might be corrupt.
If it force closes on other computers too, then either Excel has a bug or your file is corrupted.
You could also try using the “Open and Repair” option when opening the file and see if that helps.
If none of these solutions work, you may need to rebuild the file from scratch.
Links with Informations:
Open Office apps in safe mode on a Windows PC
Repair an Office application - support.microsoft.com
How to perform a clean boot in Windows
Here is a link with information on how you can get a quick and precise solution proposal.
Welcome to your Excel discussion space!
Thank you for your understanding and patience
I know I don't know anything (Socrates)
Thank you very much coming to me with your help.
Unfortunately, like you suggested me, I' tried the "repair " action, but it doesn't change anything.
I can add when a simple erase row is tried, nothing done , I close my file and open it just after and this action run normally. That's an other strange action from excel...
I trying to continue my job with all these problems (changing macro, restart my excel file and so ) but I really don't understand why all these append. I thought it would be a question of update from office 365 to new version...
I don't know what to do, I hope I will succeed to stabilize this situation ...
Have you performed all Windows and Office updates?
Does this problem only appear in a specific file? ...if so, you should see the file and/or which VBA code it is.
What extension does the file have? (.xlsx, xls, xlsm, etc.)
Did you open Excel in Safe Mode and then the file? ...did it work there?
If yes, disable all AddIns in your Excel and restart excel without Safe Mode to see if the problem has been fixed.
If all this has been done and the problem does not only occur with one file, you can actually only uninstall and reinstall the Office package.
But if it only occurs in this file, you would have to look at the file to be able to say something concrete.
It could also be a bug, but I don't have any information on whether it could actually be a buck.
At the end, I recommend providing more detailed information about the digital environment. Such as the exact Excel version (this can be called up with the windows command "winver"), operating system, storage medium (OneDrive, Sharepoint, hard disk, etc.), this would help rule out a few things.