Protect and lock cell in Pivottable

[Hagge]

I need to create pivottable reports for several users. The data comes from a
cube and i just want to change one parameter (user) in the "base" pivottable
and then give access to the user. The user should be able to change the other
parameters that is visible (ex. country, period) but not be able to access
other pivottable fields and not be able to change the user. Is this possible?

 

[Tom Hutchins]

I don't think it's possible. I have experimented with various worksheet
protection options and Worksheet_SelectionChange event macros, and couldn't
get it to work.
Of course, the Excel MVP's know a lot more than I do; maybe one of them
knows how.

I suggest you put each user's data on a separate sheet and create individual
pivot tables. Splitting the data onto separate sheets may be easier than you
think. I have uploaded a macro I wrote years ago for this purpose; you can
get it here:
http://www.freefilehosting.net/download/3fhgd

Or, you can use an advanced filter to split the user data onto separate
sheets. Debra Dalgeish has instructions on her excellent Contextures site:
http://www.contextures.com/tiptech.html

She even has a relevant example workbook you can download:
http://www.contextures.com/excelfiles.html#Filter
Look for FL0013 AdvFilterRepFiltered.zip

After the data is separated by user, I don't think it will be hard to write
a macro which will create a pivot table for each user and export the pivot
table & data for each user to its own workbook. I can help you with that.

Hope this helps,

Hutch