| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Limit access in a pivot table
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Limit access in a pivot table
Protect the sheet & send it.
On Oct 23, 7:48*pm, Ken wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Limit access in a 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 "Ken" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit using pivot table with Access database? | Excel Discussion (Misc queries) | |||
| Pivot table cell limit | Excel Worksheet Functions | |||
| Pivot table text field limit of 255 | Excel Worksheet Functions | |||
| is there a limit to the # of rows in a pivot table? | Excel Discussion (Misc queries) | |||
| Pivot table limit | Excel Worksheet Functions | |||
Linear Mode
