Open in Excel crashing

Comments

• Options

  DROP_TABLE_Students Posts: 48 Silver 1

  February 29, 2024 10:27PM

  Same behavior here, version 10.14.9.7331

  0 · Share on Twitter
• Options

  TinuS Posts: 9 New member

  March 7, 2024 9:57AM

  Same behavior here, version 10.14.9.7331
  

  0 · Share on Twitter
• Options

  John_Salmon Posts: 1 New member

  March 8, 2024 4:51PM

  Same behavior here, version 10.14.9.7331
  

  0 · Share on Twitter
• Options

  Steinbacher Posts: 1 New member

  March 12, 2024 7:02AM

  Same, Version 10.14.9.7331
  
  

  0 · Share on Twitter
• Options

  miec_cb Posts: 3 New member

  March 12, 2024 6:05PM

  Where can we download the previous build? I can't wait for the next release to fix this issue. The "Copy with Headers" option is not a suitable workaround as it copies the literal "NULL" into the cells when there are null values.

  0 · Share on Twitter
• Options

  DROP_TABLE_Students Posts: 48 Silver 1

  March 12, 2024 6:10PM

  miec_cb said:

  Where can we download the previous build? I can't wait for the next release to fix this issue. The "Copy with Headers" option is not a suitable workaround as it copies the literal "NULL" into the cells when there are null values.

  https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.8.6563.exe
  

  1 · Share on Twitter
• Options

  miec_cb Posts: 3 New member

  March 12, 2024 6:25PM

  DROP_TABLE_Students said:

  miec_cb said:

  Where can we download the previous build? I can't wait for the next release to fix this issue. The "Copy with Headers" option is not a suitable workaround as it copies the literal "NULL" into the cells when there are null values.

  https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.8.6563.exe
  

  Thanks! This old version works just fine.

  1 · Share on Twitter
• Options

  jsreynolds1 Posts: 82 Silver 1

  March 12, 2024 11:45PM

  Add myself to the chorus of me too; same behavior, same version.

  0 · Share on Twitter
• Options

  RKennedy Posts: 2 New member

  March 13, 2024 2:19PM

  Same issue and it won't let me install the previous version, just says newer version installed.

  0 · Share on Twitter
• Options

  jsreynolds1 Posts: 82 Silver 1

  March 13, 2024 4:08PM

  @RKennedy just uninstall current version, install older. I did that, nothing lost, excel issue solved.
  

  0 · Share on Twitter
• Options

  Victoria W Redgate › Posts: 341 Gold 2

  March 14, 2024 12:59PM

  Hi all
  
  This is a known bug at the moment. Whilst the development team work on a fix, the work around is to downgrade SQL Prompt to V10.14.8
   
  Sorry for the inconvenience, we hope to have an update soon. 
  

  Kind regards
  
  Victoria Wiseman | Redgate Software
  Have you visited our Help Center?

  0 · Share on Twitter
• Options

  DROP_TABLE_Students Posts: 48 Silver 1

  March 14, 2024 8:36PM

  It appears the issue is resolved in 10.14.10.7538.
  
  https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.10.7538.exe
  

  1 · Share on Twitter
• Options

  Teknologist Posts: 2 Bronze 1

  March 27, 2024 9:05AM

  DROP_TABLE_Students said:

  It appears the issue is resolved in 10.14.10.7538.
  
  https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.10.7538.exe
  

  This worked for me, thank you!

  0 · Share on Twitter
• Options

  RKennedy Posts: 2 New member

  March 27, 2024 2:19PM

  While the update fixed the open in Excel issue, my SSMS now consistently crashes when connecting to another server and drilling down through Object Explorer

  0 · Share on Twitter
• Options

  Ben_P Redgate › Posts: 224 Silver 2

  April 12, 2024 8:38AM

  To Confirm the export to excel feature was fixed in 10.14.10:
  
  

  10.14.10.7538 - Released on 14 March 2024

  Fixes

  • Fixed exporting results to excel format.
  • Fixed "Could not load file or assembly System.Memory" exception, occurring when using SqlPrompt.Format.CommandLine.exe from FormatCommandLine.zip.

  0 · Share on Twitter