• 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

    samdthompson

    Acess data in shared onedrive file

    I am going to spend an afternoon tinkering with creating a flow so see if there is something I can do from that end. Silver lining, its nice to find something...

    samdthompson Today, 01:01 AM Go to last post
    Ken Puls

    Acess data in shared onedrive file

    Damn. I suspect that we're stuffed here. With using the owner's email, that means that you would need to provide their credentials to connect to that...

    Ken Puls Today, 12:53 AM Go to last post
    samdthompson

    Acess data in shared onedrive file

    Yip, the file path is different. It shows the owners email rather than mine.

    I have also tried accessing as web URL, plain excel file but...

    samdthompson Today, 12:29 AM Go to last post
    polonic

    Automate some steps in IE, with VBA

    hello everybody,
    i`m here to search for some help, if is possible.

    i was trying by myself to scrap some vba code to automate some steps...

    polonic Yesterday, 09:34 PM Go to last post
    hbgurley

    Help With SumIfs

    Your formula in column O3 was very close. The problem was that your named ranges were different lengths. WeekNo went from A2:A69 while Worker and TimeTaken...

    hbgurley Yesterday, 08:53 PM Go to last post