xlsx Excel workbook (or possibly just Excel Workbook, depending on your Excel version). As the file got bigger itbecame slower to make cell and row changes.
You may have enabled Compatibility Mode to work with an older version of Microsoft Office, but now you need to turn it off so that newer versions will work properly, or so that you can use a specific feature that isn’t available in older Excel file versions. If this is the case, then it is possible that Compatibility Mode in Excel is the culprit. You may find your Excel spreadsheets crashing, freezing, or maybe you can’t open a spreadsheet at all.
#Open office 2010 in compatibility mode how to#
How to Turn Off Compatibility Mode in Excel Note that if you are using a newer version of Excel and you have some items in your file that aren’t compatible with that version of Excel you will see a pop-up window letting you know that.
#Open office 2010 in compatibility mode full#
If you have been experiencing errors with your spreadsheet and want to fix the problems, take a moment to review the compatibility mode for your version of MS Excel.įor example, if you are using an older version of MS Office on Windows 7, your default option may not give you full compatibility with all the latest versions of Microsoft Excel.Įssentially compatibility mode in Excel is a means to check that anything you are doing in your file will work for other people that might be using older or different versions of the Microsoft Excel application. There are many different versions of Microsoft Excel, and it can be difficult to tell which version of Excel you are using unless you are very familiar with all of the different releases.
4 Additional Reading Microsoft Excel Compatibility Mode