Error opening xlsx (1.74) files in Excel 2007 12.0.6425.1000

Topics: Developer Forum
Oct 8, 2010 at 12:10 AM

Hello,

I recently updated a project to use PHPExcel 1.74

Now one of the people that frequently runs reports created with PHPExcel can't open files.

I can open the files using OpenOffice Calc 3.21, another computer using Excel 2007 ver 12.0.6535.5002 can open the files.

But, this one person, using Excel 2007, 12.0.6425.1000.

The error message is:

Excel found unreadable content in 'filename.xlsx'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.

Click no and nothing happens. Click Yes and the error message is:

Excel cannot open the file 'filename.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

Jay

Coordinator
Oct 11, 2010 at 8:52 PM

If the discrepancy is between different builds of Excel, it's going to be extremely difficult to track down this problem without further information. I don't know if a copy of the resulting workbook would help, or if Excel can generate any additional detail to help identify what markup it believes to be invalid.