Skip to Content
avatar image
Former Member

Protection Issue.

Hi Experts,

I have protect my worksheet using protect worksheet.However when I modify/delete forecast numbers it won't allow me to change.It asks me to unlock the sheet first.

This was never happened before.Now i can only input values but i can not modify/delete the numbers without unlock.

Can any one help me on this.

Thanks,

Kiran

1111.PNG (18.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    Jan 12, 2015 at 06:06 PM

    Hi Kiran,

    Have you used EPM protection?

    What do you mean by "I modify/delete forecast numbers"?

    Vadim

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12, 2015 at 06:07 PM

    And please, remove the duplicated post!

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 13, 2015 at 05:52 AM

    You have probably used the Excel Sheet Protection.

    So, Un-protect Excel sheet and just use EPM sheet protection.That will do.

    Regards,

    Bishwajit

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 13, 2015 at 07:48 AM

    Hello Kiran,

    If you want to edit the data with Protect worksheet, try Allow users to Edit range function of Excel. With this you can specify range of data where protection does not apply.

    Regards

    Bhagyesh Ravange


    Add comment
    10|10000 characters needed characters exceeded

    • The idea of this function is to provide personal access to some ranges with:

      1. Active directory user id's

      2. Different passwords for different areas.

      The rest is covered by cell's locked property and EPM protection options.

      Vadim