Open in Excel dont works in the last version 10.13.0.31319

JonathanRiv

This is a report of 42 columns and 181575 rows. When i try to open in excel, its starts to write the results, but crash when it is in 99%.
The problem start when i update to this version, some days ago (with the earlier versión) it works normally.

JonathanRiv

When i open in excel in the version 7.5.1.100 it works perfect.

Victoria W

Hi @JonathanRiv

Please can you upgrade to the latest version of SQL Prompt and this should fix the issue:
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.13.0.31319.exe

JonathanRiv

Sorry, my bad, the versión with i have problems is the last 10.13.0.31319

dkim1999

Hi Jonathan, 

Thank you for the update.

Is there an error message that pops up after it crashes or does it just crash.

Kind Regards,
David K.
Product Support Engineer

JonathanRiv

There is no error to show, just stop in 99% and dont open de Excel sheet.
I tried to export a quarter, a half and dont works.

plolis

do we have any news abou this? thank you

dkim1999

Hi Jonathan,

I apologize for the delay in response.

This seems to be a known issue by the developers and they are currently taking a look at it.

I do not currently have a time-frame of when this issue will be fixed, but I can update this forum post once a fix is released.

Kind Regards,

David K.

Product Support Engineer

PaulManaugh

Hi all,
I'm having an open in Excel problem with version 10.13.0.31417.  The error message is: "We found a problem with some content in 'Exported Result...xlsx".  Do you want us to try to recover as much as we can?  If you trust the source of this workbook, click Yes."  I'm not sure if this is the same error that others have reported.

JonathanRiv

Hi Paul, is not the same error, but i got this one some times. Have you tried using an older stable versión?, for example the versión 7.5.1.100 works perfect for me when i have to export to excel.

mirco

I encountered exactly the same problem with version 10.13.3 as described by @JonathanRiv
I also tried 10.12.6.30951 but it was showing the same symptoms.

Finally, I have downgraded SQL prompt to 10.11.12.27800 and it seems to work OK.