Getting data from a password protected file

%3CLINGO-SUB%20id%3D%22lingo-sub-870141%22%20slang%3D%22en-US%22%3EGetting%20data%20from%20a%20password%20protected%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-870141%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20was%20trying%20to%20make%20a%20timesheet%20system%20for%20few%20employees%20and%20the%20boss.%20I%20was%20thinking%20to%20make%20one%20%C2%ABoverview%C2%BB%20file%20that%20is%20picking%20up%20data%20from%20every%20single%20file%20that%20each%20of%20employees%20have%20(one%20employee%20%3D%20one%20file%20with%20his%20own%20hours).%20Timesheets%20files%20are%20suppoust%20to%20be%20placed%20in%20one%20folder%20on%20OneDrive%20and%20employees%20should%20not%20be%20able%20to%20read%20each%20others%20timesheets.%20So%20I%20thougth%20to%20protect%20them%20with%20password.%20But%20there%20is%20a%20problem.%20Every%20time%20I%20would%20like%20to%20check%20hours%20in%20%C2%ABoverview%C2%BB%20file%2C%20I%20would%20have%20to%20give%20passwords%20to%20every%20single%20file%20(employee%20timesheet).%3CBR%20%2F%3EIs%20there%20a%20different%20way%20to%20do%20it%3F%20Employees%20can%20not%20read%20each%20other%20hours%2C%20and%20to%20have%20one%20master%20%C2%ABoverview%C2%BB%20sheet.%3CBR%20%2F%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-870141%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-871819%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20data%20from%20a%20password%20protected%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-871819%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F413552%22%20target%3D%22_blank%22%3E%40FabioW%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOne%20option%20could%20be%20to%20set%20up%20a%20folder%20for%20each%20user%20and%20give%20them%20individual%20access%20to%20those%20folders%20then%20have%20an%20overview%20folder%20that%20you%20have%20access%20to%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUse%20Power%20Query%20in%20Excel%20to%20pull%20the%20data%20from%20the%20files%20in%20the%20folders%20into%20the%20overview%20folder%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENot%20ideal%20for%20Excel%20to%20do%20that%20sort%20of%20thing%20but%20that's%20one%20way%20to%20approach%20it%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi,

I was trying to make a timesheet system for few employees and the boss. I was thinking to make one «overview» file that is picking up data from every single file that each of employees have (one employee = one file with his own hours). Timesheets files are suppoust to be placed in one folder on OneDrive and employees should not be able to read each others timesheets. So I thougth to protect them with password. But there is a problem. Every time I would like to check hours in «overview» file, I would have to give passwords to every single file (employee timesheet).
Is there a different way to do it? Employees can not read each other hours, and to have one master «overview» sheet.
Thanks in advance.

1 Reply
Highlighted

Hi @FabioW 

 

One option could be to set up a folder for each user and give them individual access to those folders then have an overview folder that you have access to

 

Use Power Query in Excel to pull the data from the files in the folders into the overview folder

 

Not ideal for Excel to do that sort of thing but that's one way to approach it