Solved

Can you co-author a document using SharePoint Web Services if the user chooses “Edit in Excel”

Posted on 2016-10-01
4
49 Views
Last Modified: 2016-10-05
If multiple users opens an Excel document from SharePoint via the SharePoint Excel Web App and then they choose the button "Edit in Excel" my assumption is all users can still make changes simultaneously.

I have read that this is not possible if the spreadsheet is opened via the client.

When they click on Edit in Excel is this opening the workbook on the client and co-authoring is therefore not possible ?
0
Comment
Question by:upobDaPlaya
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 32

Expert Comment

by:Jamie McAllister MVP
ID: 41825395
The other Office documents would be fine using the client for co-editing, but not Excel. For excel you need to be editing via the browser for co-editing to work. The experience for that is OK in 2013 and better in 2016 using Office Online Server.
0
 

Author Comment

by:upobDaPlaya
ID: 41825775
Is there some way I can force Edit in Excel not be view-able then so they can only edit in the browser...
0
 
LVL 32

Accepted Solution

by:
Jamie McAllister MVP earned 500 total points
ID: 41830312
I should mention there's something I have seen work here. Leaving aside co-editing it is possible to Share a spreadsheet and allow multiple editors even when stored in SharePoint.

It's on the Review tab in Excel, and you click Share Workbook on the ribbon.

As I say it's not using the co-editing feature and is just streating SharePoint like a fileshare, but it does allow multiple editors.
0
 

Author Closing Comment

by:upobDaPlaya
ID: 41831130
Excellent..thx
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question