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. Describes how to resolve the issue where Workbooks are opened in compatibility mode Excel 2010 or Excel 2007. However, you will want to ensure that the worksheet contains no or just minor compatibility issues. Let's create and save a new *.xlsm file in Excel 2010, save it as *.xls, then disable Compatibility Checker … Is it possible to have it in the macro "not to check compatibility when saving this workbook" ? I recorded a macro in excel. Manage compatibility mode for Office. On the TaskScheduler window, go to this path: Task Scheduler Library\Microsoft\Windows\Application Experience. To verify that a workbook is compatible with Excel 2013, 2010, or 2007, run the Compatibility Checker manually the first time you save your workbook. Then set the Compatibility Checker to run automatically every time you save that workbook. Once you’re done, you may check if the issue persists. If you're adventurous, you can try the Disable Excel Compatibility Checker plug-in over on Excel Guru. Learn how to keep in touch and stay productive with Microsoft Teams and Office 365, even when you’re working remotely > Learn how to keep in touch and stay productive with Microsoft Teams and Office 365, even when you’re working remotely > Compatibility Checker warning for Data Validation. So by default whenever you save a file in EXCEL 2010, it saves it as a .XLSX but as a good practice, save it as well as a, save as or F12 on the keyboard and save it … ... you should . When you Save an Excel 97-2003 file(xls) that you have open in Excel 2007-2013 or use Save As to save an Excel file that is open in Excel 2007-2013 as Excel 97-2003 file (xls) it is possible that the Compatibility Checker dialog pops up. Run the Compatibility Checker for Excel 2007 and later. Applies to: Excel 2010 Excel 2013. You can use the following VBA subroutine to save an Excel 2007 or Excel 2010 worksheet as an Excel 97 through Excel 2003 workbook and avoid the Compatibility Checker dialog. You can find the add-in on my main site. This changes the way the document appears and … Word, Excel, and PowerPoint use compatibility mode to open binary Office documents that were created in Office 2003 or earlier versions of Office. Applies to: Office 365 ProPlus, Office 2019, and Office 2016 In Office, compatibility mode is used automatically to open Word, Excel, and PowerPoint documents that … Hi Saqib, The pop up message appears when there's a compatibility issue with the workbook created in the latest Excel version. How to Stop compatibility warnings Using Office '10, I have the default file save set to .xls since created worksheets often go to people using earlier Excel versions. Note: You only see this dialog if there are features in the workbook that are not supported in Excel 97-2003. Is it possible to have it in the macro "not to check compatibility when saving this workbook" ? Compatibility Checker in Excel 2007-2013. It will disable the Compatibility Checker on all files that have already been saved at least once in Excel 97-2003 format. New files are a little more problematic, though, as they seem to kick off the check even if you tell it not too. If you're adventurous, you can try the Disable Excel Compatibility Checker plug-in over on Excel Guru. The author says it's pretty basic, only works with .xls files, and hasn't been tested all that thoroughly. To verify that a workbook is compatible with Excel 2013, 2010, or 2007, run the Compatibility Checker manually the first time you save your workbook. Find answers to VBA - Disable Excel 2010 Compatibility Checker from the expert community at Experts Exchange We do not use anything close to advanced Excel abilities so saving as .xls is just fine. Microsoft Excel Compatibility Checker Disable buy microsoft works 90 adorage 13 microsoft project 2010 step by step ebook To disable the Compatibility Checker 1. Run the Compatibility Checker for Excel 2007 and later. Right-click on it, select Disable, and then confirm to complete the process. But hey, might be worth checking out. 2) Does this issue occur only with a specific Excel file or on all Excel files? On the Application Experience folder, look for Microsoft Compatibility Appraiser. Disabling the Excel Compatibility Checker Posted on September 24, 2008 by Ken Puls Due to several comments about how much people hate this thing, I've pulled together a very rough, very simple add-in. It's goal is to disable the Compatibility Checker as much as possible. Learn how to keep in touch and stay productive with Microsoft Teams and Office 365, even when you’re working remotely > ... Workbooks are opened in compatibility mode Excel 2010 or Excel 2007. it works fine but stops before saving the file and i get the "Compatibility Checker". Follow these steps: Click File > Info > Check for Issues. 6/4/2019; 2 minutes to read; In this article. 1) Did you originally create the *.xlsm file in Excel 2010 or in earlier version? Select Product Version. Microsoft Excel Compatibility Checker Disable buy microsoft works 90 adorage 13 microsoft project 2010 step by step ebook The author says it's pretty basic, only works with .xls files, and hasn't been tested all that thoroughly.