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, 2022 in Others by Kithuzzz
• 27,940 points

1 answer to this question.

0 votes

Here is the Microsoft article regarding co-authoring

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, 2022 by narikkadan
• 51,600 points

Related Questions In Others

0 votes
1 answer
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, 2022 in Others by narikkadan
• 51,600 points
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, 2022 in Others by narikkadan
• 51,600 points
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, 2022 in Others by narikkadan
• 51,600 points
+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
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
+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
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, 2022 in Others by narikkadan
• 51,600 points
0 votes
1 answer

How to unmerge multiple cells and transpose each value into a new column in Pandas dataframe from excel file

Try this: df = pd.read_excel("Sample_File.xlsx", header=[0,1,2,3,4,5], index_col = ...READ MORE

answered Jan 8 in Others by narikkadan
• 51,600 points
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP