XLS Padlock Guide
XLS Padlock Guide

Do not disable the following COM add-ins (enter ProgID):

 

 

All XLS Padlock Options > Security > Excel add-ins > Do not disable the following COM add-ins (enter ProgID):

 

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:

Company.Addin1;Company2.Addin2.File;…

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

Learn more at http://support.microsoft.com/kb/291392/en-us