|
|
#1
06-19-2012, 10:11 AM
|
|||
|
|||
PivotTable
The 1st tab of the attached tab is the data source, 2nd tab is PivotTable listing the Dept names under each Admin Area then the products # belong to each Dept. My objective is to prevent the users of redesign this PivotTable. They can build new PivotTables but not to change the original one.
To do that, I have protected the sheet in the 2nd tab (password=test) where if they right click any filed, they cannot see the filed list. However, a new undesired issue has appeared which that they cannot see the details of each product once they click it. In the unprotected tab (3rd tab), a new sheet will be automatically created once you click any product No. to show you details belong to this product. How can keep both; protected sheet (or workbook) and allow the user to see details of any product once they click it? I appreciate your support. Thank you. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| PivotTable | ibrahimaa | Excel Programming | 1 | 04-15-2012 12:30 AM |
Windows Vista 
Office 2007
Threaded Mode