In SSRS2005 an excel export (subscription report) opened fine on a WM6 PDA and iPhone.
Since we upgraded to SSRS2008R2, it no longer opens.
"Unable to read document. The file format is invalid".
The same XLS can be opened in Excel 2007.
And when the XLS is opened in Excel 2007, saved, and then resent as an email attachment, the modified XLS will open fine on the WM6 PDA and iPhone.
I've produced a very simple RDL (iPhoneExcelIssue.rdl), deployed to SSRS 2008 R2, and exported to XLS and attached (iPhoneExcelIssue - Unopened - UnReadable in iPhone.xls).
This example fails to open in iPhone, or other smartphone.
Yet when opened in Excel 2007, and saved (iPhoneExcelIssue - Opened and Readable.xls) again, then this saved file can be emailed and viewed on any smartphone.
If the ORIGINAL version was produced like the SAVED version, then all would be well.