Is it possible to disable "Are you sure you want to install this customization" window in Excel 2010 for the first time a user uses PowerPivot for Excel plugin?
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.
Answers (1)
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.
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.