Stop Force Consolidate in Excel
I am stopping users from running forced calculate/translate/consolidate with the following in "WcfEventHandler".
If args.IsBeforeEvent AndAlso (args.WcfServiceType = WcfServiceType.Calculate) AndAlso (args.OperationName="CalculateChartLogic" OrElse args.OperationName= "StartConsolidation" OrElse args.OperationName= "StartProcessCube" OrElse args.OperationName= "Translate" ) Then
Dim isForced As Boolean = args.inputs(2)
If isForced = "True" Then
args.Cancel = True
Throw New XFException(si, New Exception("You do not have access to Force Calculate/Translate/Consolidate."))
End If
End If
How do I stop users from running these functions in a report in excel?