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 ?

Massimo Salese
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
Sort By:
Mehrdad Ghods
Mehrdad Ghods
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
Massimo Salese
Massimo Salese
Posted 6 years ago

Thanks very much , RS5 – Windows 10 version 1809 - KB4512534 resolved the problem .
POSTED BY: Massimo Salese
Massimo Salese
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:
Capture.PNG
POSTED BY: Massimo Salese
Massimo Salese
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
Kyle Martin
Kyle Martin, WOLFRAM
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
Massimo Salese
Massimo Salese
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
Kyle Martin
Kyle Martin, WOLFRAM
Posted 6 years ago

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.
POSTED BY: Kyle Martin
Updating Name
Updating Name
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.
Tag limit exceeded
Note: Only the first five people you tag will receive an email notification; the other tagged names will appear as links to their profiles.
Reply Preview
Attachments
Remove
or Discard