Hi,
Please see the article about
OCT, there are no option to control the Power Pivot and Power View now.
Then, I recommend we try the two workaround:
Workaround 1:
Use GPP to edit the registry and enable the add-ins after installation Office.
Here is the registry key information:
Microsoft Office PowerPivot for Excel 2013 add-in
-
HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\User Settings\PowerPivotExcelAddin
- HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\PowerPivotExcelClientAddIn.NativeEntry.1
disable: LoadBehavior: 0x00000002
enable: LoadBehavior: 0x00000003
Power View add-in
-
HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\User Settings\PowerViewExcelAddin
-
HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\AdHocReportingExcelClientLib.AdHocReportingExcelClientAddIn.1
disable: LoadBehavior: 0x00000002
enable: LoadBehavior: 0x00000003
Workaround 2:
Use a VBA/PowerShell script to manage the com add-ins. We could use AddIns.Add Method:
http://msdn.microsoft.com/en-us/library/office/ff834655(v=office.15).aspx
If you have any question about writing the script, I recommend your question to the MSDN forum for Excel
http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc
George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"