I apologize if this is covered elsewhere. I searched, but could not find a good solution.
Our company uses DropBox to sync and share folders between employees. We store Excel workbooks in these folders. We are having issues when using formulas in one workbook that link to data in another workbook in the same folder. Let's say User1 creates the formula and User2 opens the workbook, the links cannot update as the links are looking for User1's specific file path. As of now, DropBox is stored in each users folder in Windows, so the file path is currently unique to each employee. (We all run on different computers so do not confuse Users with logins on the same machine.)
I need a solid solution as stopping use of DropBox and links between workbooks is not viable. We are running a combination of Windows 7 and 8 and the most current version of Excel (Office 365). Here are options I've seen mentioned:
I'm not an IT guy, just an above average user. I know a little about this stuff but not enough to identify or implement the best solution.
Can anyone weigh in on the most solid future proof solution that will work as we add employees and are creating new file and workbooks on a daily basis? Once I have identified the best option I can work with my IT guy to implement. Thanks in advance!
Our company uses DropBox to sync and share folders between employees. We store Excel workbooks in these folders. We are having issues when using formulas in one workbook that link to data in another workbook in the same folder. Let's say User1 creates the formula and User2 opens the workbook, the links cannot update as the links are looking for User1's specific file path. As of now, DropBox is stored in each users folder in Windows, so the file path is currently unique to each employee. (We all run on different computers so do not confuse Users with logins on the same machine.)
I need a solid solution as stopping use of DropBox and links between workbooks is not viable. We are running a combination of Windows 7 and 8 and the most current version of Excel (Office 365). Here are options I've seen mentioned:
- System or environmental variables in Windows to create a shortcut for each user's specific file path
- Symlinks
- Some type of VBA script to update
- Storing DropBox in the root directory of each computer to standardize the file paths
I'm not an IT guy, just an above average user. I know a little about this stuff but not enough to identify or implement the best solution.
Can anyone weigh in on the most solid future proof solution that will work as we add employees and are creating new file and workbooks on a daily basis? Once I have identified the best option I can work with my IT guy to implement. Thanks in advance!
