When using the Excel feature 'Group/Ungroup' in a protected worksheet the groups cannot be opened and EPM functions do not work.
This is not caused by EPM Add-In but by a known limitation of Excel:
* Workaround 1
Copy the following VBA code into the module that appears:
Private Sub Workbook_Open()
.EnableOutlining = True
* Workaround 2