Forum Discussion
Two way sync on Microsoft 365 excel sheets between two excel documents
Could you accept a question or two in response to your question? The request itself raises questions, foremost among them--whether or not it's possible to do what you're asking (I'm not at all sure it is)--is WHY would you want to do this "two-way synch" in the first place?
So perhaps you could do us all a favor and explain the bigger picture: why are there two (each presumably designed and laid out in the same way as the other) sheets; why two instead of just one? What is the relationship between the two--different people maintaining them? Why still do they need two, why not just a single spreadsheet with two (or more) folks maintaining it?
A big part of why I'm asking is the need to maintain data integrity--any time you've got duplication, two databases containing a lot of the same data for example (e.g., a payroll database and a separate HR database), despite the best efforts to synch changes both ways, things get out of whack. It's far better to have a single underlying (master) dataset where changes can be made by various responsible people, but they're all working with the same dataset. So my question is not a spurious one.....which doesn't deny there may be a need for what you're asking, but it's a question I would ask were we sitting down face-to-face, so since we're not I'm asking it here.
what is the relationship between the two persons sharing this document, well the one editing the master file is the HR, and Lucy is a support staff in the company.
so if you know a way we can do a 2-way sync please assist because am stack I only linked one way from lucy2 to lucy in the master file using the copy and paste link method, so what lucy2 does is reflect on lucy in the Masterfile but i cant edit lucy in the master and what i do is neither reflecting in the linked lucy2 spreadsheet. kindly help
Did you find any solution to this?
I have same requirement and struggling hard to get this done
dattatathele same here!!!
Let me invite you to read thoroughly this description and set of instructions regarding password protection in Excel. It seems to me that you should be able to grant (or withhold) various levels of access to each spreadsheet in your master workbook, such that individuals "LUCY2" and "MAX3" and "FRANK4" can see and modify only their own sheets.
So rather than synching back and forth, you're just controlling who can do what, who can see what...From a data-integrity point of view, that would be preferable to begin with.
