To disable compatibility warnings follow these steps...
Using Excel(2010)
Go on the 'File' tab
Click on 'Info' from menu options
Now click on 'Check for Issues'
Now click on 'Check Compatibility'
Now clear the check 'Compatibility when you save this Workbook' box

Using Excel(2007)
Go on the 'Office' button
Now click on 'Prepare' from the menu
Now click on 'Run Compatibility Checker'
Now clear the check 'Compatibility when you save this Workbook' box

You can also control Compatibility Checker with VBA code as like this...
Make it turn off: ActiveWorkbook.CheckCompatibility = False
Make it turn on: ActiveWorkbook.CheckCompatibility = True
Where ActiveWorkbook is name of your current file.