Strange File Error Using 2007

**erock24** · 09-27-2010, 08:51 PM

I created a spreadsheet that contains macros that read a .csv file. I sort the data and create pivot tables and do other stuff. I built it using 2003. Everything in the file works as expected even in 2007, but i get a strange error message when i open it in 07 saying it needs to recover data. Is there a fix for this?? I attached a version of my sheet.

**mdbdesign** · 09-27-2010, 09:28 PM

This is error info I get when try to open it.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error057880_01.xml</logFileName><summary>Errors were detected in file 'C:\DOCUME~1\Marek\LOCALS~1\Temp\MasterBudget - test.xlsm'</summary><removedRecords summary="Following is a list of removed records:"><removedRecord>Removed Records: Sorting from /xl/worksheets/sheet3.xml part</removedRecord></removedRecords></recoveryLog>

and see print screen

**erock24** · 09-28-2010, 12:15 AM

yeah that's it...What does it mean? How do i get rid of it? Why does it not happen with 2003?

**erock24** · 09-28-2010, 04:57 PM

Incredibly i was able to fix this problem. I got clues from this thread: http://www.mrexcel.com/forum/newrepl...te=1&p=2457555

Turns out the problem was due to some sorting vba i was using. Not sure why but I fixed the problem by changing the sub routine code found in the "UtilityMod" module. I changed it from:

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.

I got the idea that maybe the code was passing a duplicate key from reading older posts at that link on page 3. Once I changed the code, ran the red button, and saved the workbook the error went away. Interestingly enough, I tried it without doing the if statement, only setting the sortKey variables and passing those into the sort method i was using originally, but that didn't work. For what ever reason it need the if statement.