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.