Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Go to Review, click on Share Workbook, first option on the Editing tab is “Allow changes by more than one user at the same time. This also allows workbook merging”
Works in Excel 2010 & 2013 (that’s all I have available to check right now)
I think the main problem is that we seem to want 30+ people to be able to amend/update this spreadsheet - and I think it is just not going to work - people will be overwriting other peoples work etc etc...
Sharing a workbook is the worst way to allow multiple sheet updates. It will corrupt, be locked out, have the same record overwritten multiple times, etc etc
What's the requirement that leads you think this is needed? Usually happens when a client thinks a spreadsheet is a viable alternative to a basic database - you could set up something simple in Access and have a much better result.
Simple answer is it doesn't - you'll end up with a corrupt spreadsheet and lost data! I worked at a place where one team did this a lot and they were constantly losing their data. It's a crock!