Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 49
Default Securing Pivot Table detail?

Can I so that users only see their data?

I have a situation that a pivot table will be shared with a large amount of
users. I'd like to secure the pivot table detail data so that they only see
the data that is theirs.

Is this possible? If so, how?

Thanks for any help.

Janet
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,979
Default Securing Pivot Table detail?

If users can open the workbook, the data in Excel is not secure. If the
data is confidential, you should put each person's data in a separate
workbook, and create a pivot table from that data.

Janet wrote:
Can I so that users only see their data?

I have a situation that a pivot table will be shared with a large amount of
users. I'd like to secure the pivot table detail data so that they only see
the data that is theirs.

Is this possible? If so, how?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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
Cell detail in pivot table Debra Dalgleish Excel Discussion (Misc queries) 0 August 2nd 06 09:27 PM
Displaying pivot table detail Coop@nationwide Excel Worksheet Functions 1 April 25th 06 03:36 AM
Pivot Table - cubed detail Chris Segrave Excel Discussion (Misc queries) 2 September 14th 05 12:14 AM
Pivot table subtotals before detail Jeanmarie Excel Discussion (Misc queries) 2 February 11th 05 10:41 PM
pivot table - subtotal below detail Massimo Excel Discussion (Misc queries) 6 January 22nd 05 05:21 PM


All times are GMT +1. The time now is 12:37 PM.

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

About Us

"It's about Microsoft Excel"