Open in Excel - Open Excel in a different User then the SSMS is open with

SHLiberatore

I have to open SSMS with an elevated privilege account in order to connect to the Databases, so when I use the "Open in Excel" feature, it opens Excel with the elevated privileges account which is not licensed for Excel, so then I have to save it and reopen the excel file with my regular account. Is there a method to change the account that the "Open in Excel" uses to open Excel.

Tianjiao_Li

Hi @SHLiberatore

I'm sorry it's not possible to change the account that the 'Open in Excel' uses at the moment. Our apologies for the inconvenience this has caused. 

It would be very helpful if you could create a feature request for it on our user voice forum https://redgate.uservoice.com/forums/94413-sql-prompt 

Thanks!