Protect part of pivot table

G

Guest

I want to protect the Page field in a pivot table and have tried leaving the
Page field cells status as locked and unlocking the other fields within the
pivot table and then protecting the sheet, but it seems to protect the entire
pivot table.

My guess is that I will have to run a macro to allow user to unprotect the
sheet to refresh the data the protect it again, but thought I would
double-check here first.

Thanks!
 
D

Debra Dalgleish

That's correct. You'll have to unprotect the worksheet so you can
refresh the pivot table.
 

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

Top