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

Open in Excel causes Excel to hang

Hi All,

I recently installed the latest version of Sql Prompt. I noticed that when I use Open In Excel, it prompts me to enter my Office 365 acccount info and when that occurs, Excel just hangs. I haev no recourse but to use Task Manager to kill it. At this point, the Open in Excel function is unuseable. I am using Sql prompt 10.12.5.3 on Win 10 on SSMS 18.12.1.  Thoughts?

Regards
VR
VRajagopal
0

Comments

2 comments

Sort by
  • DustinM
    Hello,

    Thank you for your inquiry into SQL Prompt.

    Regarding excel crashing I was, unfortunately, unable to replicate this on my end using the same versions of Prompt, SSMS, and windows 10.

    Does Excel perform normally outside of attempting to open in SQL Prompt? I have also provided the Microsoft documentation for excel being unresponsive just in case.

    https://support.microsoft.com/en-us/office/excel-not-responding-hangs-freezes-or-stops-working-37e7d3c9-9e84-40bf-a805-4ca6853a1ff4

    Best,

    Dustin
    DustinM
    0
  • VRajagopal
    So this continues to happen in Sql Prompt 10.13 and SSMS 19. So when I used the "Open in Excel", the dataset opens in Excel but then I get a prompt asking me to activate office. The thing is we are using an Enterpise license for Excel but if I ever oepn in Excel from SQL Prompt, I am always asked to activate. When I sign in to activate with my credentials - it just hangs . I have to use Task Manager to kill it. Any thoughts?
    VRajagopal
    0

Add comment

Please sign in to leave a comment.