Hello, I really need help with this.
I have an excel file which has an information from other files, and for example if I have both files open there are no problem only if at the begining I open the master file first and then I open the secondary file, If I change the information from the master the other file gets automatically update the information from the master. BUT if I open first the second file and then the master here is the problem because if I make changes on master the other file return #ref on the fields, so what can I do?.