Sorting records VBA error

[Fwiz]

Hi all,

I'm having an issue when I process a complex macro, when it finished I save as normal, then close - when I open the file again I keep getting this error message: Removed Records: Sorting from /xl/worksheets/sheet13.xml part</removedRecord>

I can see it relates to worksheet 13, on that sheet I have a pivot table - how can I fix this and stop errors before i save the file?

any suggestions?

 

[rlv01]

Have a read though this.

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

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

stackoverflow.com

 

[Fluff]

Sheet13.xml is the 13th sheet in the workbook & has nothing to do with the sheet name or the sheet code name.
I suspect that you have a macro that uses Worksheet.Sort, in which case you need to change the code so that it clears all sort ranges, before adding the new ones.