Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-02-2017, 06:46 AM
econley econley is offline File Syncing in Dropbox Windows 8 File Syncing in Dropbox Office 2016
Novice
File Syncing in Dropbox
 
Join Date: May 2017
Posts: 1
econley is on a distinguished road
Arrow File Syncing in Dropbox

Within our company we use a number of Excel workbooks that link to other Excel workbooks with VLOOKUP.

We use Dropbox and have run into issues when opening the same file on different computers - the files being linked to the file return with "#VALUE!" in each cell. With all of the services we have tested the file path for files is different for every machine. For example the same folder on two different machines would have file locations as below:



Machine 1 Dropbox = C:[machine 1]\Dropbox\Excel Folder\Excel File

Machine 2 Dropbox = C:[machine 2]\Dropbox\Excel Folder\Excel File

When this happens you have to choose the source for the links every single time you open the file from a different machine. If you create a file with links to other files on machine 1 and then move to machine 2, machine 2 no knows where the files with 'machine 1' in the path as stored. This is a huge barrier for us using this kind of storage as every user would have to change each file each time they open it.

I understand why this happens, but is there a way to get around this and have files link together in such a way that the links are relative rather than absolute.

We are using Office 2016.
Reply With Quote
Reply

Tags
dropbox

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dropbox menu to set formulas AcerExcel Excel 2 12-07-2016 07:08 PM
File Syncing in Dropbox OneDrive for Business only syncing one file at a time. Beikos Office 1 08-15-2016 03:03 AM
File Syncing in Dropbox Video won't play in PowerPoint (Dropbox) wmth99 PowerPoint 4 12-23-2015 10:10 AM
File Syncing in Dropbox how to sync all keyboard shortcuts via dropbox? dylansmith Word 10 12-03-2012 03:20 AM
Can I put my local outlook folder on Dropbox? MickeyS Outlook 3 07-30-2012 10:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft