Protection Issue.

[Former Member]

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

[former_member186338 · Accepted solution]

Hi Kiran,

Have you used EPM protection?

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

Vadim

[Former Member · Accepted solution]

Hi Vadim,

Thank you for your reply.

Yes ,i have used Epm protection only.

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

Actually we copied the actuals to forecast numbers ,now users want to add or modified the forecast numbers,If they want to modify the numbers the same pop up appears like please un protect the sheet first?

Do you have any idea?

Thanks,

Kiran

[Shrikant_Jadhav · Accepted solution]

HI Kiran,

Kindly check your formatting sheet whether you have locked cell where you want to input data.

Shrikant

[Former Member · Accepted solution]

Hi Shrikant,

Yes you are right,the cells were locked.

Thank you so much for your help.

Thanks,

Srikanth

[former_member186338 · Accepted solution]

Hi Kiran,

If you use formatting sheet - please correctly set locked for the required data cells.

Without formatting sheet - directly set lock on the report cells to be changed to off.

Vadim

[bhagyesh_ravange]

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

[former_member186338]

Hi Bhagyesh,

Not sure that your proposal is relevant to the Kiran's issue. The lock property has to be properly set for cells... And EPM protection has to be used.

Vadim

[bhagyesh_ravange]

Hi Vadim,

I have applied this function in one of my report. Through this we can protect whole worksheet and can provide the Cell range where this protection is not required. In my case I have given the Report range where user can make changes to data but other function (i.e Delete column, rows and all were locked).

[former_member186338]

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

[bishwajit_das]

You have probably used the Excel Sheet Protection.

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

Regards,

Bishwajit

[former_member186338]

And please, remove the duplicated post!