Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 68
  • Last Modified:

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

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
upobDaPlaya
Asked:
upobDaPlaya
  • 2
  • 2
1 Solution
 
Jamie McAllister MVPSharePoint ConsultantCommented:
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
 
upobDaPlayaAuthor Commented:
Is there some way I can force Edit in Excel not be view-able then so they can only edit in the browser...
0
 
Jamie McAllister MVPSharePoint ConsultantCommented:
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
 
upobDaPlayaAuthor Commented:
Excellent..thx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now