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

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

Рет қаралды 33,056

Күн бұрын

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

Пікірлер: 34

@ksmitan 3 жыл бұрын

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

@akk2766 2 жыл бұрын

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

@Medzo2 2 жыл бұрын

Vey helpful. Thank you!

@mnmistry 2 жыл бұрын

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.

@muhammadfaris6536 2 жыл бұрын

Thank you for excellent explanation 👍👍

@efficiency365 2 жыл бұрын

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.

@user-md1gp6hn2s 6 ай бұрын

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 6 ай бұрын

Thanks @user-md1gp6hn2s Other person will not get notified. Check out my other best practices videos as well. Efficient Tasks Management - kzfaq.info/get/bejne/rLJ2o7qHy7vKgWw.html Task Apps Comparison: kzfaq.info/get/bejne/jM-Hfayrsra1ips.html Teams Meeting - Agenda, Action Points, Notes - kzfaq.info/get/bejne/oZaka8Kes9GxdKs.html Microsoft Teams - 15 Best Practices - kzfaq.info/get/bejne/jZ6FmduQ39SvqH0.html OneDrive Best Practices Part 1 - kzfaq.info/get/bejne/ep2Kpcmhzb2YpqM.html Part 2 - kzfaq.info/get/bejne/pKyoabyC3cmRkmg.html Smart and Effective Email - 5 powerful ways - kzfaq.info/get/bejne/bLR1ebZ-1q7LgXk.html Outlook Calendar Best Practices : Part 1 - kzfaq.info/get/bejne/feCjhNGWyNClgaM.html and Part 2 - kzfaq.info/get/bejne/pseUfqtp3tmZc6c.html OneNote - Best Practices - kzfaq.info/get/bejne/o5NkdLxiyLPNaKc.html Microsoft 365 Best Practices - kzfaq.info/get/bejne/obxzkryUsZuzkok.html Cheers. Doc.

@ashvin9685 2 жыл бұрын

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

Use Office 365 version.

@Rojin.Marzooki 5 ай бұрын

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

@efficiency365 5 ай бұрын

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 - kzfaq.info/get/bejne/qNp0n7KDsdPOnHk.html Excel Green Marks - Error Checking - Best Practices - kzfaq.info/get/bejne/jst8p8-ryZ_Qgo0.html Excel Best Practices - Part 1 of 3 - Data Management - kzfaq.info/get/bejne/qNiPZMuSm82anJc.html Excel Best Practices - Part 2 of 3 - Formulas - kzfaq.info/get/bejne/oeCPraSnsq-ycZ8.html Excel Best Practices - Part 3 of 3 - Analytics - kzfaq.info/get/bejne/gLSCaNypxLbLZHU.html 10 Excel Settings You Must CHANGE! - kzfaq.info/get/bejne/rL6ipbuVsN-udp8.html Automatic data clean up with Excel Flash Fill - kzfaq.info/get/bejne/hJmgktuQ0b64j5c.html Instant Excel Audit, Comparison and Analysis - Inquire - kzfaq.info/get/bejne/maqUqbiL3bW5mac.html Six powerful Excel Navigation Shortcuts - kzfaq.info/get/bejne/mLhdrLCTrLbVZWQ.html Handle millions of rows in Excel - Slow to fast - kzfaq.info/get/bejne/b5mYatWD2LKqZ40.html Convert crosstab to tabular - Unpivot - Excel Power Query - kzfaq.info/get/bejne/o7qkgteLrZPSfoE.html Cheers. Doc

@14Freekick 3 ай бұрын

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

@efficiency365 3 ай бұрын

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 - kzfaq.info/get/bejne/rLJ2o7qHy7vKgWw.html Task Apps Comparison: kzfaq.info/get/bejne/jM-Hfayrsra1ips.html Microsoft Teams Meetings - 16 Best Practices - kzfaq.info/get/bejne/oplyqdRerpbMqWg.html Microsoft Teams - 15 Best Practices - kzfaq.info/get/bejne/jZ6FmduQ39SvqH0.html OneDrive Best Practices Part 1 - kzfaq.info/get/bejne/ep2Kpcmhzb2YpqM.html Part 2 - kzfaq.info/get/bejne/pKyoabyC3cmRkmg.html Smart and Effective Email - 5 powerful ways - kzfaq.info/get/bejne/bLR1ebZ-1q7LgXk.html Outlook Calendar Best Practices : Part 1 - kzfaq.info/get/bejne/feCjhNGWyNClgaM.html and Part 2 - kzfaq.info/get/bejne/pseUfqtp3tmZc6c.html OneNote - Best Practices - kzfaq.info/get/bejne/o5NkdLxiyLPNaKc.html Microsoft 365 Best Practices - kzfaq.info/get/bejne/obxzkryUsZuzkok.html Cheers. Doc.

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

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

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

@sandeeplade4949 3 жыл бұрын

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

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