Suggestions for Excel security?

[OldManExcellor]

I've developed a "MasterDataFile" that has a lot of company data. The file contains a "MasterData" Excel-table. Only management should be able to see the entire contents of this file.

Based on this file I am building reports for management and individual employees.

Individual employees should be able to see and update their reports, but they should not be able to see the full contents of the MasterDataFile. The individual employees can work at any computer, they don't have personal logins and the company has a server.

Can you give some ideas to what you think would be a good security solution for this?

[LJMetzger]

Excel is probably not the application to use if you need security.

My suggestion is to have VBA code that takes the Master File and makes two copies:
a. For management only
b. For others

The management copy should be in a folder that only management has access to, or in a file where only management has access rights.

Lewis

[Xx7]

If you password protect an Excel file, be aware that anyone can simply crack the password with 3rd party software. So, ensure that the management file is in a very secure location that employees do not have access to.

[russc2541]

I would also advocate the use of multiple files and securing the location. Excel's security is kind of like a 4' wood fence around your property...anyone that REALLY wants just hops over.

I don't have to worry as much about security as people poking around and messing things up so I have a master xlsb file while everyone else either gets reports generated by it or gets to see a macro-free xlsx.