Problem with opening the Excel spreadsheets

Question

I can not create an Excel 2007 file(xlsx) that will open without excel telling me that there is unreadable content in the workbook and that it needs to be repaired. 

If I say yes to repair, the file is opened with another dialog with the message

Removed Records: Cell information from /xl/worksheets/sheet1.xml part 

The contents from the log file  are as follows

  <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

• <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

  <logFileName>error062080_01.xml</logFileName>

  <summary>Errors were detected in file 'E:\IMReports\MyTest.xlsx'</summary>

• <removedRecords summary="Following is a list of removed records:">

  <removedRecord>Removed Records: Cell information from /xl/worksheets/sheet1.xml part</removedRecord>

  </removedRecords>

•  </recoveryLog>

Please help me as to how I can narrow down the problem. With this log, I am not sure what cell is in error. Thanks in advance.

Answer 1

How large are the spread sheets that will not open? 

Do you have time machine backups where you can retrieve a version before the - won't open?

Also, in utilities menu, console - check the logs for any error messages

Or try use EXCEL Repair Kit. A Microsoft Excel repair tool for corrupted Excel spreadsheets. Program open, read and save data from damaged Excel files. Info: http://www.excel.repair/

Answer 2

1. Please try to repair your Office as a quick fix.

http://office.microsoft.com/en-gb/excel-help/repair-office-programs-HA010357402.aspx

2. Please look into C:\Users\User_Name\AppData\Roaming\Microsoft\Excel (replace user name with your user name) and see if is contains few files / folders. Move those files to some other location (i.e create a backup of those files / folders and delete all files / folders from here). Hence, make Excel folder blank.

Now open the file and see if the problem disappears or not. 

Note - to find Excel path, you need to find XLSTART path. Excel folder contains XLSTART folder in itself.

1. Open Excel
2. ALT+F11
3. If Immediate Window is not visible, type CTRL+G. Same can be also be accessed through View > Immediate Window
4. Type "? application.StartupPath" without quotes and press enter
5. You will have your path below.