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

Рет қаралды 80,329

Күн бұрын

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

Пікірлер: 25

@Spreadsheeto 2 жыл бұрын

👋 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 2 жыл бұрын

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

@Lb-ri5wr 2 жыл бұрын

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?

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

@howitslimeslimy5652 2 жыл бұрын

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.

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

@ulludacharkha 2 жыл бұрын

Thanks Sir !

@Spreadsheeto 2 жыл бұрын

Welcome!!

@janinegreen994 2 жыл бұрын

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 2 жыл бұрын

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

@eacha9 11 ай бұрын

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.

@chivettebislig2354 2 жыл бұрын

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

@Spreadsheeto 2 жыл бұрын

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.

@christasioulas245 6 ай бұрын

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

@0xcid 8 ай бұрын

how disable read-only?

@galahadxd 9 ай бұрын

Not working for files with VBA/Source Codes

@ulludacharkha 2 жыл бұрын

What if the File contains VB Macros ?

@Spreadsheeto 2 жыл бұрын

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

@tutingrubena1584 3 ай бұрын

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

@Spreadsheeto 2 ай бұрын

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. kzfaq.info/get/bejne/ja6lkrGort7WYmQ.html