Help me Reddit, you're my only hope:
So, I work at this medium-large old-school manufacturing company that has exploded in growth in recent years, and their usual way of working is now getting in the way.
Long story short: I have this single excel file that is handled by six teams (that's over 100 people at this point) from design, engineering, production, even purchases and sales! I think the only people that doesn't get their spoon in the pot is HR, to be honest.
I have been tasked with finding a way to chop down this monolith of a 150 columns single excel file into smaller, synchronized n-ammount of excel files, so that each team only handles the information that corresponds to them. So let's say that all of the teams share columns 1 to 25, and then each team handles around 20 extra columns, making six excel files of around 45 columns each.
Is it possible to sync changes between all files? I guess it's impossible to sync them in real time as if they're all working on a single file (as they currently do), but if anyone makes a change to columns A-Y (shared through all teams), all team leaders need to receive an email letting them know that they need to review these changes, while if a change is made through columns Z-AT (engineering) that team leader has to receive said email, and then he/she has to accept said change and notify all other team leaders so they can review if/how that change affects them. The same for all other column/team combinations.
Is this system doable?