You can do it this way: File > Options -> Trust Center -> Trust Center settings -> Protected View. For safety reasons, you should save your document with new Office format like. Restart Excel and try to open the broken Excel documents. Uncheck all the options under Protected View and confirm by pressing OK.
