Why does excel open in compatibility mode

Office Office Exchange Server. Not an IT pro? Learn More. Internet Explorer TechCenter. Sign in. United States English. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. Excel IT Pro Discussions. This forum is for general questions and feedback related to Microsoft Excel all versions as they pertain to the IT Pro community.

Sign in to vote. My app opens automatically in compatibility mode. How do I turn that off. I only want to use this when I need it. Improve this question.

Yisroel Tech 4, 2 2 gold badges 16 16 silver badges 24 24 bronze badges. Add a comment. Active Oldest Votes.

Improve this answer. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.

The Overflow Blog. Then set the Compatibility Checker to run automatically every time you save that workbook. To check for compatibility automatically from now on, check the Check compatibility when saving this workbook box. Tip: You can also specify the versions of Excel that you want to include when you check for compatibility. All versions are checked by default, so just uncheck the versions you don't want to include.

If any issues are found, the Find link takes you to that place in your worksheet, and the Help link takes you to information on the issue and possible solutions. Note: You can also use the VLOOKUP function in Excel to address this issue, but the process is somewhat complicated, and becomes more complicated as the number of data sources to combine increases. Excel and earlier versions don't support data features that analyze multiple tables, because those Excel versions don't have a Data Model.

If your workbook contains any such features, you may be able to prepare them for use in earlier versions by combining the feature's data sources into a single table and then using that new table as the data source. One way to do this is to use Access to combine the data sources and reproduce them as a query, which you can then import into your workbook. The process goes like this:. In Access, import each original data source as a new table. In Access, recreate each of the relationships.

In Access, create a query that contains all the fields your Excel data feature needs. In Excel, import the query into a new worksheet as a table. Once your data is in one table in Excel, choose that table as the data source for the data features that were using multiple tables, or recreate the data features and choose the new table as their data source.

You can always ask an expert in the Excel Tech Community or get support in the Answers community. Excel formatting and features that are not transferred to other file formats.