• 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!

Sharing excel documents

original PM

Double Godlike!
Joined
Apr 1, 2008
Messages
12,848
Likes received
2,921
Thanks received
732
Location
Cheshire
Hey Clever peeps.

Is it possible to have multiple users editing an excel document simultaneously

I know it is possible using google docs and it seems O365 also has this capability

But not on excel 2010/2013 etc?

Any ideas?
 
From memory, no. When one user is editing it, is locked.
 
Bad memories.

Yes you can.

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)
 
Yeah I have just found that...

wonder how well it will work!

cheers
 
As well as most MS software.

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.
 
Yeah I have just found that...

wonder how well it will work!

cheers

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!
 
Ok so this is going to be tried (even after I told them about BB's response)

Anyway does anyone know if it works cross version - e.g. excel 2007 v excel 2010 v excel 2013?
 

Advertisers

Back
Top