How to setup refreshable crosstab in a protected sheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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?
 
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

Refresh pivot table on protected sheet 3
Refresh Pivot table data in protect sheet 2
Crosstabs do not copy as I would like when copying worksheets 6
Refreshing Pivot Table on a protected spreadsheet tab 1
Refresh Pivot table data in Protected sheet 3
Code to format cells on several worksheets 2
Unprotect sheet to "Refresh All" Access queries 2
Copying a split range 3

Back
Top