I have an excel file that is essentially a data dump. Then, there are multiple files/users that acess the data via pivot table (external data source.)
The issue is if one person is refreshing their pivot table/excel file (or they have their file left open after refreshing) and another person happens to want to do the same thing, excel won't let the second person access the data file.
I've tried making the source data file as Shared but that didn't work.
Is there another way to allow more than one user to access the source data file at the same time?
Thanks.