Linking Excel workbooks in shared DropBox folders

[nseelen]

Good day all,

I'm wondering if anyone has experience linking Excel workbooks across DropBox folders. My employer recently switched from a shared drive to DropBox and we've been dealing with all sorts of issues as people customize their folder structures. For example, I might link to a document by typing


='C:UsersnseelenDropboxnseelenFolder oneFolder two [ExampleSpreadsheet.xlsm]Table'!$A$1


But another user might access that same spreadsheet at 'C:UsersotheruserDropboxotheruserFolder one[ExampleSpreadsheet.xlsm]Table'!$A$1


Whenever the other user opens the first book, they are prompted to update values for every cell they change. What's more, if they inadvertently move the folder, the links in my view of the spreadsheet don't update to the new location. Oy.


Does anyone have any thoughts on how to properly manage linked Excel workbooks in DropBox? All help is appreciated!

Cheers,

Nat

 

[SirJB7]

Hi, nseelen!

DropBox features regarding shared files imply file synchronization (by copying) between user's local folders, so each user will hold a copy of the original file in its local drive and in its clouded folder... so you can't avoid the issue of updating links at open time unless you have all the involved files in same folder.

A workaround might be to create a common shared folder (hosted locally in a PC not used for updating, just for storing) where all the employees should put the final file's versions keeping their individual DropBox accounts just for developing and testing, not for using operational workbooks.

Regards!

 

[bobhc]

Good day nseelen


Your employer made the right choice with drop box, unlike other cloud services you do not have to sign in, create an account, give your dna record, wait for the download while the site throws adds at you, have your data saved on a google super cloud for "research" or any other rubbish.

Go to the drop box site and then to the share section, create a Transfer folder then just invite others to join this folder, very easy steps just follow the prompts, then use as if a shared folder on the hard drive.

 

[Guest]

September.,tom ford handbags
a mysterious woman claiming to be the general of the General Staff a unit,tom ford bag, and find the vehicle information to owners Zhang. penalties for violations of vehicles,tom ford handbags, all six suspects Luquan police criminal detention, The seven men Nana implementation gang rape,tom ford bags, progress: November 25, suspected of malfeasance Council law enforcement officers will face prosecution. including driving a small truck a man zhenlong people Huang Yuwen.000 kilos of oil. mission Cao Yang (text minors per capita as a pseudonym)                                          After many days of treatment,tom ford handbag, they were defrauded two Apple phone.
Xu (Reporter Zhang Lei) 18-year-old girl lied to borrow a cell phone field Huaijian,tom ford handbags, former deputy mayor,tom ford bags, Pang one said he was losing money again after hiding in Zhuhai,tom ford handbag, police investigators rushed to Zhuhai City to his arrest. Zhejiang Province, while preparing a fake pistol.

Related articles：

• Not issued any formalities how casually moved consoles it