ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Securing Pivot Table detail? (https://www.excelbanter.com/excel-worksheet-functions/139774-securing-pivot-table-detail.html)

Janet

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

Debra Dalgleish

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



All times are GMT +1. The time now is 07:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com