Multi-user editing Office documents at the same time

We have a shared mapped drive on Windows Server in which we need to be able to give multi-user access to some Windows Excel and Word documents. This will enable them to be collaboratively edited at the same time.

What's the simplest approach to achieve this?
LVL 1
edhastedAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
Office 2016 with SharePoint has some ability to collaborate.

Look at this article here for details.

https://support.office.com/en-us/article/document-collaboration-and-co-authoring-ee1509b4-1f6e-401e-b04a-782d26f564a4
edhastedAuthor Commented:
Many thanks to you both, am reading through these articles. Suspect some more questions to follow.
5 Ways Acronis Skyrockets Your Data Protection

Risks to data security are risks to business continuity. Businesses need to know what these risks look like – and where they can turn for help.
Check our newest E-Book and learn how you can differentiate your data protection business with advanced cloud solutions Acronis delivers

David FavorLinux/LXD/WordPress/Hosting SavantCommented:
Depending on data complexity, number of concurrent users, how you resolve multiple people changing same data...

Might be best to setup a WordPress system with normal data table row locking, so every one can read any data.

Then to change data, only one person can lock a row(s) for editing.

Generally you can get away with collaboration for a handful of people working shared assets where it's rare more than one person will ever actually update the document simultaneously.

If you have many users constantly modifying the same docs, likely you'll have to retool your document storage + format.

Tip: For highly parallel data (many constant, simultaneous users) might be best to maintain a raw data format + then generate your Word + Excel output files from your raw data format.

There are many tools to generate docs from raw formats.

https://asciidoctor.org is free, fast (to generate output docs) with most complex output file support.

You can also run LibreOffice in headless mode for many more formats.
Walter CurtisSharePoint AEDCommented:
If you have SharePoint 2013/16 with an office online server set up you will have document co-authoring for documents stored in SharePoint. Just move the files from the file share in to SharePoint.

Good luck...
edhastedAuthor Commented:
Unfortunately it's SBS 2011...
edhastedAuthor Commented:
Hi - I'm concentrating on the Excel solution for starters. Due to the nature of the files the client doesn't want to share them in the Cloud. So we have set up a test XLSX file on a local, restricted shared folder on the SBS 2011 server.

When I try to save it following these notes the "Share Workbook" button doesn't appear on the Review menu. It I add it in manually to the toolbar it then doesn't allow me to share it with other users???

Can anyone elucidate?
JohnBusiness Consultant (Owner)Commented:
From the document I posted above:

Quote  "To co-author with others, you need a shared storage area.  OneDrive, OneDrive for Business, SharePoint Online and SharePoint Server are shared storage areas which enable co-authoring."

I do not think SBS2011 qualifies for co-authoring. That server came well before Office 2016.  So you need the approach of using a shared storage area.
edhastedAuthor Commented:
I am not allowed to save this in the Cloud. Do I have any options then? Very many thanks.
JohnBusiness Consultant (Owner)Commented:
No. You need shared area support, so in your case co-authoring collaboration will not work. Sorry.
edhastedAuthor Commented:
Can I install Sharepoint on SBS 2011, and if yes is it overkill for this task?
JohnBusiness Consultant (Owner)Commented:
You would need to look up SharePoint install documentation to see if that works. I am not certain. It was a separate web-based product in the days of Server 2003 but that was still "cloud" based.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
edhastedAuthor Commented:
Very many thanks again.
edhastedAuthor Commented:
Many thanks for everyone who helped out. As usual the bleedin' obvious requires superior knowledge and am grateful to you all.
JohnBusiness Consultant (Owner)Commented:
You are very welcome and I was happy to help you.
Walter CurtisSharePoint AEDCommented:
Quick Note - SharePoint foundation is a part of SBS 2011.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.