We have an Excel xlsx file that opens fine in Office 2007 but when we open using Office 2010 x64 on Windows 7 Enterprise the worksheets are all blank.  All the sheets are there with their original names, but the cells contain no data.  I converted the extension to .zip and looked at the raw xml and the data is there.  If I save the file in 2010, then it saves it blank.  We then tried using 2007 to save the file in 97-2003 xls format.  That file opens fine in Excel 2010. 

Has anyone had a similar issue?

Hi,

 

 

See if repairing Office/Excel 2007 helps.

If not, you may try this program and register the Excel executable to the "Open With" listing.

Registering programs with the "Open With" dialog:

http://windowsxp.mvps.org/openwithadd.htm

 

 

Regards,

 

Harry Yuan

 

 

• Proposed as answer by Harry Yuan Monday, October 11, 2010 1:58 AM
• Marked as answer by Sally Tang Friday, October 15, 2010 8:03 AM

I had the same issue.  Repair/reinstall did not work.  I still believe this is a bug to fix but here's what I discovered to resolve.

In Excel 2010, go to the View tab.

Select the 'Arrange All' button, then choose to Cascade.

Once I pressed ok I was able to view the document completely and maximize, minimize, etc.  It didn't recur after that point.

Hope this helps.

   -Shawn

Yes. Thanks. Worked for me too (open, it's blank go to VIEW\ARRANGE ALL and select cascade). Weird. It only happens on one particular file occaisionally.

• Edited by Scott2030 Wednesday, March 21, 2012 4:27 PM

Blessings on you.  Worked perfectly.  God, that was a scary problem.

Good job guys. It worked for me too

SF