SharePoint - Excel Online - Edit in Excel and Edit in Browser multiple users

0 votes

I have created an excel document in a document library. If all users edit via excel online that has no problem.

But If the user1 Edits the excel file in "Edit in Excel"(Open in Microsoft Excel) and the other user2 Edits in Browser(Excel Online) then both cant edit the file at the same time.

If user2 tries to edit the file in excel online when user1 already edited it in excel then gets a warning -

Unfortunately, the workbook needs to be closed on or checked in before you can edit it. If everyone uses Excel Online, you can work on it at the same time.

I am wondering if there is a way for user1 to edit files in Microsoft Excel and user2 to edit on Excel online at the same time.

I tried to find information on this but it says - multiple users can edit only online. I want to find out if there is any other way.

Oct 3 in Others by Kithuzzz
• 20,660 points
203 views

1 answer to this question.

0 votes

Here is the Microsoft article regarding co-authoring

https://support.office.com/en-us/article/Collaborate-on-Excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104?ui=en-US&rs=en-US&ad=US

When asked "Why can't I see other people's selections?" in the Frequently Asked Questions, the answer is "only if you and other people are using Excel 2016 for Office 365 subscribers, or Excel Online."

Earlier versions of Excel, if I am not remembering, would automatically "Check-out" the document when it was opened on the client-side, rendering it unavailable until it was checked back in.

answered Oct 3 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

What are the RGB and HEX codes of the 3 color conditional format in Excel?

In Excel 2016 at least the colors ...READ MORE

answered Sep 24 in Others by narikkadan
• 37,660 points
451 views
0 votes
1 answer

Excel - add all X in column and then multiply

Use countif for the count then multiply ...READ MORE

answered Oct 1 in Others by narikkadan
• 37,660 points
50 views
0 votes
1 answer

Quadratic and cubic regression in Excel

You need to use an undocumented trick ...READ MORE

answered Oct 1 in Others by narikkadan
• 37,660 points
122 views
+4 votes
3 answers

Will Power BI take over MS Excel

Well, if your taking about just data ...READ MORE

answered Sep 26, 2018 in Power BI by Vardhan
• 13,200 points
449 views
0 votes
1 answer

Why should I shift from MS Excel to Power BI

There are a lot of advantages from ...READ MORE

answered Sep 26, 2018 in Power BI by Kalgi
• 52,350 points
299 views
+1 vote
1 answer

How is power BI different from excel

Power series plug-ins you can do certain ...READ MORE

answered Sep 26, 2018 in Power BI by Hannah
• 18,570 points
269 views
0 votes
1 answer

Multiple find and replace in MS Word from a list in MS Excel

If I understand you correctly, you want ...READ MORE

answered Oct 28 in Others by narikkadan
• 37,660 points
46 views
0 votes
1 answer

Download multiple excel files linked through urls in R

Try something along the lines of: for (i ...READ MORE

answered Sep 23 in Others by narikkadan
• 37,660 points
103 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP