none
Need help with a .NET framework error: Unhandled exception has occurred in a component in your application RRS feed

  • Question

  • Hello, I have been struggling with the following error when I am trying run an Excel workbook offloading job on my HPC cluster. I am on a Windows 2016 Server client machine and have got HPC Pack 2012 R2 installed (update3). I was previously able to run the job without any issues, but something seems to have gone off since then. Can someone please help me resolve this issue? Thanks in advance!

    ************** Exception Text **************
    Microsoft.Mashup.Host.Document.JavaScriptException: External component has thrown an exception. ---> System.Runtime.InteropServices.SEHException: External component has thrown an exception.
       at Microsoft.Mashup.Client.Excel.NativeExcelFunctionsC2R.Microsoft.Mashup.Client.Excel.INativeExcelFunctions.ShowOfficeFeedbackDialog(Boolean smile)
       at Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.SendAFrown(IWin32Window owner, IWin32Window screenshotWindow, IFeedbackInfo info, WindowsHost windowsHost)
       at Microsoft.Mashup.Client.ClientShared.Ux.FloatingDialog.SimpleDialog.ErrorDialog.SendAFrown()
       --- End of inner exception stack trace ---
    Error: External component has thrown an exception.
       at click (ms-pq://pq.microsoft.com/ts/FloatingDialog/SimpleDialog/ErrorDialog.js:30:17)
       at Anonymous function (ms-pq://pq.microsoft.com/ts/Shared/Button.js:23:21)
       at n.event.dispatch (ms-pq://pq.microsoft.com/OpenSource/jquery/jquery-2.1.1.js:3:6348)
       at r.handle (ms-pq://pq.microsoft.com/OpenSource/jquery/jquery-2.1.1.js:3:3114)


    ************** Loaded Assemblies **************
    mscorlib
        Assembly Version: 4.0.0.0
        Win32 Version: 4.6.1637.0 built by: NETFXREL3STAGE
        CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
    ----------------------------------------
    Microsoft.Mashup.Client.Excel
        Assembly Version: 1.0.0.0
        Win32 Version: 2.42.4611.241
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Mashup.Client.Excel.dll
    ----------------------------------------
    System.Core
        Assembly Version: 4.0.0.0
        Win32 Version: 4.6.1638.0 built by: NETFXREL3STAGE
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
    ----------------------------------------
    System
        Assembly Version: 4.0.0.0
        Win32 Version: 4.6.1637.0 built by: NETFXREL3STAGE
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    Microsoft.Mashup.Document
        Assembly Version: 1.0.0.0
        Win32 Version: 2.42.4611.241
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Mashup.Document.DLL
    ----------------------------------------
    System.Windows.Forms
        Assembly Version: 4.0.0.0
        Win32 Version: 4.6.1586.0 built by: NETFXREL2
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
    ----------------------------------------
    System.Drawing
        Assembly Version: 4.0.0.0
        Win32 Version: 4.6.1586.0 built by: NETFXREL2
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    ----------------------------------------
    Microsoft.Mashup.Client.Windows
        Assembly Version: 1.0.0.0
        Win32 Version: 2.42.4611.241
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Mashup.Client.Windows.DLL
    ----------------------------------------
    Microsoft.Mashup.Client.Models
        Assembly Version: 1.0.0.0
        Win32 Version: 2.42.4611.241
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Mashup.Client.Models.DLL
    ----------------------------------------
    Microsoft.MashupEngine
        Assembly Version: 1.0.0.0
        Win32 Version: 2.42.4611.241
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.MashupEngine.DLL
    ----------------------------------------
    Microsoft.Mashup.Shims
        Assembly Version: 1.0.0.0
        Win32 Version: 2.42.4611.241
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Mashup.Shims.DLL
    ----------------------------------------
    Microsoft.Mashup.EventSource
        Assembly Version: 1.0.0.0
        Win32 Version: 2.42.4611.241
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Mashup.EventSource.DLL
    ----------------------------------------
    Microsoft.Practices.Unity
        Assembly Version: 2.1.505.0
        Win32 Version: 2.1.505.2
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Practices.Unity.DLL
    ----------------------------------------
    Anonymously Hosted DynamicMethods Assembly
        Assembly Version: 0.0.0.0
        Win32 Version: 4.6.1637.0 built by: NETFXREL3STAGE
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll
    ----------------------------------------
    System.Web.Mvc
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.60926.0
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/System.Web.Mvc.DLL
    ----------------------------------------
    System.Web.Routing
        Assembly Version: 4.0.0.0
        Win32 Version: 4.6.1586.0
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Web.Routing/v4.0_4.0.0.0__31bf3856ad364e35/System.Web.Routing.dll
    ----------------------------------------
    System.Web
        Assembly Version: 4.0.0.0
        Win32 Version: 4.6.1637.0 built by: NETFXREL3STAGE
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Web/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.dll
    ----------------------------------------
    System.Configuration
        Assembly Version: 4.0.0.0
        Win32 Version: 4.6.1586.0 built by: NETFXREL2
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
    ----------------------------------------
    System.Xml
        Assembly Version: 4.0.0.0
        Win32 Version: 4.6.1586.0 built by: NETFXREL2
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
    ----------------------------------------
    System.Web.Extensions
        Assembly Version: 4.0.0.0
        Win32 Version: 4.6.1637.0
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Web.Extensions/v4.0_4.0.0.0__31bf3856ad364e35/System.Web.Extensions.dll
    ----------------------------------------
    Microsoft.Mashup.ProviderShared
        Assembly Version: 1.0.0.0
        Win32 Version: 2.42.4611.241
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Mashup.ProviderShared.DLL
    ----------------------------------------
    System.ServiceModel
        Assembly Version: 4.0.0.0
        Win32 Version: 4.6.1637.0 built by: NETFXREL3STAGE
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel/v4.0_4.0.0.0__b77a5c561934e089/System.ServiceModel.dll
    ----------------------------------------
    Microsoft.Mashup.OAuth
        Assembly Version: 1.0.0.0
        Win32 Version: 2.42.4611.241
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Mashup.OAuth.DLL
    ----------------------------------------
    WindowsBase
        Assembly Version: 4.0.0.0
        Win32 Version: 4.6.1638.0 built by: NETFXREL3STAGE
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/WindowsBase/v4.0_4.0.0.0__31bf3856ad364e35/WindowsBase.dll
    ----------------------------------------
    System.Runtime.Remoting
        Assembly Version: 4.0.0.0
        Win32 Version: 4.6.1586.0 built by: NETFXREL2
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Remoting/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
    ----------------------------------------
    Microsoft.Mashup.Client.Packaging
        Assembly Version: 1.0.0.0
        Win32 Version: 2.42.4611.241
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Mashup.Client.Packaging.DLL
    ----------------------------------------
    Microsoft.GeneratedCode
        Assembly Version: 1.0.0.0
        Win32 Version: 4.6.1586.0 built by: NETFXREL2
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
    ----------------------------------------
    System.Security
        Assembly Version: 4.0.0.0
        Win32 Version: 4.6.1586.0 built by: NETFXREL2
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Security/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Security.dll
    ----------------------------------------
    Microsoft.Mashup.Document.XmlSerializers
        Assembly Version: 1.0.0.0
        Win32 Version: 1.0.0.0
        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Root/Office16/ADDINS/Microsoft%20Power%20Query%20for%20Excel%20Integrated/bin/Microsoft.Mashup.Document.XmlSerializers.DLL
    ----------------------------------------
    Microsoft.Hpc.Excel
        Assembly Version: 2.0.0.0
        Win32 Version: 4.5.5161.0
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Hpc.Excel/v4.0_2.0.0.0__31bf3856ad364e35/Microsoft.Hpc.Excel.dll
    ----------------------------------------
    Microsoft.Hpc.Scheduler.Session
        Assembly Version: 2.0.0.0
        Win32 Version: 4.5.5161.0
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Hpc.Scheduler.Session/v4.0_2.0.0.0__31bf3856ad364e35/Microsoft.Hpc.Scheduler.Session.dll
    ----------------------------------------
    Microsoft.Office.Interop.Excel
        Assembly Version: 15.0.0.0
        Win32 Version: 15.0.4569.1506
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.Office.Interop.Excel/15.0.0.0__71e9bce111e9429c/Microsoft.Office.Interop.Excel.dll
    ----------------------------------------
    office
        Assembly Version: 15.0.0.0
        Win32 Version: 15.0.4613.1000
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/office/15.0.0.0__71e9bce111e9429c/office.dll
    ----------------------------------------
    Microsoft.Hpc.Excel.Internal
        Assembly Version: 4.0.0.0
        Win32 Version: 4.5.5079.0
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Hpc.Excel.Internal/v4.0_4.0.0.0__31bf3856ad364e35/Microsoft.Hpc.Excel.Internal.dll
    ----------------------------------------
    System.EnterpriseServices
        Assembly Version: 4.0.0.0
        Win32 Version: 4.6.1586.0 built by: NETFXREL2
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
    ----------------------------------------
    System.Data
        Assembly Version: 4.0.0.0
        Win32 Version: 4.6.1636.0 built by: NETFXREL3STAGE
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
    ----------------------------------------
    Microsoft.mshtml
        Assembly Version: 7.0.3300.0
        Win32 Version: 7.0.3300.0
        CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.mshtml/7.0.3300.0__b03f5f7f11d50a3a/Microsoft.mshtml.dll
    ----------------------------------------
    System.Web.Abstractions
        Assembly Version: 4.0.0.0
        Win32 Version: 4.6.1586.0
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Web.Abstractions/v4.0_4.0.0.0__31bf3856ad364e35/System.Web.Abstractions.dll
    ----------------------------------------

    ************** JIT Debugging **************
    To enable just-in-time (JIT) debugging, the .config file for this
    application or computer (machine.config) must have the
    jitDebugging value set in the system.windows.forms section.
    The application must also be compiled with debugging
    enabled.

    For example:

    <configuration>
        <system.windows.forms jitDebugging="true" />
    </configuration>

    When JIT debugging is enabled, any unhandled exception
    will be sent to the JIT debugger registered on the computer
    rather than be handled by this dialog box.


    Tuesday, August 22, 2017 1:02 AM

Answers

  • Thanks Yutong. I figured out the issue was caused because I had renamed the Sheet in VBA properties and for some reason (I don't have a slightest clue), it threw an error. I copied the contents of that sheet into a new sheet and deleted the old sheet, it worked fine after that. I even named the new sheet what I wanted!
    • Marked as answer by KMLN Wednesday, August 23, 2017 11:19 AM
    Wednesday, August 23, 2017 11:19 AM

All replies

  • Any thoughts anyone? I have no clue how to deal with this error, it started popping up out of nowhere. The macro was working fine before this and I don't remember changing anything in the macro, except my own calculations.
    Tuesday, August 22, 2017 8:43 AM
  • Hi KMLN,

    The error message and call stack seems not HPC Pack related. Where did you see this error? On the client or on the cluster? Did you see any error in the session job via HPC Cluster Manager? Or any error events in the event viewer?

    Regards,

    Yutong Sun

    Tuesday, August 22, 2017 8:56 AM
    Moderator
  • Thanks, Yutong. I see this on the client system, on Excel. I think the error happens before the job reaches HPC. On the status bar, I can see 'Starting calculation ...', but it neither sends nor receives any calculations.

    Just for background, I am on Windows 2016 Server (desktop edition, I suppose). It can see .NET framework 4.6 installed. I have Excel 2016 (as part of O365). The system is 2 vCPU, 7.5GB RAM, and 100GB.

    I have checked and I can run other macros normally, so it is not a problem with any Excel/VBA functionalities. A couple of screenshots attached.

    Error message as it appears on ExcelThis is the status message.

    This is the error code when I copied from the error window above:

    -----------------------------------

    Feedback Type:
    Frown (Error)

    Timestamp:
    2017-08-22T10:04:58.7462711Z

    Local Time:
    2017-08-22T11:04:58.7462711+01:00

    Product Version:
    2.42.4611.241 (PQ-CY17SU01) (x86)

    Release:
    January 2017

    Excel Version:
    16.0.7766.2099

    Excel Install Location:
    C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE

    IE Version:
    11.953.14393.0

    OS Version:
    Microsoft Windows NT 10.0.14393.0 (x64 en-US)

    CLR Version:
    4.6.2. or later [Release Number = 394802]

    Workbook Package Info:
    1* - en-GB, <g class="gr_ gr_523 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id="523" id="523">fastCombine</g>: Disabled.

    Peak Working Set:
    287 MB

    Private Memory:
    201 MB

    Peak Virtual Memory:
    1.05 GB

    Error Message:
    External component has thrown an exception.

    Error Code:
    -2147467259 (0x80004005)

    Stack Trace:
    System.Runtime.InteropServices.SEHException (0x80004005): External component has thrown an exception.
       at Microsoft.Mashup.Client.Excel.NativeExcelFunctionsC2R.Microsoft.Mashup.Client.Excel.INativeExcelFunctions.TryGetTaskPaneControl(NativeTaskPaneType type, IntPtr uiFrame, TaskPaneControl& taskPaneControl)
       at Microsoft.Mashup.Client.Excel.Shim.NativeTaskPaneServices.NativeTaskPane.get_ContentControl()
       at Microsoft.Mashup.Client.Excel.Shim.NativeTaskPaneServices.TryGetCustomTaskPane(TaskPaneType taskPaneType, ExcelWindowId excelWindowId, ITaskPane& taskPane)
       at Microsoft.Mashup.Client.Excel.CustomTaskPaneManager.TryGetCustomTaskPane(ExcelWindowId windowId, ITaskPane& taskPane)
       at Microsoft.Mashup.Client.Excel.CustomTaskPaneManager.TryGetTaskPaneControl[T](ExcelWindowId windowId, T& taskPaneControl)
       at Microsoft.Mashup.Client.Excel.CustomTaskPaneManager.OnWindowDeactivate(IWindowContext windowContext)
       at Microsoft.Mashup.Client.Excel.CustomTaskPaneManagers.OnWindowDeactivate(IWindowContext windowContext)
       at Microsoft.Mashup.Client.Excel.NativeEventHandler.<>c__DisplayClass1d.<OnWindowDeactivate>b__1c()
       at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

    Invocation Stack Trace:
       at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
       at Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace)
       at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception)
       at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
       at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.SendAndMarshalExceptions(SynchronizationContext context, Action callback)
       at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)
       at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
       at Microsoft.Mashup.Client.Excel.NativeEventHandler.OnWindowDeactivate(IntPtr uiFrame)
       at Microsoft.Mashup.Client.Excel.NativeExcelConnectorBase.<>c__DisplayClass5b.<OnWindowDeactivateCallback>b__5a()
       at Microsoft.Mashup.Client.Excel.NativeExcelConnectorBase.InvokeAndReturnHResult(Action action)
       at Microsoft.Mashup.Client.Excel.NativeExcelConnectorBase.OnWindowDeactivateCallback(IntPtr uiFrame)
       at System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.OnComponentEnterState(IntPtr dwComponentID, Int32 uStateID, Int32 uContext, Int32 cpicmExclude, Int32 rgpicmExclude, Int32 dwReserved)
       at System.Windows.Forms.ComponentManagerProxy.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.OnComponentEnterState(IntPtr dwComponentID, Int32 uStateID, Int32 uContext, Int32 cpicmExclude, Int32 rgpicmExclude, Int32 dwReserved)
       at System.Windows.Forms.Application.ThreadContext.BeginModalMessageLoop(ApplicationContext context)
       at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
       at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
       at System.Windows.Forms.Application.RunDialog(Form form)
       at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
       at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)
       at Microsoft.Mashup.Client.ClientShared.Ux.HtmlForm.ShowDialog(IWin32Window owner)
       at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.ShowUnexpectedErrorDialog(IWin32Window owner, WindowsHost windowsHost, FeedbackErrorInfo errorDetails)
       at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
       at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.SendAndMarshalExceptions(SynchronizationContext context, Action callback)
       at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)
       at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
       at Microsoft.Mashup.Client.Excel.NativeEventHandler.OnIdle()
       at Microsoft.Mashup.Client.Excel.NativeExcelConnectorBase.<OnIdleCallback>b__3a()
       at Microsoft.Mashup.Client.Excel.NativeExcelConnectorBase.InvokeAndReturnHResult(Action action)
       at Microsoft.Mashup.Client.Excel.NativeExcelConnectorBase.OnIdleCallback()


    Supports Premium Content:
    True

    Formulas:


    section Section1;


    • Edited by KMLN Tuesday, August 22, 2017 10:15 AM corrected formatting
    Tuesday, August 22, 2017 10:14 AM
  • Hi KMLN,

    When you say the Excel workbook starts calculating but not sending requests, did you observe the Excel service job was successfully submited and running in HPC Cluster Manager? If so, you may choose SOA Jobs view, and check the job counters for total and outstanding requests to see if the requests were sent from the Excel client to the broker then to the compute nodes.

    Meanwhile, you may also check the HPC Excel event logs under Event Viewer -> Applications and Services Logs -> Microsoft -> HPC -> Excel, and see if there were errors or warnings.

    And also check if you have Excel.exe.config with following content under the Excel.exe folder (C:\Program Files (x86)\Microsoft Office\root\Office16\), and make sure .Net 4.0 is available on the client machine.

    <?xml version="1.0"?>
    <configuration>
        <startup useLegacyV2RuntimeActivationPolicy="true">
            <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
        </startup>
    </configuration>

    Regards,

    Yutong Sun

    Tuesday, August 22, 2017 1:22 PM
    Moderator
  • Thanks Yutong. I figured out the issue was caused because I had renamed the Sheet in VBA properties and for some reason (I don't have a slightest clue), it threw an error. I copied the contents of that sheet into a new sheet and deleted the old sheet, it worked fine after that. I even named the new sheet what I wanted!
    • Marked as answer by KMLN Wednesday, August 23, 2017 11:19 AM
    Wednesday, August 23, 2017 11:19 AM