Hi Everyone,
I am here to ask you for your advice on refreshing data between multiple Workbooks.
See, I have a Source Workbook which includes a list of all our clients. There is one of my employees responsible for each client.
The Table in Source Workbook looks like this:
| Client name | Employee Name |
| Client1 | Employee1 |
| Client2 | Employee1 |
| Client3 | Employee2 |
| Client4 | Employee3 |
| Client5 | Employee1 |
| Client6 | Employee3 |
| Client7 | Employee2 |
| Client8 | Employee3 |
I have created a separate Workbook for each employee. Using FILTER Function, I was able to create a table containing only the clients of the concrete employee. Thanks to the FILTER Function, the table is able to refresh itself when a change in Source Workbook happens.
The problem is that my employees only have Excel Online / Excel for Web (not the PC App). Because of this, the FILTER function cannot even load the data from the Source Worksheet.
Do you have any idea how to solve this problem? I was thinking about Power Query, but I am not sure if this would work. Moreover, the Source Workbook (and Employee Workbooks) are stored on SharePoint. As far as I know, Power Query does not work well with cloud stored documents.
Please help.
