These things sound great in a room full of IT people, but they demonstrate a very serious lack of understanding of the common user and the organizations that are trying to use the products. Releasing products that have the amazing potential to drive customers to Box, but then putting dumb limitations on these reminds me of the early days of Microsoft when the idea was that the user could just click Control-Alt-E-F7 or some 4 key combination to do a task. How to Move Your Documents Folder Location in Windows 10 By default, Windows stores your personal Documents folder in your accounts UserProfile folder (ex: 'C:UsersBrink'). What is needed from Box is a focus on providing tools for organizations that are not small startups. This does not allow you to move the Box Drive and it can be very confusing for end users (almost as confusing as asking them to create/edit their linked spreadsheets using %userprofile% instead of clicking through folders as they are use to doing. You can, however, use the Microsoft mklink to create a symbolic link to the location needed anywhere on the system. This does not work as Excel will change %userprofile% to the actual location on the machine and the link will not work for another user. I did not test with another user so some additional validation needs to be done to see if this works in a multi-user setting. Skip the update and use the "Data/Edit Links/Update Values" path then point to the source file in your Box Drive path and it will update the values in the cells. Note: When you open the destination file it will complain about being able to find the linked file. The updates I did in the source were reflected in the destination file. Then in the destination file updated the cell values by going to "Data/Edit Links/Update Values". In testing I updated and saved the source file, in this case testlink2.xlsx. Search for OneDrive, and click the top result to open the experience. Making the change to all links can be done using search and replace. Replacing the "Users\username" with "%userprofile%" (i.e. 'C:\%userprofile%\Box\folder\Sheet1'!$B$4) should make the link user agnostic. When you create a link to another excel file in Box drive you end up with a link like 'C:\Users\username\Box\folder\Sheet1'!$B$4. (by default this Default directory is hidden, you need to go Tools >. By default Windows 10 will download all files in the Download folder in C drive but if you want, you can change the download path. I don't know that this is practical on a large scale since it requires some additional steps, but it does seem to work in the limited testing I did. Use Drive for desktop to find your Drive files and folders on your computer with Windows File Explorer or macOS Finder. Copy the original Default profile folder in C:users to the new location. Now, I did some fiddling with links in Excel. To have persistent link in Excel that everyone can use is possible using Box Sync as described in this article. At some point Box may allow changing the location of the Box Drive folder, but for now that is not possible.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |