Export to Excel bug -- Excel says it needs to repair data
Since upgrading to latest version of SQL Prompt, I seem to be getting an error from Excel when I choose "Open in Excel". The XML recovery log looks like this:
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error09000001.xml</logFileName>
<summary>Errors were detected in file 'C:\Users\ned.bush\AppData\Local\Temp\raovxova.xw3\Exported results 2022-10-2509-18-50.xlsx'</summary>
<repairedParts>
<repairedPart>Repaired Part: /xl/worksheets/sheet1.xml part with XML error. HRESULT 0x8000ffff Line 1, column 0.</repairedPart>
</repairedParts>
</recoveryLog>
4
votes
![](https://secure.gravatar.com/avatar/4d58bfd8d0807324cdbca6bcb12c1f32?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)