And let me tell you, every machine is different, no two problems similar.
So I'd like to document some of the fixes I've see so far.
1. Do you have Office 2010 installed? If not, please load it.
2. When you open MS Excel, do you see a tab named “Power Pivot”?
3. If not, we’ll need to download the Power Pivot Add-In from the web.
4. First we'll need to know if you have Excel 32 bit or 64 bit.Go to Excel à File à Help à
You can download PowerPivot here:
1. Choose ENU\x64\PowerPivot_for_Excel_amd64.msi if you have 64-bit
2. Choose ENU\x86\PowerPivot_for_Excel_x86.msi if you have 32-bit.
3. Click Download, then run and install.
4. You may get an error message asking to install .Net Framework 4.0 or Visual Studio 2010 Tools for Office Runtime à http://www.bradleyschacht.com/sql-server-2012-powerpivot-for-excel-prerequisites-error/
5. If you are not located in the physical United States, you’ll need to modify your computer’s local.
Need to go control panel find à
1. Once set can change setting back and never have to change it again.
2. You may also get an error message for .net 4.0:
1. Will need to install this à http://www.microsoft.com/en-us/download/details.aspx?id=17851
Lastly there are some Analysis Server files that need to get downloaded and installed as well à http://www.microsoft.com/en-us/download/details.aspx?id=29065
1. Microsoft® SQL Server® 2012 Analysis Management Objects
2. Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2012
Analysis Management Objects (AMO) is a .NET Framework object model that enables software developers to create client-side applications to manage and administer Analysis Services objects.
You may get an error that you need to install Microsoft Silverlight à http://www.microsoft.com/getsilverlight/Get-Started/Install/Default.aspxAnd here's some issues troubleshooting Mac --> Power Pivot issues: