have a pc desktop shortcut of excel sheet sync in real time to drobox original version

[ambern1023]

my worker updates a copy of a sheet on excel that is done daily and is avaialble offline he like it to have a desktop shortcut to click it easily

he has another file that does this already how do i do it with this file 

we made changes to the doc and it did not update on the copy in my dropbox account

how do we fix this so i can see his edits in real time

[Mark]

He needs to be editing the file in the actual Dropbox folder on his machine. 

So he needs to have the software running and update the shortcuts to the one inside Dropbox

[ambern1023]

If we make edits to a “copy” of the document (editing and testing formulas on exact replica of original ) and then when done with edits can we rename the copy I was working on to the file name they were working & put it back into same dropbox folder as originals plus new updates and lines on it ?will it still keep all formulas and everything in tact ?

[Jay]

Hi @ambern1023, it depends on how the formulas were created originally, and what type they are. 

In Microsoft Excel, you can create links in a workbook to another workbook or file on your computer using a formula that references an external location. When this link is created, it points to a location on your own hard drive.

When your workbook is downloaded onto another's computer, the locations that your formula points to are no longer there. The link in the workbook is looking for a specific place, for example /Your_Computer/Your_User/File, and that location is no longer accessible from a different computer.

[ambern1023]

so how do i keep an updated copy resaving as the same name when updates are made by various people without loosing formulas etc

[Jay]

Given your current setup, I'm not sure how this can be accomplished. 

If they instead had the file in their own Dropbox accounts, and updated the file from there, the changes would sync to everyone's accounts