ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   user-level access to pivot table (https://www.excelbanter.com/excel-programming/363930-user-level-access-pivot-table.html)

[email protected]

user-level access to pivot table
 
A pivot table consists of COLUMN, ROW, DATA and PAGE. I have dropped a
field called Department in the PAGE section. Can I give userlevel
access to only that dropdown box?

For example I have around 15 departments in the pivot table. If windows
user maxim logs in, he should be allowed to select all departments from
that dropdown box but if somebody else logs in (any other windows user
besides maxim), that person can access only two departments.


[email protected]

user-level access to pivot table
 
Any ideas ???



All times are GMT +1. The time now is 03:13 AM.

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