How can we help you today? How can we help you today?

Open in Excel is not working

Hi,

When I try to open query results in Excel from SSMS, Excel does not open.

Could you please help me troubleshoot this issue?

Environment:

  • SQL Server Management Studio: 22.8.0+140.12009.203
  • SQL Prompt: 11.4.1.25856
  • Microsoft Office: Fully updated

There are no error messages displayed; Excel simply does not open when I select the option to open the results in Excel from SSMS.

Thank you for your assistance.

Kind regards,
Lucille Jensen

lbj
0

Comments

3 comments

Sort by
  • Ellie Shetabi
    Official comment

    Hi Lucille, 

    Thanks for reaching out to Redgate Support. Sorry to hear you're having some trouble getting your query results to open in Excel. 

    I've tested this on my own machine, with the same versions of both Prompt and SSMS and the query results opened successfully. So it looks like this might be something specific to your setup. 

    A common cause of this is Excel no longer being the default program for the relevant file type. If another app has taken over that file association, SSMS's request to open Excel could be getting silently redirected or ignored. Could you check:

    1. Right-click a .xlsx or .csv  file on your machine
    2. Choose "Open with" > "Choose another app"
    3. Confirm Excel is set as the default

    Let us know if that resolves it, or if it's still not opening, we can dig further.

    Ellie Shetabi
  • lbj

    Hi Ellie,

    Thanks for getting back to me.

    I followed your suggestion, and it resolved the issue.

    Many thanks for your help!

    Kind regards,
    Lucille Jensen

    lbj
    0
  • Ellie Shetabi

    No problem, I'm glad that resolved the issue for you! 

    If there is ever anything else we can help with, just let us know! 

    Ellie Shetabi
    0

Add comment

Please sign in to leave a comment.