How to disable the annoying compatibility warnings in Excel?

Every time I edit a CVS or 2003-2007 Excel file it gives a warning that it will be saved in compatibility mode. I have this habit of saving every other minute via Ctrl+S and the window keeps popping up.

How can I disable this annoying 'Compatibility mode pop-up'?

For Excel 2003-2007 files you can uncheck the "Check compatibility when saving this workbook" option in the dialog that pops up. This only applies to the specific workbook you're saving. But, that would be enough to get the pop up to stop showing up every time you go to save the file. You can at least work on one file in piece. I looked for this same option for .csv files but didn't find anything in the same vein.

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. But hey, might be worth checking out.

You can work in the .xlsx format to avoid the warning message and when you're done just "Save as" in .csv or .xls format - this way you'll see the pop-up just once. Hope that helps.