Problem working with Excel 2007

Jan 3, 2013 at 1:45 PM
Edited Jan 3, 2013 at 1:49 PM

Hi all, I have problem with edit the xlsx file.

I used an xlsx file as template to create a new excel file => it worked fine

If I just open and view the new file without save it => I can update to that file and still worked fine

If I open the new file and save it (edit or not) => I still can update to that file but when open the updated file, excel throw 1 error: 'Excel found unreadable content in 'filename.xlsx'. Do you want to recover the content of this workbook? If you trust the source of this workbook, click Yes '

Anyone have idea about this behavior?

Jan 31, 2013 at 3:28 AM
Hi all, I am also facing the similar problem with xls format.

While exporting excel file am adding a HSSFDataValidation. Its a dropdownlist for one column in sheet1 and the values are generated in sheet2.

For example - States.xls contains country code column as dropdownlist in sheet1 and sheet2 contains the country code list . Till now its working fine.

If i do any modifications to the excel file and save it am getting a message "Compatibility Report for sates.xls".

The message says :- "Significant loss of functionality" - One or more cells in this workbook contain data validation rules which refer to values on other worksheets. These data validation rules will not be saved.

Can some one please help me how to overcome this issue.
Sep 29, 2016 at 1:09 PM
Edited Sep 29, 2016 at 1:17 PM
Please ignore: Posted to incorrect thread.