We're on a Excel 2013 on windows 7 x64

When double clicking an excel file from desktop/my documents or opening an excel file from outlook, the file is blank but it does contain data when printed. The only way for us to make the data show is by going to View->Arrange All->Tiled the data will show but if you close and reopen again it's blanked again, we have over over 200 spreadsheets like that. How can we fix it?

Tried doing the online repair and still does not solve the problem. All Add-ins are disabled. Unhide feature is also greyed out.

Please help.

Thank you.

• Edited by 1GodSpeed Monday, March 02, 2015 11:15 PM

have you tried repair? very similar.

https://social.technet.microsoft.com/Forums/office/en-US/bddcd1a3-9be7-4658-8df2-43b9bfba3581/when-we-opening-the-msexcel-2013it-is-not-opening-and-showing-blank-screen-and-the-contents-are?forum=outlook

Hello,

Thanks for the reply. I did read that post but the repair did not solve it.

Hi, Please let us know what was the original Office version of those excel files. Excel 2010, Excel 2007 or even Excel 2003. Did you try to open and convert into Excel 2013 Format? Do you have the same issue if you create a new Excel 2013 file, save it, close it and reopen it?

Hello Thanks for your reply,

Original office 2013 Home and Business. If we create from a new document and save and reopen it's fine, it's just the original documents that was created before or emailed that was save in 97-2003 format

• Edited by 1GodSpeed Tuesday, March 03, 2015 3:04 PM

Hi,

From your description, this issue may be caused by the compatibility issue between Office 2013 and Office 97-2003 format. Thus, I recommend you convert the file to Excel 2013 format.

Steps: To convert the document without saving a copy, click Info, and then click Convert.

Regards,

George Zhao
TechNet Community Support

Hi George, Before we never had a problem, and when we open excel attachments in outlook, it's also blank.

Hi,

I suppose this issue may be caused by the DDE option. Please try to turn off it to test:

1.Click the File tab, and then click Options.
2.Click Advanced, scroll down to the General section, and then clear the Ignore other applications that use Dynamic Data Exchange (DDE) check box in the General area.
3.Click OK.

Regards,

George Zhao
TechNet Community Support

I did try that, but did not fix it.