Forum Discussion
Suman270
Jan 23, 2024Copper Contributor
Excel crashing on clicking merge and centre tab
While working on Excel ( Microsoft office 2016) , on clicking the 'Merge and centre' tab, Excel is crashing and closing the document in it's own. If someone can help in resolving the issue
- GeorgieAnneIron Contributor
Hello Suman270
Have you tried the Open and Repair option?
It seems you may have a corrupted workbook. Open and repair "MIGHT" get you to a better position. Worth trying but make sure you use a copy for a backup just in case.
Close and shut down your machine using the SHIFT+SHUT DOWN option.
When the machine restarts, ONLY open MS-Excel, and then ONLY open the copy of the workbook in question. Let MS-Excel try and repair the workbook, and AFTER the workbook is "repaired" SAVE this repaired workbook WITH A NEW NAME in a NEW LOCATION, preferably a local drive. Then redo the shut down with the SHIFT+SHUT DOWN option and then ONLY open MS-Excel, and then ONLY open the repaired workbook. If all is GOOD save it locally with the name you want and MAKE COPIES!
Best of luck!