Excel 2010 version compatibility for Data Mining Add ins

Question

1.I want to download Data Mining Add ins on Excel 2010 version.We have SQL server 2008 R2 Analysis services.

I am not able to find any download option for these 2 compatibitity mode.In the microsoft dowmload site only finding Excel 2010 Data mining add ins for SQL server 2012 version.So please let me know if excel 2010 and SQL server 2008 r2 is compatible or not for using Data mining Add ins.

2.If yes from where I can download it?

3.We have 32 bit and 64 bit Excel 2010 with 32 bit and 64 bit Powerpivot add ins?Can we install Data Mining Add ins on both of these?PowerPivot and Data Mining Add ins can run simultaneously?



Answer 1

The version that you found works with SQL Server 2008 R2 even though instructions page says that it requires SQL Server 2012.  (http://www.microsoft.com/en-us/download/details.aspx?id=29061)

It can run on a machine that has PowerPivot installed without any issues.

The add-in can be installed on both 32 and 64 bit versions of excel, just pick the right setup package.

---

Tatyana Yakushev [PredixionSoftware.com]