on 10-02-2015 10:39 PM
Hello All,
We have requirement to prevent the users from editing the row and column headings in a report. Could you please let me know if there is any possible way to do this through EPM, as we can not make them through excel functionality(as users can disable it with ease).
Regards,
Madhav
HI Madhav,
Protect the sheet EPM- Sheet Options - Protection.
Shrikant
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vadim,
In formatting sheet I am right clicking on the Label fields and then would select on Lock Selected Cells, followed by protecting the workbook in Sheet Options.
This works for the first worksheet and it isn't working for the other worksheets in the workbook. I have check respective sheet option, and I see them protected(as I have selected protect workbook in sheet options).
Thanks,
Madhav
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.