Excel/Word Collaboration by many users real time on a LAN

I want to have an Excel Doc and a Word doc that I can collaborate on with multiple users over a LAN NOT cloud services.  In other words I would, for example, want to have them reside on a network share and have 10 people open them up and actively change cell data in the workbook and have it reflated on all the other users systems immediately, ala Google Sheets (I know, that's in the cloud, but the way it works is what I want, but on a LAN). Same for the Word doc.

We currently update this data on SharePoint, but unless you refresh you never see the changes and the interface to SharePoint worksheets just plain sucks.

We are using Windows 7/Office 2013.

March 23rd, 2015 11:33am

Hi,

Based on your request, if we want to collaborate on with multiple users over a LAN in Excel and Word, they may use different ways to get your goal.

Excel:

We can use the "shared workbook" feature. The process works like this: You share a workbook, and as part of sharing, you save the workbook. Someone else then copies the shared workbook and adds their data to the copy. When they're done, you merge the data from the copy back into the original.

For more detail information, please refer to the following link:

https://support.office.com/en-za/article/Use-a-shared-workbook-to-collaborate-79bd9dee-1aa3-49b5-bc27-a1ad28ffcbce

===

Word:

Word has no build-in feature to do this. We need to use co-authoring feature in SharePoint Server 2013 or SharePoint Online to enable multiple users to work on a document, at any time, without interfering with each other's changes.

For more detail information, please refer to the following link:

https://technet.microsoft.com/en-us/library/ff718249.aspx?f=255&MSPPError=-2147217396

https://support.office.com/en-nz/article/Document-collaboration-and-co-authoring-ee1509b4-1f6e-401e-b04a-782d26f564a4?ui=en-US&rs=en-NZ&ad=NZ

Hope it's helpful.

Regards,

George Zhao
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
March 24th, 2015 1:32am

Thank you for the reply.  But in this case I'm afraid that won't work.  I need it to be real time,no saving back and forth.  The best example would be Google Sheets.
March 24th, 2015 11:25am

Hi,

Ok, Excel 2013 does not support Co-authoring feature yet, but we can use Co-authoring feature with Excel web app via SharePoint server/Office Web Apps Server. We may deploy an Office Web Apps Server in LAN.

See this:

https://technet.microsoft.com/en-us/library/ff718249(v=office.15).aspx

George Zhao
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
March 24th, 2015 9:20pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics