Edit the same file together - collaborate with others - Word, Excel, PowerPoint - OneDrive & Teams

Learn how to work together on the same file using OneDrive or Teams based link sharing.
Stop sending attachments. Let multiple people update the same file. Stop wasting time in repetitive copy paste. Get a better quality document faster.
Understand how editing together works in Word, Excel and PowerPoint.
Find out who changed what and when.
Contents
---------------
00:00 - Intro
00:15 - Edit file together in Word
07:45 - Edit file together in Excel
11:09 - Edit file together in PowerPoint
Udemy Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - hi.switchy.io/22B1
Excel to Power BI - swiy.io/pivotsh
Learn more from 1000+ blog articles by Dr Nitin Paranjape
efficiency365.com/blog
LinkedIn : / nitinparanjape
Twitter : / drnitinp
Created using Camtasia: www.techsmith.com/video-editor

[@ksmitan]

This is so simple and easy message delivery. Nitin sir, Thanks a ton

[@akk2766]

Awesome presentation and to the point. Exactly what I was looking for.

[@mnmistry]

excellent explanation ! 💚

[@efficiency365]

Thanks for your feedback. Do explore my blog at efficiency365.com/blog Check out my My Udemy courses Excel to Power BI s.efficiency365.com/upbi Pivot Tables s.efficiency365.com/upt Learn 130 powerful efficiency best practices across Office 365 - read my latest book - s.efficiency365.com/bk Also let me know if you would like me to cover any topics relevant to you. Cheers. Dr Nitin (doc) Paranjape.

[@Medzo2]

Vey helpful. Thank you!

[@muhammadfaris6536]

Thank you for excellent explanation 👍👍

[@efficiency365]

Thanks for your feedback. Do explore my blog at efficiency365.com/blog Check out my My Udemy courses Excel to Power BI s.efficiency365.com/upbi Pivot Tables s.efficiency365.com/upt Learn 130 essential efficiency best practices - read my latest book - s.efficiency365.com/bk Also let me know if you would like me to cover any topics relevant to you. Cheers. Dr Nitin (doc) Paranjape.

[@amirasyraf9525]

hi ... great video.. i want to ask question, if I use normal microsft excel 2019 , not Microsoft 365 version, can I still sync my excel and edit the file from desktop to cloud??

[@efficiency365]

Yes you can

[@orchismandutta257]

Sir, is there any way...? like both users can work on the shared document from the desktop version (not using the browser) Please let me know... it will be very helpful. Thanks in advance.

[@efficiency365]

Yes of course possible. The file should be shared from Onedrive. Both people need internet to see each other's changes. If no internet the changes will be synced when you go online.

[@sandeeplade4949]

Sir, request to share video for sharing particular data from multiple slides to one slide easily. Also how we can use same to copy quickly for other excel documents with similar contents.

[@efficiency365]

Multiple slides to one slice is a manual copy paste process.. Pls explain your requirement.

[@user-md1gp6hn2s]

Lets say If I share some file with other and I edited something then other person get notified imminently ? What setting needs to be done

[@efficiency365]

Thanks @user-md1gp6hn2s Other person will not get notified. Check out my other best practices videos as well. Efficient Tasks Management - kzbin.info/www/bejne/rH2poYqMm7qZh5o Task Apps Comparison: kzbin.info/www/bejne/jJq6e3ywgrWEkMk Teams Meeting - Agenda, Action Points, Notes - kzbin.info/www/bejne/oWHXaZKjg9CAetk Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs OneDrive Best Practices Part 1 - kzbin.info/www/bejne/emi9o5mmnbxnrNE Part 2 - kzbin.info/www/bejne/pHfbZ4yHrchgmJY Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Cheers. Doc.

[@ashvin9685]

Sir I shared my excel file with my friend to work on it together but we can't work at the same time showing that it's read only, locked by another user Also my friend is working from android phone He got the same message when I opened the file in my laptop Pls give a solution

[@efficiency365]

Use Office 365 version.

[@Rojin.Marzooki]

How can we all work in excel application not on web?

[@efficiency365]

Thanks @Princess_Rojin There is no need for everyone to use Excel app. Some people can work on desktop app and some people can edit the same file on web. The desktop version should be the Office 365 version. If you use older versions like Excel 2016 or 2019, then it can create problems. Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzbin.info/www/bejne/qKWnnYKIgdKdoqc Excel Green Marks - Error Checking - Best Practices - kzbin.info/www/bejne/jpavpZ-wmZ6fiLs Excel Best Practices - Part 1 of 3 - Data Management - kzbin.info/www/bejne/qKPCYpuXa8xposU Excel Best Practices - Part 2 of 3 - Formulas - kzbin.info/www/bejne/oavCq3Ssgq6Bd80 Excel Best Practices - Part 3 of 3 - Analytics - kzbin.info/www/bejne/gH-1ZqyulLWaaqM 10 Excel Settings You Must CHANGE! - kzbin.info/www/bejne/rInVo4uagN59fM0 Automatic data clean up with Excel Flash Fill - kzbin.info/www/bejne/hGTTkKuVob2HlcU Instant Excel Audit, Comparison and Analysis - Inquire - kzbin.info/www/bejne/mXXHp4iQrbSIn9U Six powerful Excel Navigation Shortcuts - kzbin.info/www/bejne/mIOQqoCYfLWka5I Handle millions of rows in Excel - Slow to fast - kzbin.info/www/bejne/b2TLaKWIqLF5bbs Convert crosstab to tabular - Unpivot - Excel Power Query - kzbin.info/www/bejne/o4XXgKeQfZKhhK8 Cheers. Doc

[@dc3811]

I have problem to share pasword protected excel files. And also i found out that you cannot do refresh pivot table if the person you share file with doesnt have office 365 account

[@efficiency365]

What is the problem in sharing password protected files? Pivot table will refresh if it has access to underlying data connection. Where is the data for the Pivot Table? Refresh will work if the Pivot can find the data.

[@dc3811]

@@efficiency365the data for pivot table is in the file and inside the same sheet. I give permission my cholic to be able to edit . however she cannot refresh the pivot table; she can do other editing like normal.

[@efficiency365]

Check the Pivot Data source. It is pointing to the wrong location. Reselect the correct data and it will work.

[@14Freekick]

how can only one person be in the same document on sharepoint

[@efficiency365]

Thanks @14Freekick There can be multiple persons editing the same document at the same time. Online or offline. Check out my other best practices videos as well. Efficient Tasks Management - kzbin.info/www/bejne/rH2poYqMm7qZh5o Task Apps Comparison: kzbin.info/www/bejne/jJq6e3ywgrWEkMk Microsoft Teams Meetings - 16 Best Practices - kzbin.info/www/bejne/omSlp6RjfpWbr5Y Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs OneDrive Best Practices Part 1 - kzbin.info/www/bejne/emi9o5mmnbxnrNE Part 2 - kzbin.info/www/bejne/pHfbZ4yHrchgmJY Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Cheers. Doc.

[@reconnaisance]

Can they both edit when using the desktop app?

[@efficiency365]

Yes. They can. If the Desktop app is a very old version, it may not work. Try it out and let me know.

[@kyawmyohtet4715]

Same problem here. When the other user is editing in desktop app, let’s say excel, I am in read-only mode and the warning caption is shown like this …‘ This workbook is locked for editing by another user’. my edit stuff are not valid while I am using with deskto app at the same time. But it works Desktop vs Browser, Browser vs Browser. Not Desktop vs Desktop! Any solution?

[@efficiency365]

Older versions of desktop app or older version of onedrive can cause this.

[@kyawmyohtet4715]

Mine is the latest. No clue on what is wrong here. Have you tried it out?

[@amandas3696]

Are you able to have multiple people editing the same file while using track changes?

[@efficiency365]

Yes. Absolutely. If it is not working for you, check the version used by each person. Ideally, it should be Office 365 or browser version.

[@puppersissage8640]

one drive only alows 2gb before u have to pay

[@efficiency365]

That is personal version. If you don't find it useful do not pay. You get 5gb in free version. This video is about Onedrive for Business.