Securing Pivot Table detail?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table with Data Model Connection - getpivotdata reference issue 0
Access #Error & Excel Pivot 0
Pivot table data source 1
Pivot Table with source spread across multiple worksheets 1
Pivot Tables by Macro 2
Export Pivot table 1
Pre-configuring Pivot table "views" 4
Workbook pivot table design function 6

Back
Top