Use ExcelLink 3.7.1 with Mathematica 12.0 ?

Questions
, ,
1

Hi guys,

do you know about a workaround to use ExcelLink 3.7.1 with Mathematica 12.0 ?

Thanks

2

What issues are you seeing? If you have error messages, can you post them here?

A recent Windows update had a defect which affected ExcelLink (August 13, 2019—KB4511553 (OS Build 17763.678) | Microsoft Support), and it is possible you’re running into that issue. It is my understanding that Microsoft is going to release a patched update in the very near future (if they have not already).

For further troubleshooting, I would recommend contacting Wolfram Technical Support (support@wolfram.com) as they’re best equipped to assist here.

3

Thanks, now i try to install again Mathematica 11.3.1 and test if I have the same problem with ExcelLink 3.7.1

If the problem is the same , than it is a Microsoft patch problem.

4

Ok I know now that also Mathematica 11.3.1 and ExcelLink 3.7.1 is not working .
So the problem is in Windows patches !!!
Great , all my trading spreadsheets blocked !

Capture.PNG
Capture.PNG816×336 13.9 KB

5

Ok Martin I resolved removing the Windows kb4511553, now both MA 11.3.1 and MA 12.0 is working with ExcelLink 3.7

6

Glad to hear the issue is resolved. Thanks for posting this, hopefully any others who run into the issue will see this post and be able to address things similarly.

7

I have used the following powershell commands to stop auto update in Windows 10 :

> New-Item -Path HKLM:\Software\Policies\Microsoft\Windows -Name WindowsUpdate -Force
> New-Item -Path HKLM:\Software\Policies\Microsoft\Windows\WindowsUpdate -Name AU -Force
> Set-Itemproperty -Path HKLM:\Software\Policies\Microsoft\Windows\WindowsUpdate\AU -Name NoAutoUpdate -Value 1 -Type DWord

Now restart the computer

> shutdown -r -t 05

But is not working , Windows 10 always install kb4511553 , blocking ExcelLink communications with Mathematica 12.0

8

The root cause of the issue is the recent Windows 2019-08 Cumulative Update, as warned by Microsoft under “Known issues in this update” section specific updates for each system listed below:

  • RS1 - Windows 10 1607 and Windows Server 2016 - KB4512517
  • RS2 - Windows 10 Version 1703 - KB4512507
  • RS3 - Windows 10 Version 1709 - KB4512516
  • RS4 - Windows 10 version 1803 or Windows Server Version 1803 - KB4512501
  • RS5 – Windows 10 version 1809 - KB4511553
  • 19H1 (1903) – Windows 10, version 1903 - KB4512508
  • TH1 (1507/RTM) - KB4512497
  • Monthly Rollup Win 8.1 and Win Server 2012 R2 - KB4512488
  • Sec. Only Win 8.1 and Win Server 2012 R2 - KB4512489
  • Monthly Rollup Win Server 2012 & Windows Embedded 8 Standard - KB4512518
  • Sec. Only Win Server 2012 & Windows Embedded 8 Standard - KB4512482
  • Monthly Rollup Win 7 SP1 and Win Server 2008 R2 SP1 - KB4512506
  • Sec. Only Win 7 SP1 and Win Server 2008 R2 SP1 - KB4512486
  • Monthly Rollup Win Server 2008 SP2 - KB4512476
  • Sec. Only Win Server 2008 SP2 - KB4512491

These updates resulted in “applications that were made using Visual Basic 6 (VB6), macros using Visual Basic for Applications (VBA), and scripts or apps using Visual Basic Scripting Edition (VBScript) … [to] stop responding and … [possibly receiving] ‘invalid procedure call error.’”
To resolve the issue, please install the corresponding updates that Microsoft rolled out to address this particular issue (and possibly other issues), listed below:

  • RS1 - Windows 10 1607 and Windows Server 2016 - KB4512495
  • RS2 - Windows 10 Version 1703 - KB4512474
  • RS3 - Windows 10 Version 1709 - KB4512494
  • RS4 - Windows 10 version 1803 or Windows Server Version 1803 - KB4512509
  • RS5 – Windows 10 version 1809 - KB4512534
  • 19H1 (1903) – Windows 10, version 1903 - KB4512941
  • TH1 (1507/RTM) - KB4517276
  • Monthly Rollup Win 8.1 and Win Server 2012 R2 - KB4517298
  • Sec. Only Win 8.1 and Win Server 2012 R2 -KB4517298
  • Monthly Rollup Win Server 2012 & Windows Embedded 8 Standard - KB4517302
  • Sec. Only Win Server 2012 & Windows Embedded 8 Standard - KB4517302
  • Monthly Rollup Win 7 SP1 and Win Server 2008 R2 SP1 - KB4517297
  • Sec. Only Win 7 SP1 and Win Server 2008 R2 SP1 - KB4517297
  • Monthly Rollup Win Server 2008 SP2 - KB4517301
  • Sec. Only Win Server 2008 SP2 - KB4517301

Please refer to the following article to check your Windows edition (7, 8, 10, etc.) and version (1607, 1803, 1903, etc.) before downloading and installing the proper update:

https://support.microsoft.com/en-us/help/13443/windows-which-version-am-i-running

9

Thanks very much ,
RS5 – Windows 10 version 1809 - KB4512534 resolved the problem .