Unreadable content fix

[Oliver Dewar]

Hi All.

I have a workbook with many macros, userforms etc.

Occassionally, when I open the workbook I get the "this workbook contains unreadable content" warning. Excel then 'repairs' the workbook and it all works fine.

The odd thing is that the message of what's been fixed is always the same:

"Removed Records: Sorting from /xl/worksheets/sheet10.xml part"

Which tells me that excel is not really fixing the problem.

Also, the sheet (sheet10) that appears in the fixed error message (above) doesn't exist anymore, I deleted it after the first occurrance of the error.

How should I go about fixing this problem once and for all?

Thanks in advance.

 

[Anne Troy]

When I want to fix a workbook, I right-click a sheet tab, select all sheets and move them to a brand new workbook.

If you have code, you'll also have to copy and paste, or export and import.

That worked in older versions. Can't swear it does in newer, but it should certainly be worth a shot.