• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Browsers
    • Gaming
    • Hardware
    • Internet
    • iPhone
    • Linux
    • macOS
    • Office
    • Reviews
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About
Excel: Permanently Disable Compatibility Checker Dialog

Excel: Permanently Disable Compatibility Checker Dialog

August 26, 2018 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 "Are you sure you want to move this file to the Recycle Bin?" Dialog
    Windows 10: Disable "Are you sure you want to move this file…
  • Windows 10: Disable Sticky-Keys Permanently
    Windows 10: Disable Sticky-Keys Permanently
  • iTunes: Permanently Disable iPhone or iPad Backup Process
    iTunes: Permanently Disable iPhone or iPad Backup Process
  • Enable/Disable Display of Formulas in Cells in Excel
    Enable/Disable Display of Formulas in Cells in Excel
  • How To Empty Folders Permanently in Gmail
    How To Empty Folders Permanently in Gmail
  • Turn Off "This will be permanently deleted" Message in Outlook
    Turn Off "This will be permanently deleted" Message in…

Filed Under: Office Tagged With: 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 lot@ 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!

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

  • How to Print Labels from Excel Using MS Word Mail Merge
  • What Is NVMe Over TCP (NVMe/TCP)
  • Android Mobile Hotspot: How to Change the Password and Name
  • Windows 10: How to Force Quit and App
  • What is Dumpster Diving?
  • How to Download iOS 16 Beta 3 on iPhone or iPad
  • What is a Security Compromise?
  • Mastodon: How to DM Someone

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.

© Copyright 2023 Guiding Tech Media · All Rights Reserved · Privacy