How to make excel shareable and updatable by multiple users

I have a huge excel file with around 200,000 rows and l15 rows. This is accessed by 5 users at the same time. Each had its own set of rows to update - mutually exclusive. But each should see the updates made on all the rows - has read access. How can the updates be seen on the fly? Thanks

Honestly, probably not with Excel - it's not really designed for this.

There may be some mileage having a look at co-authoring (https://support.office.com/en-gb/art...b-3024e46fb104) if you're actually using 365 and not 2007 as your profile suggests. If you are using 2007, you want to be looking for a solution outside Excel