Solved

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

Posted on 2016-10-01
4
31 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
  • 2
  • 2
4 Comments
 
LVL 31

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 31

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

930 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now