Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Facebook Twitter Instagram
Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Tech News Today
Home»Software»Excel»How to Turn Off Excel Compatibility Mode?

How to Turn Off Excel Compatibility Mode?

Asmi DhakalBy Asmi DhakalAugust 15, 2022
turn-off-excel-compatibility-mode

The compatibility mode on Excel allows users with previous versions of Excel to view documents created in newer versions of Excel. However, the compatibility mode disables features like PivotTables, Scalable Vector Graphics, and Timelines as they’re not available in the previous versions of Excel. 

You can easily turn off the compatibility mode if you believe it is no longer useful to you. In this article, we will cover everything from turning off the compatibility mode for a single document to all documents you will create in the future on Excel, so keep reading!

Table of Contents

  • Why Turn Off Compatibility Mode?
  • How to Turn Off Excel Compatibility Mode?
    • Change Save Format
    • Convert File Compatibility
    • Change File Format
    • Disable Check for Compatibility (Office 365)

Why Turn Off Compatibility Mode?

There can be a range of reasons why you would want to disable the compatibility mode in Excel. For starters, it creates issues using newer features like the Label information, 3D models, Slicers, etc. This can be an issue if you want to use the disabled features.

The compatibility mode will also be of no use to you if the peers you share your documents upgraded to the same version of Excel you have. When you share the same version of Excel, all the tools you use in your document will be available on your peer’s version of Excel. 

How to Turn Off Excel Compatibility Mode?

There are three ways to turn the compatibility mode off in Excel. If you use the Office 365 version of Excel, there is an additional way to turn this feature off. You can turn the compatibility mode off for a document you’ve already created or the entire Excel application. 

Change Save Format

You can change the save format for all future files on Excel. Depending on the format you choose, Excel will now save your files in that format. To disable the compatibility mode, you must change the save format to your current version of Excel. 

Follow these steps to change the save format of your documents on Excel:

  1. Launch MS Excel.
  2. From the homepage, head to Options on the sidebar. If you don’t see it, select More > Options.
    ExcelOptions
  3. In the Excel Options window, hop on to Save from the panel to your left.
  4. Under Save workbook, locate Save files in this format.
  5. Drop the menu down next to it and select your current version of Excel.
    ChangeSaveFormatExcel
  6. Click on OK on the bottom-right corner of the screen.

Convert File Compatibility

You can also convert an Excel file compatible with an older version to the version of Excel you own. You get the Convert feature when you open an older version of an Excel document in a newer Excel program. Using this feature, you can upgrade your document to be compatible with your version of Excel.

Follow along with the steps mentioned below to convert an Excel file to the version you own:

  1. Open the compatible workbook. 
  2. Head on to File from the menu bar.
  3. From the sidebar, select Info.
  4. Next to Compatibility Mode, select Convert.
    ConvertFromCompatibilityModeExcel
  5. Confirm your action by selecting OK on the pop-up. 
  6. Excel prompts you if you want to use the enhanced features available on the current version. Choose Yes or No according to your preference.

Change File Format

If you want to change the compatibility for a single document in Excel, you can change the file format for that document. You can conveniently change the file format when you’re saving your file on your device. 

Here are the steps to change the file format for a single document for Excel:

  1. Open your Excel workbook.
  2. Head on to File from the menu bar. 
  3. From the panel to your left, select Save as.
    BrowseToSaveLocationExcel
  4. Under Other locations, select Browse.
  5. From the Save as window, navigate to the location where you want to save your file.
  6. Locate the Save as type option and drop the menu down next to it.
    ChangeFileTypeExcel
  7. Select your Excel version from the list.
  8. Click Save.

Disable Check for Compatibility (Office 365)

This method is exclusive to the Office 365 version of Microsoft Excel. The Office 365 version of Excel allows users to see if any feature can cause a compatibility issue in the older versions. You can disable this feature if you do not want Excel to check for compatibility issues. 

Use the following steps to disable the check for compatibility feature in the Office 365 version of MS Excel:

  1. Open your spreadsheet on MS Excel.
  2. Select File on the top-left corner of your menu bar.
  3. Hop on to Info from the panel to your left.
  4. Next to Inspect Workbook, select Check for Issues.
  5. From the drop-down menu, click on Check Compatibility.
    ExcelCheckForCompatibility
  6. In the compatibility checker window, deselect the option for Check compatibility when saving this workbook.
    CompatibilityCheckerWindowExcel
  7. Select OK on the bottom-right corner.
how-to
Asmi Dhakal
  • Twitter
  • LinkedIn

Asmi Dhakal is a Tech Writer specializing in Microsoft Office-based programs at TechNewsToday. She aims to use her experience to help others learn their way around its programs. Asmi’s interest in Office products grew when she first entered the marketing industry. While she initially struggled to understand their application, she eventually understood her way around them. In her articles, she exhibits a strong understanding of related issues and attempts to push only relevant fixes. Over time, she has grown a particular fondness for MS Excel and spends her free time learning Visual Basic Analysis (VBA). She’s always on the lookout for productivity tools that can get the job done quicker in Excel. Her approach to related problems is very humane, helping new users not only fix the issue but learn more about its nature. Asmi also heavily indulges in personal writing. She is a disciplined journal writer and has maintained a regular journal for 8 years! When her schedule allows, she works to rehabilitate street animals. You can contact her at asmi@technewstoday.com

Related Posts

check mark in excel

How to Put Check Mark in Excel

January 20, 2023
best excel shortcuts

Best 52 Excel Shortcuts Only Experts Know

January 19, 2023
How to Find and edit Hyperlinks on Excel

How to Find and Edit Hyperlinks on Excel

January 23, 2023
how to find unique values in excel

How to Find Unique Values in Excel

January 15, 2023
how to find links in excel

How to Find and Edit External Links in Excel

January 13, 2023
reference isn't valid excel

Reference Isn’t Valid Excel Error – 6 Ways to Fix it

January 6, 2023
Add A Comment

Leave A Reply Cancel Reply

Latest Posts
Memory-Compression

What is Memory Compression in Windows? Should You Enable or Disable It

March 1, 2023
dism-vs-sfc-vs-chdsk

DISM, SFC, CHKDSK: What’s the Difference

February 28, 2023
bios-settings-for-gaming

Best BIOS Settings for Gaming

February 16, 2023
You may also like
e4-error-hp-printer

How to Fix E4 Error on HP Printer

March 5, 2023
renew IP address

How to Renew IP Address? 3 Best Ways

March 5, 2023
logitech mouse lag

8 Ways to Fix Logitech Mouse Lagging

March 5, 2023
Recommended
Cookie Clicker Garden Guide

Cookie Clicker Garden Guide to Unlocking Every Seed

September 26, 2021
monitor no signal

Computer Turns On But Monitor Says No Signal (9 Ways To Fix)

November 10, 2022
Facebook Twitter Pinterest
  • Home
  • About Us
  • Our Team
  • Editorial Guidelines
  • Privacy Policy
  • Affiliate Disclosure
© 2023 TechNewsToday, editor@technewstoday.com | Tech Central Pvt. Ltd.

Type above and press Enter to search. Press Esc to cancel.