I'm trying to have a cell in an Excel file (let's call it File A) that is linked to a list of numbers in a second Excel file (File B). They are both saved in a Box folder. The goal is that anyone with access to File A can refresh its links to get the latest numbers (which are in File B). The problem is that the file path shows the location of the Box Drive in my computer, not the "cloud" where the file is. So other people are not being able to refresh the links. How can I fix it so that the file path does not direct to my computer, but to the Box where it's saved?
Question
Excel link reference to file in Box
Hi there,
Welcome to Box Community and glad to help!
You may reach out to your internal helpdesk team to assist you address this inquiry.
Thanks for posting!
We are using Box Drive and linking excel files. Sometimes the file links change from desktop C: reference to this weird api reference. Then the files no longer synch when another user opens it up. Is there a setting we need to enable in Excel?
='https://api.box.com/wopi/files/ [removed by moderator] /WOPIServiceId_TP_BOX_2/WOPIUserId_-/[Nov Update v4.xlsx]Cash by Month'!AV24
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.