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()
With Worksheets("Sheet1")
.EnableOutlining = True
.Protect UserInterfaceOnly:=True
End With
End Sub
* Workaround 2
Will Hunt
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()
With Worksheets("Sheet1")
.EnableOutlining = True
.Protect UserInterfaceOnly:=True
End With
End Sub
* Workaround 2
- Unprotect the report/input schedule in question by using EPM > Options > Sheet Options > Protection tab > select 'No Protection'