Hi Team,
I have a master excel with Individual sales revenue numbers which are updated weekly. I have created multiple excel workbooks with individuals' names that have data querying from the master file. I have only shared their individual files (through one drive) with them with the expectation that when I update the same in master. They will be able to refresh and get the updated numbers.
Challenges #
1# Sales Users are unable to refresh the file and see the changes at their end. When I update the masterfile.
2# Is it because I need to share the source file also with them which I really don't want to do.
3# Any alternative way of doing the task?
I have a master excel with Individual sales revenue numbers which are updated weekly. I have created multiple excel workbooks with individuals' names that have data querying from the master file. I have only shared their individual files (through one drive) with them with the expectation that when I update the same in master. They will be able to refresh and get the updated numbers.
Challenges #
1# Sales Users are unable to refresh the file and see the changes at their end. When I update the masterfile.
2# Is it because I need to share the source file also with them which I really don't want to do.
3# Any alternative way of doing the task?