Group Abstract Group Abstract

Message Boards Message Boards

0
|
15.3K Views
|
8 Replies
|
2 Total Likes
View groups...
Share
Share this post:

Use ExcelLink 3.7.1 with Mathematica 12.0 ?

Posted 6 years ago

Hi guys,

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

Thanks

POSTED BY: Massimo Salese
8 Replies
Posted 6 years ago

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

POSTED BY: Mehrdad Ghods
Posted 6 years ago

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

POSTED BY: Massimo Salese
Posted 6 years ago

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 !

Attachment

Attachments:
POSTED BY: Massimo Salese
Posted 6 years ago

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.

POSTED BY: Massimo Salese
Posted 6 years ago

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 (https://support.microsoft.com/en-us/help/4511553/windows-10-update-kb4511553), 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.

POSTED BY: Kyle Martin
Posted 6 years ago

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

POSTED BY: Massimo Salese
Posted 6 years ago
POSTED BY: Kyle Martin
Posted 6 years ago

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

POSTED BY: Updating Name
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard