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

"Open in Excel" slower in 11.4.1

I use the “Open in Excel” feature in Excel frequently and have noticed that it seems to be much slower in recent releases of SQL Prompt.

Anyone else notice this change? Is there an explanation for why it's slower?

Thanks,
James

James Sun
0

Comments

5 comments

Sort by
  • Christian Perez
    Official comment

    Good Morning James,

     

    Thanks for reaching out to Redgate Support, sorry to hear you are having some performance issues with SQL Prompts Open in Excel Feature. I am likely going to have to reproduce this locally if we are to have this remediated and I have not been able to reproduce the behavior just yet. If you wouldn't mind, what version of OS/SSMS/SQL Prompt are you utilizing so I can investigate?

    Christian Perez
  • petervandenbeemt

    In version 11.5 Open In Excel gives an unexpected error.

    petervandenbeemt
    0
  • James Sun

    I also ran into the same issue with the latest version of SQL Prompt. Uninstalling the latest version and reinstalling 11.4.2 brought the “Open in Excel” functionality back…

    James Sun
    0
  • James Sun

    The latest SQL Prompt release – 11.5.1.26824 – does fix the error being thrown by “Open in Excel” functionality. Thanks Redgate!

    James Sun
    0
  • James Sun

    FWIW, the speed at which the Excel workbook is generated and opens on my Windows 10 desktop is back to normal now.

    James Sun
    0

Add comment

Please sign in to leave a comment.