Allow multi user editing in Excel [at the same time]

This method requires OneDrive⚠️ This is how you and your colleagues can edit the same Excel file at the same.
🕒 TIMESTAMPS
0:00 How multiple users can edit the same Excel file [at the same time]
0:20 Step 1: Place files in OneDrive
0:40 Step 2: Open file from OneDrive
1:07 Step 3: Edit the file
👍 LIKE AND SUBSCRIBE
If you found this video helpful, hit 'Like' and 'Subscribe' to never miss our latest tutorials. Got a question or feedback? Write a comment!
🎁FREE COURSES
Try my free 30-minute Excel course and join 100,000+ students: spreadsheeto.com
Learn Power BI for free and create impactful reports in just 30 minutes: spreadsheeto.com/free-power-b...
🏆PAID COURSES
Zero to Hero. From beginner to Excel expert in 14 hours: spreadsheeto.com/zero-to-hero/
VBA Masterclass. Become a VBA pro in 20 hours: spreadsheeto.com/vba-mastercl...
Power BI Essentials. Master Power BI in 12 hours: spreadsheeto.com/power-bi/
🧑‍💻HIRE ME AND MY TEAM
We develop custom Excel systems: spreadsheeto.com/excel-consul...

[@Spreadsheeto]

👋 3 ways I can help you! 1) *Free 30-minute Excel Course:* Try a course that adapts to your skill level, trusted by over 100,000 students! spreadsheeto.com 2) *Fast-Track Your Excel Learning:* "Zero to Hero" transforms you from a beginner to an Excel superuser in just 14 hours. spreadsheeto.com/zero-to-hero/ 3) *Custom Solutions for Busy Professionals:* Busy or stuck? Hire me to fix or build custom spreadsheets. spreadsheeto.com/excel-consultant/

[@leeannefaatele6194]

Just the video I need. So simple and easy to follow.

[@moesadr3342]

What about VBA enabled workbook? My workbook has VBA codes. Could you please tell me how this file can be shared to be updated and synced with other users in Office 365?

[@CindyHedelin]

the problem is, i'm using the web version of the excel and my friend using the desktop version. when she make changes, sometimes hers is not synchronized while mine works. is there any other setting or something i can do to fix this?

[@howitslimeslimy5652]

Thank you so much for the lesson. I wonder if we need to press the Save button after we typed the new data in the file?

[@PHUCTRANOG1118]

No, switch it to auto save on the top left corner.

[@ulludacharkha]

Thanks Sir !

[@Spreadsheeto]

Welcome!!

[@Lb-ri5wr]

OK so I have one drive and I have the full, paid microsoft 365 so I can use everything. Does the person I share it with need onedrive or the paid version of excel like me? Or can they just open the link I send, edit it, click on check boxes etc. (which are only shown on the paid version of excel for some reason) without needing to pay for excel themselves?

[@rajifusama]

how to make sure only registered co author can edit? i dont want to see guest contributor to edit my file

[@equizergaming1477]

how to turn on auto save??

[@christasioulas245]

Tried it with an .xslx file. I still need read-only files.

[@eacha9]

Do you have a tutorial that teaches how to manage protections in excel file sharing in One Drive? My unlocked range does not unlock it for other users.

[@janinegreen994]

What if the excel file is sent in an email? Do you have to load to OneDrive? After you’ve finished working on the spreadsheet do you have to save the changes or just close the file because it updates as you go along?

[@0xcid]

how disable read-only?

[@chivettebislig2354]

What if the main dekstop is off? Can they edit the file? Or it should be the dekstop is always on?

[@Spreadsheeto]

There is no main desktop :) The files are uploaded into OneDrive which is cloud-based. So the files are always accessible, even when the "main" desktop is not.

[@galahadxd]

Not working for files with VBA/Source Codes

[@ulludacharkha]

What if the File contains VB Macros ?

[@Spreadsheeto]

As long as you open it from your desktop computer and not in Excel Online, you should be fine :)

[@tutingrubena1584]

what if he accidentally eletes all, would that delete all in my workbook as well?

[@Spreadsheeto]

It would yes. But you can easily get it back when it's in OneDrive. See my video here on how to recover deleted data. kzbin.info/www/bejne/jXnYkIGtft2laJI

[@wyattbonnette3414]

You didn't even show how the other person got the file? How was it shared? You missed the most important part!

[@THELASTNUMBER1]

YOU FORGOT MOST IMPOTENT PART BRO AND INSTEAD PROMOTED YOUR BRAND