Forum Discussion

Suman270's avatar
Suman270
Copper Contributor
Jan 23, 2024

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 

  • GeorgieAnne's avatar
    GeorgieAnne
    Iron 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!

     

Resources