I'm using Excel 2019, when refresh power pivot with external excel sheet data source being occupied by other user in local network, Excel gets freeze everytime. I used to use Access with linked excel files, when the excel file is being opend by other user, Access will open a copy and continue its job. Does there any possible for pp to do the job?