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

excel records vba
user2491612 picture user2491612 · Dec 13, 2013 · Viewed 88.3k times · Source

I'm almost sure I will have to create a new excel file, but maybe at least here I get some ideas what was the source of the problem.

My excel file is constantly giving the following error:

Excel found unreadable content in 'filename.xlsm'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.

So I do. And the file opens as repaired showing:

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

The detail is that I don't even have a sheet10

Its a big excel file full of custom-objects. But I have no DB connections or autofilter so could not relate to AutoFilter Criteria Using Array (Error) - Too Large String? or xlsx error: "Removed Records: Named range from /xl/workbook.xml part" when tried to resolve errors.

Anyone has a clue what's going on?

tks in advance

Answer

Chris picture Chris · Jan 31, 2014

try clearing the sort before saving down the workbook. When this happened to me I had my sheet references mixed up so the sort wasn't cleared

Sheets(yoursheetname).Sort.SortFields.Clear

Related questions

Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") …

Read More
'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

I'm trying to get data from an Excel file on a button click event. My connection string is: string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\source\\SiteCore65\\Individual-Data.xls;Extended Properties=Excel 8.0;"; When I click on the button, …

Read More