Hi, I have a file which on opening manually gives alert that "the file is in diff format than specified by the file extention". What i do is, i try to load this file by specifying EXCEL_97_TO_2003 as FileFormatType. Here it gives exception. So in the catch block i reload the file wihout specifying the LoadOptions. With this i am able to get the workbook object. I call save on this workbook object, this time specifying the FileFormatType as EXCEL_97_TO_2003. With all these the file is saved properly but the only thing is that all the dates in the file loose its format. Originally they have the format as custom mmm, dd yyyy while after saving the format becomes general. I cannot post the file. Without file can you help me out of this?