Prevent users from changing a pivot table
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. |
All times are GMT +1. The time now is 12:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com