Prevent users from changing a pivot table

P

Popeye

Hi everyone

I use Excel 2003 and have created a pivot table that I want to share with
colleagues. I know that I can lock the worksheet and hide the sheet which
contains the raw data but I want my colleagues to be able to use the drop
down boxes within the pivot table. Is it possible for me to lock the format
of the table (and, for instance, prevent them from seeing the field list) but
still allow them to use the drop down features to display various data within
the table?

Thank you in advance.
 

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