Home

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
FabioW
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

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies