Allow Excel Formulas to Link Directly to Files on Box
Currently, when you open Excel on Desktop, it creates a temporary file on your own computer. When trying to connect one report to another through formulas, this results in the formula looking for the report on your desktop instead of the location the report is saved on Box. In order for the formula to update properly, you need to have both reports open at the same time.
![](https://secure.gravatar.com/avatar/8c6f2b994419a817a4e505e5b9b06b9c?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Anonymous commented
Would it be possible to have the Excel file link point to the Box fileID rather than a location?
-
Anonymous commented
Could there be a collaboration between Box and Microsoft so that the linked excel files point to the file ID in Box rather than a UNC path? If that could work, then it would also work in Excel Online and not just Office Desktop files through Box Drive.