Getting data from a password protected file

[FabioW]

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.

[#2]

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