Open in Excel result in error

Comments

• [email protected] Posts: 4 Bronze 1

  December 5, 2022 11:47AM

  Resently I also began to get this exact error.
  I have just updated SQL Prompt to 10.13, already have the newest SSMS 18.12.1, and Excel is 2016 64 bit 16.0.5369.
  And i still got the error.

  1 · Share on Twitter
• mikecare Posts: 17 Bronze 5

  December 5, 2022 2:55PM

  I get the same error.  Also when pasting into Excel.  it puts all data into the same column

  0 · Share on Twitter
• ATurner Redgate › Posts: 106 Bronze 4

  December 6, 2022 1:44PM

  Hi All
  
  This is currently a known issue and the development team are looking into this. 

  0 · Share on Twitter
• mrjeffjohnston Posts: 1 New member

  January 10, 2023 4:55PM

  Is there any update here?

  1 · Share on Twitter
• Sarah B Redgate › Posts: 115 Silver 2

  January 19, 2023 3:08PM

  I'm please to advise that a fix for this issue has been included in the latest release of SQL Prompt (v.10.13.4) 
   
  
  

  Sarah Beckett| Customer Support| Redgate Software

  Have you visited our Help Center? 

  0 · Share on Twitter
• sjobrf Posts: 2 New member

  January 19, 2023 3:26PM

  I have installed v.10.13.4 and try to open in excel.
  
  But I still get and error
  
  The message is:
  

  <?xml version="1.0" encoding="UTF-8" standalone="yes"?>

  <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

  <logFileName>error286760_01.xml</logFileName>

  <summary>Errors were detected in file 'C:\Users\xxxx\AppData\Local\Temp\een4du4m.bpk\Exported results 2023-01-19_16-18-56.xlsx'</summary>

  <repairedRecords>

  <repairedRecord>Repaired Records: Cell information from /xl/worksheets/sheet1.xml part</repairedRecord>

  </repairedRecords>

  </recoveryLog>

  
  So it the fix is not sufficient 

  0 · Share on Twitter