Share via

Problem with opening the Excel spreadsheets

Anonymous
2015-07-16T15:22:23+00:00

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.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2015-07-18T14:14:50+00:00

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/

Was this answer helpful?

20+ people found this answer helpful.
0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2015-07-16T18:06:56+00:00
    1. Please try to repair your Office as a quick fix.

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

    1. 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.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments