Hi,
It sounds frustrating to have your Excel files not opening properly. Here are a few steps you can try to resolve this issue in Excel 2016:
First I suggest you open it in safe mode running the following command: Press Win + R, type "excel /safe" in the blank box, press Enter. If it works fine in safe mode, please check the add-ins in your excel and disable them.
Click File- Options- Add-Ins on the left side of the dialog. Then click the drop-down arrow at the bottom of the dialog box and select "COM Add-Ins" from the list, then click the GO button. What comes up is a list of COM-Add Ins that are loaded and running.
Then please uncheck DDE Option, Open Excel- go to File- Options- Advanced- Scroll down to the "General" section- Uncheck "Ignore other applications that use Dynamic Data Exchange (DDE)".
You can also try to repair Office application:
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.