I found that even if I unlock the desired cell wen I protect the worksheet,
it still does not provide what is needed because if they want to choose a
another time frame, pivot table has to refresh which violates the protection
worksheet.

It doesn't seem to be possible to accomplish what is needed. If you have any
ideas please let me know.

"SAM" wrote:

Do you know how to lock one cell versus the entire worksheet?

I don't want the sales person to be able to select another sales person from
the filter on the pivot table but if I protect the entire worksheet, they
cannot filter on the time and that is needed.

"SAM" wrote:

Is there a way to enforce domain in excel worksheet?

I have created a Sales report against a cube and want to enforce security
for each sales person to only see their data based on their login.