We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Excel 2007 Protecting Data From Being Viewed

Escanaba
Escanaba asked
on
Medium Priority
235 Views
Last Modified: 2012-05-11
Hello,

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.

Thanks!
Comment
Watch Question

Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Finance Analyst
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
EscanabaManager - HR Analytics

Author

Commented:
Thanks to all for your suggestions.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.