By default, any existing Excel COM add-in is disabled when loading a secured workbook.

However, some useful add-ins like Microsoft PowerPivot may be required by your workbooks. In that situation, enter all progIDs of the different add-ins you want to keep in the field separated by semi colons:


For instance, for Microsoft PowerPivot, the ProgID are: Microsoft.AnalysisServices.Modeler.FieldList and PowerPivotExcelClientAddIn.NativeEntry.1

Learn more at