Link to home
Start Free TrialLog in
Avatar of agwalsh
agwalsh

asked on

Using Windows security rather than password protecting Excel files for ease of use...

I  have a scenario where a director is going to be viewing summarized data in an Excel workbook from 3-4 other password protected workbooks. I assume s/he will not be able to do that without opening the other files....assuming s/he wants to see the most recent data. What would you recommend? I'm considering recommending that they set up a special group for that drive so that those people in that group can freely access all data within that drive (note the formulas etc will be locked down in the file) but that people outside it can't. Any suggestions? Thanks
ASKER CERTIFIED SOLUTION
Avatar of Alan
Alan
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If the viewers do not need to amend  the data then what about a dynamic image of the data?

Data is on a hidden sheet and amendments to the data will reflect in the image automatically.
agwalsh.xlsx
Avatar of agwalsh
agwalsh

ASKER

The viewers do need to input the data for let's say 4 centres in 4 different locations. The director wants to see a summary file of all four locations - s/he only really wants to see the summaries. Each of the sheets will only be open for data entry in specific areas. Everything else is locked down. So a user can view the summary data for his/her centre but the director will have another file pulling the desired stats from all 4 centres. I plan to use tables in the files so even if extra people etc are added in the formulas will be dynamic.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Splitting points and closing question.

If there are any further queries, please do post back, or start a new question, and I'm happy to (try to) help further.