Hello,
I have several files that does a power query from a master data excel file. I am running into issues where whenever I try to make updates to the master data file I get the error message "someone else is working in...". I noticed I have to close every file that is doing a power query from this file. Is there a workaround for this? Since my whole team is always opening up different files I have to message them to close it every time I want to make an update.
I have several files that does a power query from a master data excel file. I am running into issues where whenever I try to make updates to the master data file I get the error message "someone else is working in...". I noticed I have to close every file that is doing a power query from this file. Is there a workaround for this? Since my whole team is always opening up different files I have to message them to close it every time I want to make an update.
