Avatar of edhasted
edhasted
Flag for United Kingdom of Great Britain and Northern Ireland asked on

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?
Microsoft SharePointWindows OSMicrosoft Word

Avatar of undefined
Last Comment
Walter Curtis

8/22/2022 - Mon
John

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
DevAdmin

edhasted

ASKER
Many thanks to you both, am reading through these articles. Suspect some more questions to follow.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
David Favor

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 Curtis

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...
edhasted

ASKER
Unfortunately it's SBS 2011...
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
edhasted

ASKER
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?
John

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.
edhasted

ASKER
I am not allowed to save this in the Cloud. Do I have any options then? Very many thanks.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
John

No. You need shared area support, so in your case co-authoring collaboration will not work. Sorry.
edhasted

ASKER
Can I install Sharepoint on SBS 2011, and if yes is it overkill for this task?
ASKER CERTIFIED SOLUTION
John

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
edhasted

ASKER
Very many thanks again.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
edhasted

ASKER
Many thanks for everyone who helped out. As usual the bleedin' obvious requires superior knowledge and am grateful to you all.
John

You are very welcome and I was happy to help you.
Walter Curtis

Quick Note - SharePoint foundation is a part of SBS 2011.
Your help has saved me hundreds of hours of internet surfing.
fblack61