How is SQL Prompt helping your team? Share your experience.

Open in Excel result in error

sjobrfsjobrf Posts: 2 New member
When "Open in Excel" from SSMS. I get this error (see attachment Err_01)

The recovery log says:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<logFileName>error172600_01.xml</logFileName>
<summary>Errors were detected in file 'C:\Users\jb6095\AppData\Local\Temp\rut1mgpk.na1\Exported results 2022-11-30_09-26-25.xlsx'</summary>
<repairedParts>
<repairedPart>Repaired Part: /xl/worksheets/sheet1.xml part with XML error.  HRESULT 0x8000ffff Line 1, column 0.</repairedPart>
</repairedParts>
</recoveryLog>

The resulting error (see attachment Err_02)

The generated Excel file.

Please find a solution fast.

Comments

Sign In or Register to comment.