Compatibility Checker in Excel 2007-2013

[Abhijeet]

Hi

I have .xls & .xlsx files when i open .xls file in Excel 2010 then show
Compatibility Checker message box i want to avoid this every file pls tell me any option for this
Plesae tell me how to do this

 

[Chihiro]

Easiest method is to save file as and save in .xlsx format.

Other than that, you can follow direction given on the link.
http://www.aspose.com/docs/display/cellsnet/Disable+Compatibility+Checker+in+Excel

 

[Marc L]

Hi !​

Compatibility Checker message box i want to avoid this every file pls tell me any option for this
Plesae tell me how to do this

Just do not open xls file ‼
​

 

[vletm]

Have You (@Abhijeet) tried this option; uncheck

 

[Abhijeet]

I have macro macro open the files when this message pop up then macro stop when i click on this message then macro pull next file i want to avoid this so please tell me is any method to disable this message

 

[Chihiro]

Then try one of the code below. Or both.

ThisWorkBook.DoNotPromptForConvert = true

workbook.CheckCompatibility = false

 

[vletm]

If Reply #6 didn't help, send Your Macro.