Solved

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

Posted on 2016-10-01
4
34 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

I have just recently built a new SharePoint 2007 farm on a complete Windows 2008 R2 server platform and part of my standard build procedure is to implement a warm up routine, usually in the form of a script that is scheduled every morning to launch …
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…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

786 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