I have a mhtml file about 160 MB size which has huge data (only table)~ >750,000 cells. When try opening in Excel application i am getting an error "unable to read a file".

Analysis from my side:

1. when I opened the same file in note pad and deleted 50% of rows, saved and tried to open using Excel application => it worked.

This means there is a restriction of data handled by excel application.

2.  The same file is opening in Working in Microsoft Office Professional Plus 2010 32 bit and not working in Microsoft Office Professional plus 2013 32 bit.

Can any help me understand the reason for this issue and help me resolving it?

Hi Pradeep,

Based on your description, I suppose this issue might be caused by any specific format in MHTML file which is unsupported in Excel 2013.

Your file size is very large, I suggest you try to test the other half of rows and reduce the scope of specific format in MHTML file. In this way to confirm the specific data unable to be read in Excel 2013.

Any update about your issue please let me know, I'm glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Su