• Skip to main content
  • Skip to primary sidebar

Technipages

Smart phone, gadget and computer tutorials

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About
Excel: Permanently Disable Compatibility Checker Dialog

Excel: Permanently Disable Compatibility Checker Dialog

By Mitch Bartlett 8 Comments

If you upgrade to Microsoft Excel 2016, 2013, or 2010, you may encounter a “Compatibility Checker” dialog every time you try to save the file using an older file format. In most cases, you can simply select the “Check compatibility when saving this workbook” box, then select “Continue”, then proceed without problems. If you work with many Excel spreadsheets though, it can become tiring to constantly have to select “Continue”.

Excel Compatibility Checker Dialog

While there are ways to prevent the Compatibility Checker dialog from appearing in a single file, there doesn’t seem to be a setting to permanently stop it from appearing.

Fortunately, there is a solution. A plugin is available that disables the Excel Compatibility Checker and prevents it from ever appearing. Follow these steps to install it.

  1. Download DisableCompatCheck.zip.
  2. Unzip the file to your Windows Desktop. It should appear as “DisableCompatChecker.xlam“.
  3. Open Excel, then select “File” > “Options” > “Add-Ins“.
  4. At the bottom where it says “Manage – Excel Add-ins“, select the “Go…” button.
  5. Select the “Browse…” button.
  6. Navigate to the Desktop, then select the “DisableCompatChecker.xlam” file.
  7. Select “OK“.

The plug-in should now be installed in Excel and block Compatibility Checker messages. It should work just as though you selected “Continue“.

You Might Also Like

  • Windows 10: Disable Sticky-Keys PermanentlyWindows 10: Disable Sticky-Keys Permanently
  • Windows 10: Disable "Are you sure you want to move this file to the Recycle Bin?" DialogWindows 10: Disable "Are you sure you want to move…
  • iTunes: Permanently Disable iPhone or iPad Backup ProcessiTunes: Permanently Disable iPhone or iPad Backup Process
  • Enable/Disable Display of Formulas in Cells in ExcelEnable/Disable Display of Formulas in Cells in Excel
  • How To Empty Folders Permanently in GmailHow To Empty Folders Permanently in Gmail
  • Turn Off "This will be permanently deleted" Message in OutlookTurn Off "This will be permanently deleted" Message…
  • Facebook: Permanently Delete Messages From Both SidesFacebook: Permanently Delete Messages From Both Sides
  • Android: Permanently Turn Off Google Voice SearchAndroid: Permanently Turn Off Google Voice Search
  • How to Add a PDF to ExcelHow to Add a PDF to Excel

Filed Under: Office Tagged With: Excel 2013, Excel 2016

Reader Interactions

Comments

  1. Maan says

    October 4, 2019 at 6:40 am

    How can i get it back on Win10?

  2. Litze Smurf says

    July 25, 2019 at 12:10 pm

    Thanks so much, in my Excel 2013 the dialog window vanished, what a relief! Great job!

  3. Dilon DAs says

    January 8, 2019 at 12:39 am

    Thanks a [email protected] just downloaded the file ^& lo after clicking on the unzipped file the error”check compatibility box’ simply disappeared for the time being :) hope its a permanent solution. Thanks for the info

  4. Joe says

    May 26, 2018 at 5:48 am

    No

    I have Excel 2016 and it did not work.

  5. MAF says

    October 25, 2017 at 10:05 am

    It seemed to work for Excel 2016. Thanks so much! I have hundreds of older Excel files to update and this really helps.

  6. Dana says

    February 15, 2017 at 10:44 am

    These options only work per spreadsheet, so you have to do it for each document you need.

  7. Gl Cuevas says

    January 10, 2017 at 2:45 am

    not working on my excel 2013. We have this excel template with macro and pivot table and we need to bypass the compatibility checker. Do you have any idea on how to disable it?

  8. Roman Golubev says

    June 2, 2016 at 11:01 pm

    There is a way of disabling it for Office 2007 and 2010:
    To disable the Compatibility Checker
    1. (Excel 2007) On the Office button, click Prepare, click Run Compatibility Checker, and then clear the Check compatibility box when you save this workbook .
    2. (Excel 2010) On the File tab, click Info, click Check for issues, click Check Compatibility, and then clear the Check compatibility box when you save this workbook.

Did this help? Let us know! Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • Microsoft Teams: How to Deal With AADSTS Errors
  • Slack: Configure What Happens To Notifications When You’re Not Active on the Desktop
  • How to Close Your LinkedIn Account
  • Stop Getting Signal Notices Every Time a Contact Signs Up
  • Slack: How To Hide Who Is Currently Typing a Message
  • Slack: How To Disable Animated Images and Emoji
  • Fix Microsoft Teams Error Loading Chunk
  • Microsoft Teams Notifications Not Working on iPhone

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

Follow me on Twitter, or visit my personal blog.

You May Also Like

© Copyright 2021 Technipages · All Rights Reserved · Privacy