D
dee
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!
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!