sql prompt export to excel feature missing

apanang1

I just update the SQL prompt to the latest version and noticed that the "Export to Excel" feature is missing when I click the result pane of SQL mgnt studio.

rwilliams

Same here. The latest version 9.5.9.10716 installed today appears to have broken this and we use Export to Excel a LOT.

SQLMickey

I'm missing the same one, plus the other menu items that go along with it. 

Worksucks

Drats, me too.  Missing the 'Export to Excel', 'Copy as In' ....

redeyedrum

Add me to the list. SSMS 18.1 (15.0.18131.0), Sql Prompt 9.5.9.10716. 

ca6dsm

same here SSMS 18.1 (15.0.18131.0), Sql Prompt 9.5.9.10716. 

Okie

Ditto. SSMS 12 (11.0.7001.0), Sql Prompt 9.5.9.10716.

CasAl0

 I updated the SQL prompt to the latest version this morning (from Italy) and all the features available with the right click on the result pane is missing! Please, please please do something to correct the issue! 

CasAl0

Sorry but the snippets don't work anymore ... you absolutely have to do something as soon as possible, please!

TomL

same here

pbxx

Same here... how to revert back to the previous version?

Richard_Lindblom

I agree how can we roll back to a prior version where export to Excel worked?

TomL

I've never tried it, but I think you can just install the previous version -> https://www.red-gate.com/downgrade
I will just wait for a fix (if it's not taking them too long)

Worksucks

Fixed in today's release!  9.5.10.10741 - 11th July 2019

Thanks!

apanang1

I tried that (install from the bundle download) and it didn't work.
I was able to solve the issue by doing this
1) Close SQL Mgmnt Studio
2) Uninstall SQL Prompt 
3) Download and install previous version of SQL Prompt from 
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_9.5.8.10521.exe

Good luck

apanang1

I tried that (install from the bundle download) and it didn't work.
I was able to solve the issue by doing this
1) Close SQL Mgmnt Studio
2) Uninstall SQL Prompt 
3) Download and install previous version of SQL Prompt from 
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_9.5.8.10521.exe

Good luck

AdrianB

This issue was fixed in SQL Prompt v9.5.10.10741, released on 11th July 2019. If you are still having issues with the Export to Excel feature not working, please contact support.