Can anyone recommend options on how to protect a sheet of data from being viewed by anyone except a central admin that is more secure than just hiding the sheets in the advanced settings? For example, I have a sheet that will contain sensitive data for multiple departments and within the report there are dynamic charts that will allow comparisons between departments on specific factors. I cannot have the end-users look at the raw data tab and see everything so I need to find a way to protect it while at the same time allowing pivot tables that are feeding my charts to use the data.
Any suggestions? VBA coding is an option if anyone has ideas.