Pivot table in locked cells

  • Thread starter Thread starter PsyberFox
  • Start date Start date
P

PsyberFox

Hi there,

I have a pivot table that I don't want users to alter. However, there is one
field that I do want them to access to change the month that the report is to
be run for. I have locked all cells except the one containing the field that
I do want them access to... obviously this is not the way... Can someone
please explain to me how to set security access / locked cells for a pivot
table?

Thank you!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pivot table data 2
how to partially protect a pivot table based worksheet 8
Pivot Table - Changes 5
Excel VBA For excel 0
Pivot Table 1
Pivot Tables 1
Pivot Table Variance 2
Refreshing Pivot Table on a protected spreadsheet tab 1

Back
Top