External references between Excel files saved in Box by URL.
In Excel saved in SharePoint, the URL can be used to refer to the value of a cell in the other Excel file.
We would like a similar functionality in Box.
For example, if the file ID is "1234567890" and we want to refer to cell A1 of "sheet1", do the following.
ex) ='https://****.ent.box.com/file/1234567890[sheet1]'!A1
This feature is currently available for customers on Microsoft's Current Channel and Monthly Enterprise Channel. More information here: https://support.box.com/hc/articles/29341162504723-Box-for-Microsoft-Office-co-authoring-linked-worksheets-support-in-Excel-now-available
-
Anonymous commented
I would like to second this. We make a lot of use of the "Add a Place" feature to collaborate on Office Documents in Box Drive. When you link to another spreadsheet, it looks like it is trying to connect using an API URL, but the links break. Support said that "Add a place" does not support spreadsheet linking, but it looks like it could potentially work.
-
Anonymous commented
Related, but linked spreadsheets should work even when using the "add a place" feature with box.