Hi Everyone,
A great forum and some really good help in times of need. Thank you to you all.
I have a question and am not sure if this is possible. I have a pivot table which i want to be able to secure based on the a filter. So for example
I have filters as follows
Language
English
Dutch
Spanish
Italian
Greek
French
These filters are selected by each member of our team and then can view associated figures to the language. What i want to do is lock the data down so only users who need English Data can view English data, only Spanish users can access Spanish data etc.
Is there any way which could work where when a filter is selected it prompts for a password for that Language and a master password which unlocks all data.
Not sure if I am having a blonde moment so do excuse the ignorance, but is it possible even to set password of the filter at a Windows NT level, for example. I know the list of users who need access to English only data and want to restrict them only to English data in the Pivot based on NT credentials, is this something which is possible.
Any guidance on this would be a great help, thank you to you all.
Tania
A great forum and some really good help in times of need. Thank you to you all.
I have a question and am not sure if this is possible. I have a pivot table which i want to be able to secure based on the a filter. So for example
I have filters as follows
Language
English
Dutch
Spanish
Italian
Greek
French
These filters are selected by each member of our team and then can view associated figures to the language. What i want to do is lock the data down so only users who need English Data can view English data, only Spanish users can access Spanish data etc.
Is there any way which could work where when a filter is selected it prompts for a password for that Language and a master password which unlocks all data.
Not sure if I am having a blonde moment so do excuse the ignorance, but is it possible even to set password of the filter at a Windows NT level, for example. I know the list of users who need access to English only data and want to restrict them only to English data in the Pivot based on NT credentials, is this something which is possible.
Any guidance on this would be a great help, thank you to you all.
Tania