iphone wont open xls email attachment

I need to be able to open .xls email attachments on my iphone 3GS from a major customer which i receive regularly but get the following error:*This document can't be viewed. An error occured while reading the document.*I can open the same .xls file on my macbook pro using excel:mac2008 although i get a message first 'file error data may have been lost' which i just need to click ok and the file opens normally.I have tried downloading 'Quickoffice' to the iphone but makes no difference.My previous phone with windows mobile opened the same .xls attachement with no problem.I need to solve this, please can anyone help?

The .xls file is automatically exported from our customers order system and they cannot change it to RTF format. This is an order we receive every day from a major customer who wont change their setup for one small supplier.

Have whoever sends you that attachment send it to you, but make sure that their email itself is in plain text or html format, tell them not to use RTF(Rich Text Format). Again, no RTF. See if it will open that way.

Here's an idea, no guarantee it will work, but you may want to give it a try. Is there another computer/account, you can have the email sent to, from there have the email body converted to plain text then forwarded to the account you access on your iphone?

I ran into a similar problem. I have a vendor that embedds HTML data in an xls file and just hits save. Problem is that the iPhone viewer tries to open it as xls instead of html (and says invalid file format).

I opened the file in Excel 2003 (windows version gasp), then clicked on File > Save As and low and behold it's default was .html (indicating that is how it was saved orginally). I changed it to a normal Excel Workbook (.xls) saved, and re-emailed it and it worked fine. Also it works if I just change the file extension to .html.

So for whatever reason the iPhone viewer cannot handle an html page saved with an xls extension.

Since your sender will not change his ways, you could write some code to intercept the email, change the file extension, and resend it.

More Like This

Retrieving data ...

This site contains user submitted content, comments and opinions and is for informational purposes only.
Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums.
Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.