I am using SAP BPC 11.1 standard. we have a requirement, our client needs to use excel formulae in the cells outside of the report. Because the report is protected, they are unable to use excel formula in the Current Sheet.
How can this be achieved, is there any way around to use excel formulas in a protected sheet? or can we protect only certain cells and not the whole worksheet.