Linking Excel sheets with formulas or links

Follow

New post

Amy Beard

• July 11, 2023 08:45

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

1

• 

  Ivy Sandberg

  • November 30, 2023 21:38

  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! 

  0

  Comment actions Permalink

Please sign in to leave a comment.