/build/static/layout/Breadcrumb_cap_w.png

Microsoft SQL Server PowerPivot for Excel 32-bit

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login
Views: 4.5k  |  Created: 05/23/2014 by: Badger

Average Rating: 0
SQL Server PowerPivot for Excel 32-bit has 1 inventory records, 0 Questions, 0 Blogs and 0 links. Please help add to this by sharing more!

Deployment Tips (4)

Most Common Setup Type
Windows Installer (MSI)
Average Package Difficulty Rating
Rated 2 / 5 (Somewhat Easy) based on 2 ratings
Most Commonly Reported Deployment Method
Windows Installer with Custom Transform (MST)
0
Note
Turn Off the annoying "Customer Experience Improvement Program" CEIP via HKCU Registry
I used this App-V 5.0 SP2

[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\110]

"CustomerFeedback"=dword:00000000

Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: unspecified
Platform(s):
0
Command Line

Nice and easy, there are two downloads, x86 and x64.
make the decision based on your Office version, NOT your OS architecture.

Install nice and simply with /QB (or /QN) switch. Does not ask for a reboot....
After the install, launch Excel and you will see the new add in load

 

Setup Information:
Setup Type: Windows Installer (MSI)
Deployment Method Used: Windows Installer with Custom Transform (MST)
Deployment Difficulty: Very Easy
Platform(s): Windows
0
Command Line

Removal for PowerPivot_for_Excel_x86 v11.1.3129.0
msiexec /x "{4CFC749F-E178-42C7-8095-796C5814C9C3}" /QN REEBOOT=ReallySuppress

 

Setup Information:
Setup Type: Windows Installer (MSI)
Deployment Method Used: Windows Installer Command Line (No MST)
Deployment Difficulty: unspecified
Platform(s): Windows
0
Note

Hold the phone... came in this morning, this app only loads for an admin. To explain, we are using VDI here, they have logged in with an admin account, installed it and it seems OK, but when users log into the VDI sessions, no addin appears in Excel. Crack open the MSI in Orca, sure enough the keys are all HKCU.

So my option are change the keys in an MST and move them to HKLM (which means we will have to take the VDI image off line, remove and re install, or, utilise the power of AppSense:

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 (x86)\\Microsoft Analysis Services\\AS Excel Client\\110\\Microsoft.AnalysisServices.XLHost.Addin.vsto|vstolocal"
"CartridgePath"="C:\\Program Files (x86)\\Microsoft Analysis Services\\AS OLEDB\\110\\Cartridges\\"

Obviously these keys will be a bit different if you App-V it or install on an x86 machine

UPDATE....

The MSI is fine... there was an issue with the AppSense personalisation.
The MSI installs HKCU keys, but also installs:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\14.0\User Settings\Microsoft.AnalysisServices.Modeler.FieldList

Full Reg info:


[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\14.0\User Settings\Microsoft.AnalysisServices.Modeler.FieldList\Create\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 (x86)\\Microsoft Analysis Services\\AS Excel Client\\110\\Microsoft.AnalysisServices.XLHost.Addin.vsto|vstolocal"
"CartridgePath"="C:\\Program Files (x86)\\Microsoft Analysis Services\\AS OLEDB\\110\\Cartridges\\"

 

So this injects the HKCU keys into HKLM and then is applied to the user when they run Office apps.

 

Setup Information:
Setup Type: Windows Installer (MSI)
Deployment Method Used: Windows Installer with Custom Transform (MST)
Deployment Difficulty: Somewhat Easy
Platform(s): Windows

Inventory Records (1)

View inventory records anonymously contributed by opt-in users of the K1000 Systems Management Appliance.

Versions

SQL Server PowerPivot for Excel 32-bit

Version

11.1.3129

Questions & Answers (0)

Questions & Answers related to Microsoft SQL Server PowerPivot for Excel 32-bit

Blogs (0)

Blog posts related to Microsoft SQL Server PowerPivot for Excel 32-bit

Reviews (0)

Reviews related to Microsoft SQL Server PowerPivot for Excel 32-bit

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ