edhasted
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?
What's the simplest approach to achieve this?
In Excel ypu can use the shared workbook feature
https://support.office.com/en-us/article/about-the-shared-workbook-feature-49b833c0-873b-48d8-8bf2-c1c59a628534
In Word you can use the Track changes
https://support.office.com/en-us/article/track-changes-in-word-197ba630-0f5f-4a8e-9a77-3712475e806a
read this article: https://word.tips.net/T000534_Multiple_Document_Users.html
and read also this https://support.office.com/en-us/article/collaborate-on-word-documents-with-real-time-co-authoring-7dd3040c-3f30-4fdd-bab0-8586492a1f1d
https://support.office.com/en-us/article/about-the-shared-workbook-feature-49b833c0-873b-48d8-8bf2-c1c59a628534
In Word you can use the Track changes
https://support.office.com/en-us/article/track-changes-in-word-197ba630-0f5f-4a8e-9a77-3712475e806a
read this article: https://word.tips.net/T000534_Multiple_Document_Users.html
and read also this https://support.office.com/en-us/article/collaborate-on-word-documents-with-real-time-co-authoring-7dd3040c-3f30-4fdd-bab0-8586492a1f1d
ASKER
Many thanks to you both, am reading through these articles. Suspect some more questions to follow.
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.
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.
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...
Good luck...
ASKER
Unfortunately it's SBS 2011...
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?
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?
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.
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.
ASKER
I am not allowed to save this in the Cloud. Do I have any options then? Very many thanks.
No. You need shared area support, so in your case co-authoring collaboration will not work. Sorry.
ASKER
Can I install Sharepoint on SBS 2011, and if yes is it overkill for this task?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Very many thanks again.
ASKER
Many thanks for everyone who helped out. As usual the bleedin' obvious requires superior knowledge and am grateful to you all.
You are very welcome and I was happy to help you.
Quick Note - SharePoint foundation is a part of SBS 2011.
Look at this article here for details.
https://support.office.com/en-us/article/document-collaboration-and-co-authoring-ee1509b4-1f6e-401e-b04a-782d26f564a4