Box Status

can I use excel's external-link with Box?

Follow
New post
laj aaa

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?

0

Comments

2 comments

Date Votes
  • France

    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,
    0
    Comment actions Permalink
  • laj aaa

    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...

    0
    Comment actions Permalink

Please sign in to leave a comment.