• Disable the Excel Compatibility Checker

    I've received several comments on my blog that people dislike Excel 2007's Compatibility Checker, and would like to turn it off globally. While it's true that you can turn it off for each workbook, the main user interface seems devoid of a way to actually tell Excel that you never want to check your workbooks for compatibility when saving to 2003 or earlier versions.

    This issue seems to hit me most when trying to an Excel 2007 workbook that uses conditional formats or colours (colors) back into the Excel 2003 file format.

    The add-in attached gets half way to accomplishing the job. I knocked this up very quickly, so it can almost certainly be improved. If anyone wants to give it a go, I'd happily host an updated version and give you credit.

    Now, I said I'd got half way..

    The attached add-in will disable the compatibility checker on all .xls files that you attempt to save. What it won't catch is new files that have not been saved as Excel workbooks yet. So if you create a brand new workbook and hit save, you'll see the interface like the following:


    Save it again immediately, and you won't get the message any more.

    Please note that this add-in has received very limited testing. Comments and suggestions for improvement are welcome, just leave a comment here!

    To install it:
    • Download the file
    • Unzip the file and save the addin on your computer
    • Go to Office Menu-->Excel Options-->Add-ins-->Go-->Browse
    • Navigate to the file and select it
    • Make sure the box is checked next to "Disable Compatibility Checker" and click OK

    That's it. No visible changes to the UI. Test it out by saving a workbook in .xls format that has some colours or conditional formats in it.

     

    I'm afraid that you must be logged in to comment or leave a testimonial. I wish it could be otherwise, but I'm trying to keep my site spam free for everyone's benefit. If you don't yet have an account it's completely free to sign up, and a very quick process. Simply click here to Register. Not only can you post a comment here, but it gives you full access to posts questions in our forum as well!

     

    If you already have an account, and just haven't logged in yet, what are you waiting for? Login Now!

  • MVP Logo
  • Recent Forum Posts

    Bob Phillips

    Please help!

    This array formula will add up the sums

    =SUM(IF(A2:A20"",(--LEFT(A2:A20,8)=--"2020-11-24")*SUBSTITUTE(MID(A2:A20,11,99),")","")))...

    Bob Phillips Yesterday, 08:46 PM Go to last post
    Bob Phillips

    Index/match with multiple match criteria

    When I said Q1, I meant Quarter 1, cell E31, not cell Q1.

    It most definitely does match your last upload, C8:C30 is the date which I parse,...

    Bob Phillips 2020-11-24, 06:44 PM Go to last post
    GLewis14

    Consolidate paired data sets

    hi all,

    I have a sheet which contains data sets (3 rows per data set), see Product Level sheet of attachment. I want to consolidate and total...

    GLewis14 2020-11-24, 02:46 PM Go to last post
    alansidman

    Please help!

    What is the criteria for counting the quantity. Would be helpful if you provided a sample workbook showing what you have and what your expected results...

    alansidman 2020-11-24, 06:21 AM Go to last post
    cprop76

    Please help!

    I am trying to count two separate pieces of data which appear in the same excel column. The columns will have a date followed by a quantity so look something...

    cprop76 2020-11-24, 05:52 AM Go to last post