Export to excel unexpected error! last version Windows 11

JonathanRiv

Hi,
I just update to the last versión 10.14.9.7331 and i cant export to excel; is just 117 rows, i cant export anything.

rwilliams

I have this problem too. Is it specific to this SQL Prompt version or is there a Windows 11 or Excel setting that needs adjusting?

Tinny

I am also experiencing this issue since upgrading to 10.14.9.7331, am running SSMS

SQL Server Management Studio 15.0.18424.0

SQL Server Management Objects (SMO) 16.100.47021.0+7eef34a564af48c5b0cf0d617a65fd77f06c3eb1

Microsoft Analysis Services Client Tools 15.0.19750.0

Microsoft Data Access Components (MDAC) 10.0.22000.2777

Microsoft MSXML 3.0 4.0 6.0 

Microsoft .NET Framework 4.0.30319.42000

Operating System 10.0.22000

Victoria W

Hi @JonathanRiv, @rwilliams, @Tinny

I'm afraid this is an issue our developers are now aware of and working on but have not yet released a fix. 
 
For the time being, please downgrade to 10.14.8.
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.8.6563.exe 

I'll update this post when we have a new release.

NathanSundararajan

I couldn't install the 
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.8.6563.exe 

It says I'm running latest version. I'm still getting the error.

MSpackman

@NathanSundararajan I have the same issue in Windows 10.  I had to uninstall the existing version before installing 10.14.8

DROP_TABLE_Students

It appears the issue is resolved in 10.14.10.7538.

https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.10.7538.exe

Victoria W

Hi @JonathanRiv, @rwilliams, @Tinny, @DROP_TABLE_Students, @NathanSundararajan

Yes, this issue has been fixed in the latest version:

https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.10.7538.exe

Tinny

NathanSundararajan said:

I couldn't install the 
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.8.6563.exe 

It says I'm running latest version. I'm still getting the error.

Hi @NathanSundararajan

You need to uninstall the 14.9 and then install 14.8

Tinny