Options
Open in Excel - Open Excel in a different User then the SSMS is open with
SHLiberatore
Posts: 1 New member
in SQL Prompt
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.
Tagged:
Answers
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!
Tianjiao Li | Redgate Software
Have you visited our Help Center?