How to setup refreshable crosstab in a protected sheet?

R

Ruby Christine

I have a worksheet with a crosstab that start at cells F1. I would like to
lockout only the cells is range A1:D10 , protect the sheet and still allow
for all users to refresh the data in the crosstab.
 
R

Ruby Christine

My question should read How do I setup a refreshable cross tab (pivot table)
in a protected sheet?
Also is it possible to do this and disallow deletion of the pivot table?
 
Top