I have an excel workbook containing a table that is linked to numerous Data Source files via PowerQuery. There is a high likelihood that the a user will be in the Data Source files updating them. Is it possible for me to refresh my table using powerquery whilst the Data Source Files are open by another user. I keep getting the message:
[DataSource.Error] The process cannot access the file '......' because it is being used by another process.
Filter out files with a name starting with "~".