Multiple users refreshing pivot in same file accessing external datasource

%3CLINGO-SUB%20id%3D%22lingo-sub-1725031%22%20slang%3D%22en-US%22%3EMultiple%20users%20refreshing%20pivot%20in%20same%20file%20accessing%20external%20datasource%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1725031%22%20slang%3D%22en-US%22%3EOffice%20365%3CBR%20%2F%3E%3CBR%20%2F%3EHow%20can%20multiple%20users%20access%20the%20same%20excel%20document%20which%20requires%20a%20data%20refresh%20from%20an%20external%20data%20source%20(excel%20file%20with%20summarised%20data)%20for%20pivots.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20one%20user%20refreshes%2C%20it%20no%20longer%20allows%20anyone%20else%20to%20refresh%20from%20the%20datasource.%20Almost%20like%20it's%20locking%20the%20datasource%20from%20being%20accessed%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1725031%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor
Office 365

How can multiple users access the same excel document which requires a data refresh from an external data source (excel file with summarised data) for pivots.

If one user refreshes, it no longer allows anyone else to refresh from the datasource. Almost like it's locking the datasource from being accessed
0 Replies