Limit access in a pivot table

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I have a pivot table that I want to send to someone. Is it possible that you
can limit the viewing to a certain criteria.
I want them to only be able to see information for supplier “A†but not “Bâ€
and “C†and still be able to use the functions of the pivot table
 
Debra Dalgleish has instructions for using macros to disable selections and
restrict pivot tables on her Contextures site:

http://www.contextures.com/xlPivot12.html

However, I think the safest approach is to segregate the data for supplier A
first and create the pivot table from that.

Hope this helps,

Hutch
 

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
Sorting in a Pivot Table unselected fields 1
Pre-configuring Pivot table "views" 4
grouping dates in a pivot table 1
Average of Subtotals in Pivot Table 0
Multi-Condition Formula 5
Look Up march and copy info back - Help! confused!! 9
Access #Error & Excel Pivot 0

Back
Top