Solution: First open the excel table that needs to be operated, click the "office" icon button at the top of the page; then select the "Save As" option in the pop-up drop-down list; then click the "Save As" list "Excel workbook"; finally save this workbook.
The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2007 version, Dell G3 computer.
The reason is that the opened table file was edited with a higher version of Excel. Now when opening it with a lower version of Excel, compatibility mode will appear. If you need to eliminate this mode, you can save a copy and open it in normal mode. Steps As follows:
First click the Office button in the upper left corner.
Then move the mouse to "Save As".
Then click "Excel Workbook" in the save list.
#Finally save this workbook, and then use the newly saved table file to edit, and the compatibility mode will no longer appear.
Related learning recommendations: excel tutorial
The above is the detailed content of What should I do if excel suddenly enters compatibility mode?. For more information, please follow other related articles on the PHP Chinese website!