sharing excel files on drop box with non dropbox or team members how to not get a conflicted copy

[ambern1023]

I have a microsoft form that updates to an excel workbook sheet then i need to have sync to a MASTER sheet that has previous notes from (before i started the form) and need to have formulas/macros/vba/power query i have no clue what in place to keep them updated simultaniously till the formulas and code are in place due to it being edited daily

i need the excel microsoft forms responses(has to be saved on dropbox to update live) to then sync to a shared excel workbook saved in dropbox (or a master protected copy first thats not shared, then shared from the master to the editable full 2023 data etc) 

*I need the master bc this has gotten screwed up before/ data loss/ etc i have to have a protected copy that can receive new rows that get added from the form or you need a password to change it

and then have the master share it to a Working field notes sheet in same workbook or a seperate workbook

I need this done immeditely and have 0 forumulas and functions knowledge 

it must expand in every sheet with formulas expanding

HOW DO I DO THIS? or MINIMALLY link the form response sheets to the working field notes sheet in a seperate note book so that the formula expands as lines are added. I NEED THIS PART BEFORE END OF BUSINESS TODAY

I ALSO need to ensure conflicted copies wont be created when diff people open work book etc (Can i make it so only 1 person can be on the working field notes at a time? *this is why the protected master is the most important!)

puuhhlease help me!

[Hannah]

Hey @ambern1023, thanks for your post.

Regarding the conflicted copies part, there are a couple of options for you.

You can use the Dropbox badge or since you're on a Dropbox Business team, you can also use our file locking feature.

As for the rest, I believe it's more on the Microsoft side, rather than the Dropbox side; Dropbox's job is to sync any changes you make to your files with your account online and other devices.

You could reach out to Microsoft for more info and I will also leave the thread open here, so that other users with a similar setup, can help you out.

Let me know if you have any questions.