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

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

Vey helpful. Thank you!

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

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.

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

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.

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

7 ай бұрын

Thanks @user-md1gp6hn2s Other person will not get notified. Check out my other best practices videos as well. Efficient Tasks Management - kzread.info/dash/bejne/qIB60rmPlrjMgZs.html Task Apps Comparison: kzread.info/dash/bejne/iJ2LrKuzfbO3iso.html Teams Meeting - Agenda, Action Points, Notes - kzread.info/dash/bejne/nWSomsGmfs6zdNo.html Microsoft Teams - 15 Best Practices - kzread.info/dash/bejne/iWyJyNqYqtGxqKw.html OneDrive Best Practices Part 1 - kzread.info/dash/bejne/dmuO1MipmLqaptI.html Part 2 - kzread.info/dash/bejne/oHqsmLuKqMaTkpc.html Smart and Effective Email - 5 powerful ways - kzread.info/dash/bejne/aIJ5qLWGoavNgag.html Outlook Calendar Best Practices : Part 1 - kzread.info/dash/bejne/ea6ns9Cek82ngdI.html and Part 2 - kzread.info/dash/bejne/opWYrapxqdabc9Y.html OneNote - Best Practices - kzread.info/dash/bejne/n2Foo7tqk7DPaNY.html Microsoft 365 Best Practices - kzread.info/dash/bejne/nYp3wbucfJi1krg.html Cheers. Doc.

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.

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

@efficiency365

6 ай бұрын

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 - kzread.info/dash/bejne/pKh4zrGLfNDQnKg.html Excel Green Marks - Error Checking - Best Practices - kzread.info/dash/bejne/ipmA1s6zlJzSgrw.html Excel Best Practices - Part 1 of 3 - Data Management - kzread.info/dash/bejne/pKaTk8qaZsqcnMY.html Excel Best Practices - Part 2 of 3 - Formulas - kzread.info/dash/bejne/na6T3KOvfay0cc4.html Excel Best Practices - Part 3 of 3 - Analytics - kzread.info/dash/bejne/fIKGl9uxj7PNZKQ.html 10 Excel Settings You Must CHANGE! - kzread.info/dash/bejne/qIym1Lqde9ywds4.html Automatic data clean up with Excel Flash Fill - kzread.info/dash/bejne/gGekwdqYnLu6j8Y.html Instant Excel Audit, Comparison and Analysis - Inquire - kzread.info/dash/bejne/lXiY2LeTqLK7mdY.html Six powerful Excel Navigation Shortcuts - kzread.info/dash/bejne/lIZh26-bd7PXZZM.html Handle millions of rows in Excel - Slow to fast - kzread.info/dash/bejne/a2ecmdSLo6-sZ7w.html Convert crosstab to tabular - Unpivot - Excel Power Query - kzread.info/dash/bejne/n4iosdaTeJDUfrA.html Cheers. Doc

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

@efficiency365

4 ай бұрын

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 - kzread.info/dash/bejne/qIB60rmPlrjMgZs.html Task Apps Comparison: kzread.info/dash/bejne/iJ2LrKuzfbO3iso.html Microsoft Teams Meetings - 16 Best Practices - kzread.info/dash/bejne/nmd22NNmeZPOqZc.html Microsoft Teams - 15 Best Practices - kzread.info/dash/bejne/iWyJyNqYqtGxqKw.html OneDrive Best Practices Part 1 - kzread.info/dash/bejne/dmuO1MipmLqaptI.html Part 2 - kzread.info/dash/bejne/oHqsmLuKqMaTkpc.html Smart and Effective Email - 5 powerful ways - kzread.info/dash/bejne/aIJ5qLWGoavNgag.html Outlook Calendar Best Practices : Part 1 - kzread.info/dash/bejne/ea6ns9Cek82ngdI.html and Part 2 - kzread.info/dash/bejne/opWYrapxqdabc9Y.html OneNote - Best Practices - kzread.info/dash/bejne/n2Foo7tqk7DPaNY.html Microsoft 365 Best Practices - kzread.info/dash/bejne/nYp3wbucfJi1krg.html Cheers. Doc.

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.

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.

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.

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?

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.