Sunday, July 13, 2014

Failed solution dump on trying to fix pivotpower on sucky windows

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.

No comments:

Post a Comment