Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default Restricting Data Elements in Pivot Table

Is there a way to restrict the user of a Pivot Table from changing the Data
elements while still allowing them to change the value of a Page element?
When I protect the worksheet, the Pivot Table becomes completely locked.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table - Use Other Pivot Table as Data Source WCM Excel Discussion (Misc queries) 1 January 25th 07 06:39 PM
How do I sort pivot table data outside a pivot table Michael Excel Worksheet Functions 1 January 4th 07 02:45 PM
Data Validation - but not restricting values Jon5001 Excel Discussion (Misc queries) 5 July 26th 06 03:25 AM
pivot chart colors- how to keep from changing when data elements are added/removed? KR Charts and Charting in Excel 1 July 12th 06 06:41 PM
how do I hide data elements in pivot in excel 2003 ? [email protected] Excel Worksheet Functions 0 September 28th 05 08:03 PM


All times are GMT +1. The time now is 06:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"