How can I use Excel's external-link function (referring to data in another Excel file) effectively when multiple people are using BoxDrive in a company?
When using BoxDrive only, Excel's external-link function works fine with "relative reference" to specify the file location.
However, when we open the excel file from the browser Box, the external-link is overwritten with "absolute reference" and cannot be used by multiple users.
Is this overwriting a specification of the browser Box?
Question
can I use excel's external-link with Box?
Hi there,
Welcome to the Box Community!
Have you checked out this support article on Configuring the Default Box Drive Folder Location?
This article discusses resolving issues around file-to-file linking via absolute paths as seen in many popular apps such as Excel, Word, InDesign, and so on. Relative file path links should work regardless of the Box Drive folder location.
This may be relevant to your problem with the next steps!
Best,
Hi France,
Thank you for the information, but unfortunately it doesn't solve my problem.
For security reasons, our company can't change settings of default folder location
Furthermore both BoxDrive and WebBox(browserBox) require continuous use....I hope we could use only BoxDrive and restrict using WebBox...
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.