Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell detail in pivot table | Excel Discussion (Misc queries) | |||
Displaying pivot table detail | Excel Worksheet Functions | |||
Pivot Table - cubed detail | Excel Discussion (Misc queries) | |||
Pivot table subtotals before detail | Excel Discussion (Misc queries) | |||
pivot table - subtotal below detail | Excel Discussion (Misc queries) |