Error on opening file - unreadable content

Hi,

I have a file which, when opening, is being recovered 'as much as we can' due to a problem with some of the content. The repairs log states that it was able to be opened by repairing or removing the unreadable content, which appeared to be an Object on Sheet9. I have completely deleted Sheet9 but I am still getting the same error message referring to this sheet when I save and re-open. It's driving me nuts!! Can anyone help please?

TIA,

Alan.

In addition, I have also tried Opening & Repairing but to no avail.

Not without seeing the document, if it does not contain sensitive data.

You're welcome. Thanks for the rep.

The only thing I can suggest is to copy the sheets in the corrupt workbook to a new workbook one at a time. Save, close and reopen the file after copying each worksheet.

If there are formulae linking sheets, you might need to copy more than one at a time. Can be messy but you should end up with a clean workbook.

You're welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.