Hey guys!!
I have a centralized workbook which I edit once in the morning and it needs to be accessed(and edited) by my team regularly. The size of the workbook is quite big, with around ~30k rows, with ~15 columns of data. Each person will have their own designated rows to edit, so the question of conflicts isn't there.
I have shared the workbook, kept it in a network drive so that they could access it, but the issue is, whenever someone is trying to edit it and save it, someone else tries to access it and it freezes and takes a LOT of time..
Access database is NOT an option, as having access on all my team member's system is costly.
What, am thinking is..having the workbook only editable by me, once I edit it , I will send out the cached copies of it to my team, which they can edit on their local systems and at the end of the day, send it back to me. I collate all the workbooks, merge it onto the master copy I have.
Is this solution feasible? How to merge different copies of the workbook into the master workbook so that it has the data from all the individual copies?
Or is there any better, simpler idea which you guys can tell me??
Please contribute!! waiting anxiously
P.S: Sorry for the long post, I just tried to be as descriptive as possible.
I have a centralized workbook which I edit once in the morning and it needs to be accessed(and edited) by my team regularly. The size of the workbook is quite big, with around ~30k rows, with ~15 columns of data. Each person will have their own designated rows to edit, so the question of conflicts isn't there.
I have shared the workbook, kept it in a network drive so that they could access it, but the issue is, whenever someone is trying to edit it and save it, someone else tries to access it and it freezes and takes a LOT of time..
Access database is NOT an option, as having access on all my team member's system is costly.
What, am thinking is..having the workbook only editable by me, once I edit it , I will send out the cached copies of it to my team, which they can edit on their local systems and at the end of the day, send it back to me. I collate all the workbooks, merge it onto the master copy I have.
Is this solution feasible? How to merge different copies of the workbook into the master workbook so that it has the data from all the individual copies?
Or is there any better, simpler idea which you guys can tell me??
Please contribute!! waiting anxiously
P.S: Sorry for the long post, I just tried to be as descriptive as possible.
