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?

"Ruby Christine" wrote:

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.