After many years i got back on windows . just because my brother needed some help with excel pivots.
then i fount pivotpower and find windows 8 was the same shitty windows which was just dressed up .it has the same register , the same file system . so what aRE these guys making customer to pay for?
the interface is really bad . and makes it difficult to reach the desktop and restart the computer. why the hell would a desktop user need so many apps?
sorry for the rant but the amount of effort it takes to solve issues on windows just makes a tech support guy break down and rant. !!!!!!!!!!!!!!!!
PowerPivot Addin Won’t Load ? You May Need Visual Studio 2010 Tools for Office Runtime
If you still cannot get a valid error message, please try this
Open My Computer Properties
Click on Advanced Tab
Click on the Environmental Variable
Click on New User Variable
Add VSTO_SUPPRESSDISPLAYALERTS with value 0 press OK
Repair PowerPivot For Excel from add/remove program
Open Excel again, it will prompt an error message – that might lead you to a better
understanding of the problem.
The following solution cannot be loaded because Microsoft Office support for the .NET
Framework 4.0 is not installed: Microsoft.AnalysisServices.XLHost.Addin.vsto|vstolocal.
For
more information, see http://go.microsoft.com/fwlink/?LinkId=135965.
Microsoft .NET Framework 4 is already a part of this operating system. You do not need to
install the .NET Framework 4 redistributable. More information.
Same or higher version of .NET Framework 4 has already been installed on this computer.
solution
How to use App-V to virtualize Microsoft SQL Server 2008 R2 - PowerPivot for Excel 2010
http://blogs.technet.com/b/appv/archive/2013/03/06/how-to-use-app-v-to-virtualize-
microsoft-sql-server-2008-r2-powerpivot-for-excel-2010.aspx
Microsoft Application Virtualization 4.6 Service Pack 1
http://www.microsoft.com/en-in/download/details.aspx?id=14552
341 mb !!
Application Virtualization Dynamic Suite Composition Tool
You can use the App-V Dynamic Suite Composition tool to edit the Open Software Descriptor
(.osd) file associated with a virtual application package to create the inter-package
dependencies.
http://www.microsoft.com/en-us/download/details.aspx?id=6655
Problem solved. I had visual studio 2010 installed, after installing the VSTO 4.0 runtime,
my problem was resolved.
http://www.microsoft.com/downloads/details.aspx?familyid=f4d7a5a1-8ca8-489d-97eb-
663a54d609a0&displaylang=en
Vladimir Petrosyan | Support Escalation Engineer | Microsoft CTS Management and Security
Division
ssue / errors
PowerPivot for Excel is listed as Com Add-In. When I bring up the "COM Add-Ins" dialog,
the PowerPivot for Excel Add-In is listed but unchecked. Load Behavior is "Load at
Startup". If I check it and then click 'ok' and then re open the dialog, it isn't checked
anymore, and the Load Behavior says "Not loaded. A runtime error occurred during the
loading of the COM Add-in:
solutions 1: installing VSTO 2010 and visualc++ 2010, this addressed the "not loaded"
errors
solutions 2: once that is done the add-ins will not load automatically when starting
excel, setup VSTO error display under system environment variables
"VSTO_SUPPERSDISPLAYALRTS" = 0, its turn out i have another com add-ins that are
conflicting with PowerPivot.
Logon as the non-admin user - query the following registry key:
HKEY_CURRENT_USER\software\microsoft\office\excel\Addins
If it exists it should list the folllowing key:
Microsoft.AnalysisServices.Modeler.FieldList
If the key exists - then this is not your problem.
If the key does not exist you will need to create it.
Backup your registry. There are many Microsoft links that will show you how to do this.
Copy and paste the following into a text file.
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Office\Excel]
[HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins]
[HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins
\Microsoft.AnalysisServices.Modeler.FieldList]
"Description"="Microsoft SQL Server PowerPivot for Microsoft Excel"
"FriendlyName"="PowerPivot for Excel"
"LoadBehavior"=dword:00000003
"Manifest"="C:\\Program Files\\Microsoft Analysis Services\\AS Excel Client\\110\
\Microsoft.AnalysisServices.XLHost.Addin.vsto|vstolocal"
"CartridgePath"="C:\\Program Files\\Microsoft Analysis Services\\AS OLEDB\\110\
\Cartridges\\"
Save the file with .reg extension.
Import the new registry key into your user profile.
Launch Excel - the Plug-in should now launch
http://robkerrbi.blogspot.in/2011/10/installing-powerpivot-2012-ctp3-for.html
Contents of upgradepowerpivot.reg:
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Office\ Excel\Addins
\Microsoft.AnalysisServices.Modeler.FieldList]
"Description"="Microsoft SQL Server PowerPivot for Microsoft Excel"
"FriendlyName"="PowerPivot for Excel"
"LoadBehavior"=dword:00000003
"Manifest"="C:\\Program Files\\Microsoft Analysis Services\\AS Excel Client\\110\
\Microsoft.AnalysisServices.XLHost.Addin.vsto|vstolocal"
"CartridgePath"="C:\\Program Files\\Microsoft Analysis Services\\AS OLEDB\\110\
\Cartridges\\"
http://office.microsoft.com/en-in/excel-help/start-power-pivot-in-microsoft-excel-2013-
add-in-HA102837097.aspx?CTT=5&origin=HA101959985
Troubleshooting: Power Pivot ribbon disappears
In rare cases, the Power Pivot ribbon will disappear from the menu if Excel determines
that the add-in is destabilizing to Excel. This might occur if Excel closes unexpectedly
while the Power Pivot window is open. To restore the Power Pivot menu, do the following:
15 is not there!!!
Go to File > Options > Add-Ins.
In the Manage box, click Disabled Items > Go.
Select Microsoft Office Power Pivot in Microsoft Excel 2013 and then click Enable.
If the previous steps do not restore the Power Pivot ribbon, or if the ribbon disappears
when you close and reopen Excel, try the following:
Close Excel.
Point to Start > Run and then type regedit.
In Registry Editor, expand HKEY_CURRENT_USER > Software > Microsoft > Office > 15.0 > User
Settings.
Right-click PowerPivotExcelAddin and then click Delete.
Scroll back up to the top of Registry Editor.
Expand HKEY_CURRENT_USER > Software > Microsoft > Office > Excel > Addins.
Right-click PowerPivotExcelClientAddIn.NativeEntry.1 and then click Delete.
Close Registry Editor.
Open Excel.
Enable the add-in using the steps at the top of this article.
http://denglishbi.wordpress.com/2010/06/21/where-did-my-powerpivot-excel-2010-tab-go/
http://www.microsoft.com/en-us/download/details.aspx?id=29074
Some folks are having problems with PowerPivot for Excel CTP3. In all cases we have seen,
this is because folks have installed only Excel when installing Office 14 beta 2.
For Office 14 Beta 2 / PowerPivot CTP3, you must include "Office Shared Features" when
installing Office. The reason is that VSTO runtime is installed as part of Office Shared
Features and PowerPivot is a VSTO add-in.
If you installed only Excel and PowerPivot isn't loading, you need to
1. Uninstall PowerPivot & Office 14
2. Reinstall Office 14 and include "Office Shared Features"
3. Reinstall PowerPivot
That should fix things up.
http://blogs.msdn.com/b/ronpih/archive/2009/11/18/office-14-beta-2-powerpivot-for-excel-
ctp3-you-must-install-office-shared-tools.aspx
http://msdn.microsoft.com/en-US/library/5a4x27ek
(v=vs.100).aspx#standalone_redistributable_packages
Microsoft Visual Studio 2010 Service Pack 1 (Installer)
http://www.microsoft.com/en-us/download/confirmation.aspx?id=23691
Installation Requirements:
A compatible version of Visual Studio 2010 was not detected on the system. This update is
designed for only the Microsoft Visual Studio 2010
So what’s going on? Long story short, to get this to work you need to sequence the
Microsoft SQL Server 2008 R2 - PowerPivot add-in as an independent package and then use
the App-V Application Virtualization Dynamic Suite Composition Tool to integrate the
packages so they can be part of the same virtual environment.
http://blogs.technet.com/b/appv/archive/2013/03/06/how-to-use-app-v-to-virtualize-
microsoft-sql-server-2008-r2-powerpivot-for-excel-2010.aspx
long story short?? wtf no wonder windows is going down the drain.
Service Pack 1 (SP1) for Microsoft Office 2010 (KB2460049) 32-bit Edition contains new
updates which improve security, performance, and stability
http://www.microsoft.com/en-in/download/details.aspx?id=26622
362 mb!!!!!
Here’s are the steps to sequence the Microsoft SQL Server 2008 R2 - PowerPivot add-in:
1. Install Microsoft Office 2010 SP1 x86 locally on your clean sequencer machine.
2. Start monitoring using the App-V 4.6 SP1 Sequencer and install the Microsoft SQL Server
2008 R2 - PowerPivot for Excel 2010 add-in using the defaults (download:
http://www.microsoft.com/en-gb/download/details.aspx?id=7609).
3. While still at the Installation Phase of the App-V Sequencer wizard, start Excel 2010
and verify that the add-in tab is available and functioning.
4. Save the Microsoft SQL Server 2008 R2 - PowerPivot add-in package.
Now just use the App-V Application Virtualization Dynamic Suite Composition Tool
(http://www.microsoft.com/en-us/download/details.aspx?id=6655) to set your existing
Microsoft Office 2010 package as the primary package and the Microsoft SQL Server 2008 R2
- PowerPivot add-in package as the secondary. You also can set the secondary package as
mandatory so that when the Office 2010 package is launched, the PowerPivot package will be
streamed as well.
Vladimir Petrosyan http://www.youtube.com/watch?v=l7e-EfFTrc8 | Support Escalation
Engineer | Microsoft CTS Management and Security Division
http://powerpivot-info.com/post/77-how-to-install-powerpivot-for-excel-and-list-of-know-
issues
Microsoft .NET Framework 4 KB2468871
http://www.microsoft.com/en-us/download/confirmation.aspx?id=3556
Details
Microsoft .NET Framework 4 is already a part of this operating system. You do not need to
install the .NET Framework 4 redistributable. More information.
Same or higher version of .NET Framework 4 Client Profile has already been installed on
this computer.
KB2468871v2 does not apply, or is blocked by another condition on your computer.
then i fount pivotpower and find windows 8 was the same shitty windows which was just dressed up .it has the same register , the same file system . so what aRE these guys making customer to pay for?
the interface is really bad . and makes it difficult to reach the desktop and restart the computer. why the hell would a desktop user need so many apps?
sorry for the rant but the amount of effort it takes to solve issues on windows just makes a tech support guy break down and rant. !!!!!!!!!!!!!!!!
PowerPivot Addin Won’t Load ? You May Need Visual Studio 2010 Tools for Office Runtime
If you still cannot get a valid error message, please try this
Open My Computer Properties
Click on Advanced Tab
Click on the Environmental Variable
Click on New User Variable
Add VSTO_SUPPRESSDISPLAYALERTS with value 0 press OK
Repair PowerPivot For Excel from add/remove program
Open Excel again, it will prompt an error message – that might lead you to a better
understanding of the problem.
The following solution cannot be loaded because Microsoft Office support for the .NET
Framework 4.0 is not installed: Microsoft.AnalysisServices.XLHost.Addin.vsto|vstolocal.
For
more information, see http://go.microsoft.com/fwlink/?LinkId=135965.
Microsoft .NET Framework 4 is already a part of this operating system. You do not need to
install the .NET Framework 4 redistributable. More information.
Same or higher version of .NET Framework 4 has already been installed on this computer.
solution
How to use App-V to virtualize Microsoft SQL Server 2008 R2 - PowerPivot for Excel 2010
http://blogs.technet.com/b/appv/archive/2013/03/06/how-to-use-app-v-to-virtualize-
microsoft-sql-server-2008-r2-powerpivot-for-excel-2010.aspx
Microsoft Application Virtualization 4.6 Service Pack 1
http://www.microsoft.com/en-in/download/details.aspx?id=14552
341 mb !!
Application Virtualization Dynamic Suite Composition Tool
You can use the App-V Dynamic Suite Composition tool to edit the Open Software Descriptor
(.osd) file associated with a virtual application package to create the inter-package
dependencies.
http://www.microsoft.com/en-us/download/details.aspx?id=6655
Problem solved. I had visual studio 2010 installed, after installing the VSTO 4.0 runtime,
my problem was resolved.
http://www.microsoft.com/downloads/details.aspx?familyid=f4d7a5a1-8ca8-489d-97eb-
663a54d609a0&displaylang=en
Vladimir Petrosyan | Support Escalation Engineer | Microsoft CTS Management and Security
Division
ssue / errors
PowerPivot for Excel is listed as Com Add-In. When I bring up the "COM Add-Ins" dialog,
the PowerPivot for Excel Add-In is listed but unchecked. Load Behavior is "Load at
Startup". If I check it and then click 'ok' and then re open the dialog, it isn't checked
anymore, and the Load Behavior says "Not loaded. A runtime error occurred during the
loading of the COM Add-in:
solutions 1: installing VSTO 2010 and visualc++ 2010, this addressed the "not loaded"
errors
solutions 2: once that is done the add-ins will not load automatically when starting
excel, setup VSTO error display under system environment variables
"VSTO_SUPPERSDISPLAYALRTS" = 0, its turn out i have another com add-ins that are
conflicting with PowerPivot.
Logon as the non-admin user - query the following registry key:
HKEY_CURRENT_USER\software\microsoft\office\excel\Addins
If it exists it should list the folllowing key:
Microsoft.AnalysisServices.Modeler.FieldList
If the key exists - then this is not your problem.
If the key does not exist you will need to create it.
Backup your registry. There are many Microsoft links that will show you how to do this.
Copy and paste the following into a text file.
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Office\Excel]
[HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins]
[HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins
\Microsoft.AnalysisServices.Modeler.FieldList]
"Description"="Microsoft SQL Server PowerPivot for Microsoft Excel"
"FriendlyName"="PowerPivot for Excel"
"LoadBehavior"=dword:00000003
"Manifest"="C:\\Program Files\\Microsoft Analysis Services\\AS Excel Client\\110\
\Microsoft.AnalysisServices.XLHost.Addin.vsto|vstolocal"
"CartridgePath"="C:\\Program Files\\Microsoft Analysis Services\\AS OLEDB\\110\
\Cartridges\\"
Save the file with .reg extension.
Import the new registry key into your user profile.
Launch Excel - the Plug-in should now launch
http://robkerrbi.blogspot.in/2011/10/installing-powerpivot-2012-ctp3-for.html
Contents of upgradepowerpivot.reg:
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Office\ Excel\Addins
\Microsoft.AnalysisServices.Modeler.FieldList]
"Description"="Microsoft SQL Server PowerPivot for Microsoft Excel"
"FriendlyName"="PowerPivot for Excel"
"LoadBehavior"=dword:00000003
"Manifest"="C:\\Program Files\\Microsoft Analysis Services\\AS Excel Client\\110\
\Microsoft.AnalysisServices.XLHost.Addin.vsto|vstolocal"
"CartridgePath"="C:\\Program Files\\Microsoft Analysis Services\\AS OLEDB\\110\
\Cartridges\\"
http://office.microsoft.com/en-in/excel-help/start-power-pivot-in-microsoft-excel-2013-
add-in-HA102837097.aspx?CTT=5&origin=HA101959985
Troubleshooting: Power Pivot ribbon disappears
In rare cases, the Power Pivot ribbon will disappear from the menu if Excel determines
that the add-in is destabilizing to Excel. This might occur if Excel closes unexpectedly
while the Power Pivot window is open. To restore the Power Pivot menu, do the following:
15 is not there!!!
Go to File > Options > Add-Ins.
In the Manage box, click Disabled Items > Go.
Select Microsoft Office Power Pivot in Microsoft Excel 2013 and then click Enable.
If the previous steps do not restore the Power Pivot ribbon, or if the ribbon disappears
when you close and reopen Excel, try the following:
Close Excel.
Point to Start > Run and then type regedit.
In Registry Editor, expand HKEY_CURRENT_USER > Software > Microsoft > Office > 15.0 > User
Settings.
Right-click PowerPivotExcelAddin and then click Delete.
Scroll back up to the top of Registry Editor.
Expand HKEY_CURRENT_USER > Software > Microsoft > Office > Excel > Addins.
Right-click PowerPivotExcelClientAddIn.NativeEntry.1 and then click Delete.
Close Registry Editor.
Open Excel.
Enable the add-in using the steps at the top of this article.
http://denglishbi.wordpress.com/2010/06/21/where-did-my-powerpivot-excel-2010-tab-go/
http://www.microsoft.com/en-us/download/details.aspx?id=29074
Some folks are having problems with PowerPivot for Excel CTP3. In all cases we have seen,
this is because folks have installed only Excel when installing Office 14 beta 2.
For Office 14 Beta 2 / PowerPivot CTP3, you must include "Office Shared Features" when
installing Office. The reason is that VSTO runtime is installed as part of Office Shared
Features and PowerPivot is a VSTO add-in.
If you installed only Excel and PowerPivot isn't loading, you need to
1. Uninstall PowerPivot & Office 14
2. Reinstall Office 14 and include "Office Shared Features"
3. Reinstall PowerPivot
That should fix things up.
http://blogs.msdn.com/b/ronpih/archive/2009/11/18/office-14-beta-2-powerpivot-for-excel-
ctp3-you-must-install-office-shared-tools.aspx
http://msdn.microsoft.com/en-US/library/5a4x27ek
(v=vs.100).aspx#standalone_redistributable_packages
Microsoft Visual Studio 2010 Service Pack 1 (Installer)
http://www.microsoft.com/en-us/download/confirmation.aspx?id=23691
Installation Requirements:
A compatible version of Visual Studio 2010 was not detected on the system. This update is
designed for only the Microsoft Visual Studio 2010
So what’s going on? Long story short, to get this to work you need to sequence the
Microsoft SQL Server 2008 R2 - PowerPivot add-in as an independent package and then use
the App-V Application Virtualization Dynamic Suite Composition Tool to integrate the
packages so they can be part of the same virtual environment.
http://blogs.technet.com/b/appv/archive/2013/03/06/how-to-use-app-v-to-virtualize-
microsoft-sql-server-2008-r2-powerpivot-for-excel-2010.aspx
long story short?? wtf no wonder windows is going down the drain.
Service Pack 1 (SP1) for Microsoft Office 2010 (KB2460049) 32-bit Edition contains new
updates which improve security, performance, and stability
http://www.microsoft.com/en-in/download/details.aspx?id=26622
362 mb!!!!!
Here’s are the steps to sequence the Microsoft SQL Server 2008 R2 - PowerPivot add-in:
1. Install Microsoft Office 2010 SP1 x86 locally on your clean sequencer machine.
2. Start monitoring using the App-V 4.6 SP1 Sequencer and install the Microsoft SQL Server
2008 R2 - PowerPivot for Excel 2010 add-in using the defaults (download:
http://www.microsoft.com/en-gb/download/details.aspx?id=7609).
3. While still at the Installation Phase of the App-V Sequencer wizard, start Excel 2010
and verify that the add-in tab is available and functioning.
4. Save the Microsoft SQL Server 2008 R2 - PowerPivot add-in package.
Now just use the App-V Application Virtualization Dynamic Suite Composition Tool
(http://www.microsoft.com/en-us/download/details.aspx?id=6655) to set your existing
Microsoft Office 2010 package as the primary package and the Microsoft SQL Server 2008 R2
- PowerPivot add-in package as the secondary. You also can set the secondary package as
mandatory so that when the Office 2010 package is launched, the PowerPivot package will be
streamed as well.
Vladimir Petrosyan http://www.youtube.com/watch?v=l7e-EfFTrc8 | Support Escalation
Engineer | Microsoft CTS Management and Security Division
http://powerpivot-info.com/post/77-how-to-install-powerpivot-for-excel-and-list-of-know-
issues
Microsoft .NET Framework 4 KB2468871
http://www.microsoft.com/en-us/download/confirmation.aspx?id=3556
Details
Microsoft .NET Framework 4 is already a part of this operating system. You do not need to
install the .NET Framework 4 redistributable. More information.
Same or higher version of .NET Framework 4 Client Profile has already been installed on
this computer.
KB2468871v2 does not apply, or is blocked by another condition on your computer.