When I try to run XL2010 32-bit on the Head Node and on the Compute Node, I get an error that the Cluster Connector cant be loaded.
I created an Excel.exe.config file to tell Excel to use the correct version of Dot Net, and that let the Connector load.
<?xml version="1.0"?>
<configuration>
<startup useLegacyV2RuntimeActivationPolicy="true">
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
</startup>
</configuration>
When I try to run the VBASample.xlsm in the SDK, it wont run. I found that it is pointing to :
Missing VBA Reference : {F0CA0F85-1704-3508-86C6-6AC7D4EA4E37}\
C:\Windows\assembly\GAC_MSIL\Microsoft.Hpc.Excel\2.0.0.0__31bf3856ad364e35\Microsoft.Hpc.Excel.tlb
When I change the reference to :
C:\Program Files\Microsoft HPC Pack 2012\Bin\Microsoft.Hpc.Excel.tlb , the VBASample will run correctly.
If I am using 64 bit Excel, Excel corrects the reference when it loads the VBASample.xlsm.
Should the 32-bit version of Excel also find the correct path to the reference?
What might cause the difference? The *.tlb not registered properly on the 32 bit machine?
thanks
-randy