Linking Excel sheets with formulas or links
I have multiple spreadsheets with data in that link or reference each other. These links have periodically broken when it has just been me working on them. I now have a new starter who is going into the same sheets and updating them- whenever the other one of us goes into the sheet the other has updated none of the formulas or links work as they seem to be referencing a file that is on the others local drive. How can we get this to work. I have raised it with the chat support but they don't seem to understand what I am asking
-
I have the same issue. I access my sheets via Box Drive and define formulas that link to other sheets, also located in Box, but because those formulas use my local path, they don't work when accessed by one of my team members. Hoping someone has a solution to this or a workaround!
Vous devez vous connecter pour laisser un commentaire.
Commentaires
1 commentaire