Hi,

I am packaging PowerPivot for Excel plugin 10.51.2500.0 for Windows server 2008R2. After the package is installed, for the first time a user opens Excel, a window like this will pop up:

---------------------------------------------------

Microsoft Office Customization Installer

Publisher has been verified

Are you sure you want to install this customization?

Name: Powerpivot for Excel - PowerPivot for Excel

From: file:///c:/Program Files(x86)/Microsoft Analysis Services/ASExcelClient/10/Microsoft.AnalysisServices.Modeler.FieldList.vsto

PUblisher: Microsoft Corporation

Install           Don't Install

------------------------------------------

User has to click on Install button to install. Is there a way to automate this process? Thanks.

Answer Summary:
Install the source MSI first, then a test user opens Excel and click install button to install the plugin onto Excel. Export the below registry key hives HKCU\Software\Microsoft\VSTO\Security\Inclusion (this key will supress the above dialog box popping up) HKCU\Software\Microsoft\VSTO\SolutionMetadata (I exported this key as well since it was generated as well once user installed the plugin onto Excel). Create an Active Setup in a MST to import the above keys to HKCU.
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

3

I just found a solution so I put it here.

Install the source MSI first, then a test user opens Excel and click install button to install the plugin onto Excel. Export the below registry key hives

HKCU\Software\Microsoft\VSTO\Security\Inclusion (this key will supress the above dialog box popping up)

HKCU\Software\Microsoft\VSTO\SolutionMetadata (I exported this key as well since it was generated as well once user installed the plugin onto Excel).

Create an Active Setup in  a MST to import the above keys to HKCU.

Hope that help people with similar problems.

Answered 07/30/2012 by: nbafifa02
Senior Yellow Belt

Please log in to comment
Answer this question or Comment on this question for clarity