Install Fails: PowerPivot 2012 RTM 32 bit with Excel 32 bit , .Net 4 and VSTO 2010 64 bit on 64 bit Win 7
I have read the similar post about PowerPivot not running after install here: http://social.msdn.microsoft.com/Forums/eu/sqlkjpowerpivotforexcel/thread/fe83c11a-2417-435d-be19-6dd0fadc66ce
My problem however is that PowerPivot 2012 RTM will not install (vs. not run after successful install) throwing a "Setup is missing prerequisites" error.
I have the following setup:
- 64 bit Windows 7 Enterprise, with Service Pack 1
- 32 bit Office Professional Plus 2010 with all Office Shared Features installed
- .NET 4 Framework (Client Profile and Extended show up in Programs and Features list)
- 64 bit Visual Studio 2010 Tools for Office (VSTO) Runtime (also shows 64 bit Visual C++ 2008 Redistributable v 9.0.30729.17)
I cannot find any documentation that says you must be all 64 bit or 32 bit for PowerPivot 2012 to work.... but it seems like 32 bit Excel would need 32 bit VSTO to use it, but Win 7 64 bit will only let you install VSTO 64 bit.
Can anyone verify if I need to use Office 64 bit and 64 bit PowerPivot to get it to work?
I also would like to add that Microsoft's claim of "Self Service" Business Intelligence cannot be true until you can seamlessly (read One-Click) install PowerPivot. If it needs .NET 4 and VSTO it should automatically fetch these during the download, not throw an error and say to visit a webpage where the webpage link is both NOT click-able and NOT selectable to paste into a browser! If you need an IT department to setup the software, it's not self-service.
Thanks for your time.