Freigeben über

Data mining and Power Pivot for Excel 2010 add-in issues with Windows 10 and Visual Studio 2015

  • Artikel

Update: Download the latest version of Data Mining add ins here that solve this issue.

Unfortunately with the release of Windows 10 and Visual Studio 2015 an issue was found in the 64 bit versions of the following products:

  • PowerPivot for Microsoft Excel 2010
  • Data Mining Add-ins for Microsoft Excel (Table Analysis Tools and Data Mining Client)

After installing .NET 4.6, the default .NET version that comes with Windows 10 and Visual Studio 2015, opening Excel with either add-in enabled will result in a crash of Excel. The next time Excel opens the following error message appears:

  • For PowerPivot for Microsoft Excel 2010: “Excel experienced a serious problem with ”powerpivot for excel” add-in. If you have seen this message multiple times, you should disable this add-in and check to see if an update is available. Do you want to disable this add-in.”
  • For the Data Mining Add-ins: “Excel experienced a serious problem with ”sqlserver.dmclientxladdin” add-in. If you have seen this message multiple times, you should disable this add-in and check to see if an update is available. Do you want to disable this add-in.”

This is caused by a bug in the add-ins that was exposed by the new 64-bit JIT compiler in .NET 4.6.

We are investigating the issue and the potential fix. In the meantime a workaround is available by allowing Excel to use the previous 64-bit JIT for .NET by adding a file to your Excel folder:

  • Navigate to the folder with your Excel executable (excel.exe), usually “C:\Program Files\Microsoft Office\Office14”. If you cannot find the folder:
    • Open windows explorer
    • Select “This PC”
    • Search for “excel.exe” in the “Search this PC” box on the upper right side of the explorer
    • Right mouse click on the file and select “open file location”
  • Create a file “excel.exe.config” in this folder, or download it here and add it to the folder
  • When creating the file yourself, open the file with notepad and add the following contents:

<configuration>
   <runtime> 
         <useLegacyJit enabled="1" />
</runtime>
</configuration>

  • Save the file
  • Reopen Excel

Alternatively you can download the file here and add it to your Excel folder.

Adding this file causes Excel to use the same 64-bit JIT as was available the previous version of .NET. When a fix has been released for this issue you might want to change this behavior back to the default JIT by deleting the file just created in the workaround. For more details see this article by the JIT team:  https://github.com/Microsoft/dotnet/blob/master/docs/testing-with-ryujit.md

We are sorry for the inconvenience this might have caused.

excel.exe.config

Comments

  • Anonymous
    August 05, 2015
    Thanks for sharing the cause and workaround, as I had really hard time understanding, why prowerpivot addin suddenly stopped working..

  • Anonymous
    August 08, 2015
    Related reading: nickcraver.com/.../why-you-should-wait-on-dotnet-46

  • Anonymous
    September 11, 2015
    The comment has been removed

  • Anonymous
    October 25, 2015
    Kasper, I tried the above with no luck ?? When I attach the 2 add-ins, it loads but displays 2 blank Tab in excel. If I press the blank tab it will show all the datamining options. But when I invoke one over a table it gives me the error "Object reference not set to an instance of an object. However I am connected to the SSAS ??

  • Anonymous
    October 26, 2015
    Hi Brian, You can now download a new version of the data mining addins where this is no longer an issue: www.microsoft.com/.../details.aspx I would recommend you to update your add-ins with these. Thanks, Kasper

  • Anonymous
    October 28, 2015
    Kasper, I followed all the steps

  1. I removed the old application
  2. added the one you indicated below
  3. run the wizard getting started and connected to the database in SSAS DMAddinsDB.
  4. I open excel and added the add-in thru options When I go to the spreadsheet I find the datamining tabs but they are blank tabs?? , but it does show all the options I bring the sample spreadshhet and call one of the function (example Explore Data) Wizard appears but it does not show me the table name and if I do a datarange it gives a error message "Object reference not set to an instance of an object" Appreciating any additional guidance

  • Anonymous
    October 28, 2015
    However I am able to use the the datamining facilities if I bring in the information from the SQL Server ?? Soo it means the addin is working ??

  • Anonymous
    January 07, 2016
    Hi!, The follow steps worked for me:

  1. Install o SQL_AS_DMAddin.msi com SP1
  2. Install o SQL_AS_DMAddin.msi com SP2
  3. Run msiexec /I c:tempSQL_AS_DMAddin.msi OFFICE2010PRESENT=1