| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I hide certain data in a spreadsheet for certain users?
I am producing league tables at work and different viewers can see different
things Each user needs to see all of the income for each person on the league table but should only see the names, job titles and locations of their own consultants. To illustrate, the manager of a branch should only be able to see the names of the consultants in their branch but the income for everyone. The regional manager should be able to see the names of everyone in the branches in their region but the income for everyone The area manager should be able to see the names of everyone in the branches in the regions in their area but the income for everyone. Is there a way I can set the spreadsheet up so this happens when people log in, or do I have to save off various different spreadsheets with only the data they should see in there? Thanks in advance for all advice! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I hide certain data in a spreadsheet for certain users?
Claire,
If the data is there, then no amount of protection or effort on your part will prevent a user from seeing it - if they really want to see it. Probably the best approach would be to extract the data each person needs, then send them the workbook with the extracted data. HTH, Bernie MS Excel MVP "ClaireB" wrote in message ... I am producing league tables at work and different viewers can see different things Each user needs to see all of the income for each person on the league table but should only see the names, job titles and locations of their own consultants. To illustrate, the manager of a branch should only be able to see the names of the consultants in their branch but the income for everyone. The regional manager should be able to see the names of everyone in the branches in their region but the income for everyone The area manager should be able to see the names of everyone in the branches in the regions in their area but the income for everyone. Is there a way I can set the spreadsheet up so this happens when people log in, or do I have to save off various different spreadsheets with only the data they should see in there? Thanks in advance for all advice! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I hide a formula in Excel 2007 from other users seeing it | Excel Discussion (Misc queries) | |||
| hide a page and prevent outside users from viewing it. | Excel Discussion (Misc queries) | |||
| How do I hide spreadsheet range from data entry? | Excel Worksheet Functions | |||
| Protection in Excel - how do i hide some info. from some users? | Excel Discussion (Misc queries) | |||
| is it possible to Hide certain worksheets from certain users? | Excel Discussion (Misc queries) | |||
Linear Mode
