Forum Discussion
Getting data from a password protected file
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...
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