Linking Excel sheets with formulas or links

フォローする

新規投稿

Amy Beard

• 2023年07月11日 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

  • 2023年11月30日 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

  コメントアクション パーマリンク

サインインしてコメントを残してください。