Shared excel - multiple users

[benwork]

Hi all,

I'm looking to solve a work issue by having a shared workbook which will be saved on a shared network drive and I have a few questions around it. I'm doing a sanity check before I allocate time to build this thing.

There will be about 5-10 people editing the spreadsheet and probably about the same time of the day (all within about 15 minutes)
They will only be comments (based on each areas performance) entered into a specific cell so there really isn't any complexity to the spreadsheet, other than it being shared and used by multiple users.

Is this suitable for my needs?

What type of issues will I encounter?

Is there an better method and why?

Really appreciate the assistance

Thanks in advanced

Ben

 

[GWteB]

Simultaneously working on a shared workbook should not cause any problems as long as everyone has their own worksheet and good agreements are made (and everyone adheres to it). The moment the workbook is saved by a user Excel will ask for a decision the moment Excel encounters differences in equal data areas. This may cause confusion for users when working on the same worksheet.

 

[JumboCactuar]

If you need to all work the same file at the same time
OneDrive/SharePoint is best for this as it allows co authoring