SQL Prompt Open in Excel not working anymore

Alberto

I consistently get an exception whenever trying to "Open in Excel" any resultset.

I'm using SQL Prompt 10.6.9.10437 with SQL Server Management Studio 18.9.1 on Windows 10 build 19042.964, and no further updates are available to any of these.

Ben_P

Hi Alberto,

Thank you for your post. 

I believe a fix was released in v10.6.10 that addressed this issue with opening results in Excel. Here is a link to the release notes: 

https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-6-release-notes

Additionally here is a link to the update: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.6.10.19533.exe

 

Alberto

Hi Ben,

thank you all for the quick fix. I can confirm that with version 10.6.10 the "Open in Excel" functionality is now working again.

Regards,

Alberto