Forum Discussion
Two way sync on Microsoft 365 excel sheets between two excel documents
Hi, I had a question how do you create a two-way sync between two separate Microsoft 365 excel sheet documents in such a way that you can edit them both and they will reflect the changes made?
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.
- hi@mathetes fastly thanks for your reply, to answer your question why are there two spreadsheets designed the same way. Is that the fast spreadsheet let's call it LUCY is in the master file and the second one is an exact replica of lucy and we will call it lucy2, the reason for the duplication is because when I share lucy in the master file she will be able to see all the other documents in the master file and this are sensitive documents and each document contains details of a different person who works on it so to ensure she doesn't see I created a separate sheet called lucy2 and linked to lucy in the master file this way if I share lucy2 she will only see lucy2 and not lucy in the master file plus other sheets within the master file, that's why I needed a two-way sync between the two so that when I edit lucy in the master file the changes will be reflected on lucy2 and if she updates lucy2 the changes will reflect in the sheet called lucy in the master file.
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 helpDid you find any solution to this?
I have same requirement and struggling hard to get this done
