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

[@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/

[@wyattbonnette3414]

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

[@Venus_On_PawZ]

Exactly

[@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?

[@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?

[@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?

[@getrekt8515]

is this possible in local network and how ?

[@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.

[@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 :)

[@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.

[@Goodoldays9]

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.

[@ulludacharkha]

Thanks Sir !

[@Spreadsheeto]

Welcome!!

[@vishalsaran4513]

How many users can work concurrently following this method. Is there a limit on number of users? Will it more for more than 50 people team? Please advise

[@MrJonathanhidalgo365]

Why would 50 people need access to one file all at the same time

[@0xcid]

how disable read-only?

[@solarzv1803]

how can we do it without sharing in one drive ?..

[@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

[@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?

[@rajifusama]

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

[@galahadxd]

Not working for files with VBA/Source Codes

[@christasioulas245]

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

[@THELASTNUMBER1]

YOU FORGOT MOST IMPOTENT PART BRO AND INSTEAD PROMOTED YOUR BRAND

[@tahaeivazi9573]

👍👌

[@Dannykirklandmissed]

Im looking for a video that shows a share being used by someone. I can make a sandwich. Here is a picture of a sandwich.