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
• 38,020 points
1,210 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, 2022 by narikkadan
• 63,680 points

Related Questions In Others

0 votes
1 answer

Check multiple cells in excel, move to next cell if null and if value found stop and return that value

Use this formula: =INDEX(FILTER(A2:D2,A2:D2<>""),1,1) INDEX returns the first value ...READ MORE

answered Mar 24, 2023 in Others by Kithuzzz
• 38,020 points
528 views
0 votes
1 answer

How to use COUNTIFS with multiple conditions and columns in Excel?

Use  SUMPRODUCT and double unay operators: =SUMPRODUCT ...READ MORE

answered Apr 4, 2023 in Others by Kithuzzz
• 38,020 points
575 views
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
• 63,680 points
1,394 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,190 points
1,270 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
717 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,540 points
733 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, 2022 in Others by narikkadan
• 63,680 points
696 views
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, 2023 in Others by narikkadan
• 63,680 points
2,488 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