How to work with multiple users on an Excel worksheet?

By default when you update an Excel file or worksheet then you are opening the Excel file exclusively to make sure that while you are updating nobody can open it too to modify other information and then loose the information by the last save document action.

But sometimes you want to work with multiple users on the Excel file. Even when you display the Excel information on a data driven message board or notice board by using our DataPoint add-on, then you already have 2 users working on the Excel file. So you might encounter a deadlock situation already here. Best is to allow that multiple users can work or read on the same Excel file. With this option you are using Excel merely as a database when you have a central storage and you are reading out the information from various locations.

Then go to the Review tab in your Excel ribbon and click the Share workbook button.

When you do this the first time, you can get this trust center message about privacy settings on the document.

In the Excel menu click File and then Options.

Click the Trust Center option in the left menu and then click the Trust Center Settings button of the details pane.

Now choose the Privacy Options at the left and then uncheck the Remove personal information from file properties on save and hit OK twice to close all forms.

Retry to share the workbook now again. Click the Share Workbook button of the Review tab to get this form.

Check the option Allow changes by more than one user at the same time. This also allows workbook merging. And click OK. Excel will ask you if it is ok to continue with this. Choose OK here.

As of now you will see the text [Shared] in the caption of the document as an indication that this document is shared.

You can open this Excel document by multiple users to view and update the content. You will not get messages anymore that the Excel document is opened exclusively by another user.

🎬CHECK OUT OUR POPULAR VIDEOS:👇

🤝STAY CONNECTED WITH US:👇

#PresentationPoint
#powerpoint
#excel
#word
#presentation
#microsoft
#powerpointpresentation
#office
#ppt
#business
#microsoftexcel
#design
#accounting
#amazingslidepresentation
#slides
#digitalsignage
#powerpointdesign
#slidedesigner
#livepowerpoint
#slidepowerpoint
#marketing
#presentationdesign
#mailmerge
#screen_savers
#Promoting_Online_Courses
#PowerPoint_for_Digital_Signage
#Coronavirus
#Automating_PowerPoint_from_Excel
#Google_Analytics_data
#KPI_dashboards
#PowerPoint_Salesforce_integration
#One_World_Observatory
#Merge_PowerPoint_Presentations
#Mind_blowing_PowerPoint
#Digital_Signage

[imranbehnam]

who ever you are, you need to know you are a start, to the point, compact and precise, job well done mate

[normaachon]

I can’t wait to do this with my spreadsheet that I created at work and share with my coworkers !!

[aurinwongpichit]

That is what i look for, for long time. Thank you so much...

[mohamednayeem]

can I do this for form? I have a form where people enter data n get stored in some other excel. The data is not getting filled when two users are opening the excel. will this option make it work for multiple user to submit the form simultaneously.

[breadmuffin]

You simply made the file shareable, how do I specifically share it to someone I want?

[almoglevyharan]

This video helped me so much!!! Thank you

[javierrivas]

I'm on 2016 and I see Unshare Workbook, and it's greyed out, how can I activate this

[simasstil]

Sir, maybe a stupid question: if two people are simultaneously editing a document, will the changes made by one member appear only when the other saves the document? Our team want to edit specific fields but because there are hundreds of lines, we have to filter the data - what we want to avoid is while editing some fields, the filter keeps changing.

[Me]

Sir, the video is excellent. Thank you for sharing. Can the workbook be moved to SharePoint using Excel Web Access Web part and then more than one person can edit the document? Thank you.

[stefanociarambino]

Hi, the steps you advised in your video are not working on my spreadsheet because I'm using a table. In your example, I can see that you have a bunch of entries which have not been organised as a table. Does this mean that my document cannot be converted in 'Shared' unless I convert the table to ranges?

[onurkakilli]

Sir, how can we do the same for word document ? Please help

[daviddarby]

Can it be shared on Onedrive as a database backend via VBA read/write from the front end?

[arick]

Whoever is following this path should accept the risk that every time when a person is accessing this Excel sheet is having the master copy. So needs to be very cautious making changes/dealing with the master copy.

[aradhinaramnani]

after making these settings how can i share the file to other user to open this file.

[rehanan]

I am not able to do this, as in my worksheet instead of "Share workbook" its showing as "Unshare workbook", what does that mean? is it already shared with multiple users, also I am not able to click this "Unshare Workbook" button, so that means it is already locked by the previous user?

[tzimhoni]

But who is the TopUser?? if i manage excel file on Network folder, who can be the "Master" or the TopUser???

[toc]

hi, i'm having difficulty in that it seems to onlu allow one user at a time to work on the excel file. Brings a message 'file locked by XXX user' . I've slected the 'allow changes by more one user at the same time', ...tia

[camilo]

Hello, I have an userform with VBA code. How can I let multiple user use this file without losing each other's input? Is there something I can do?

[maha_e_suvidha]

Can i protect the shared sheet and run macro??? And how???

[dorotejbogdanovic]

Hello guys, i have a 1 question, i need a Help..
I have a problem when 2 persons work on excel in same time its work perfect, but when 1 person want to save a data, and in others pc is active, his excel just stuck and crash cuz he save.
The Files are linked to DropBox, and when he save DropBox automaticaly update the file, and on other pc user have a crash in program if he work on them. Do you know some solution?
Thanks in Advance.