Surprisingly comprehensive. I assumed 'what more could I learn about this topic?'.

This was amazing video. Everything is perfect. Your voice is really easy to listen and i found all the anserws that i tought i need to search for days! Thank you so much🙏

Hi Mynda. Interesting collaboration features. Thanks for sharing them :)) Thumbs up!!

Thanks Myanda for sharing this. May God bless you!

Excellent explanation Mynda!!! Thank you.

I am deeply appreciating your hard work and useful tips)

Hi, You are one of the best on Excel!

Thank you so much for this tip I am starting to learn Excel more i had a very good experience by learning this thank you 🥰

The tip about 'sheet views' (6:30) will help immediately. For some reason, up until this point, when I turn on filters, my view is showing on my colleague's screen. If I filter to just one category, my colleague's view filters to that category. Even worse, sometimes that colleague cannot clear filters! This does not happen on my other colleague's view. Why is this the case? What does colleague 2 do differently? As an immediate solution for colleague one, I will use this approach of creating my own view *first*, then filtering. Thanks Mynda!

Hola Mynda, excelente video, muy claro todo

Very concise and informative - thank Mynda

Really great video Mynda!

Wow great features i am really excited thanks for your training

Great video. This may solve the issues that I have been trying to fix. Several Questions: 1. Does everyone need to have 365 or just the owner of the book 2. If the file is saved on my onedrive, do they need to save the link to keep accessing it or do they save the file to their drive too? In other words, once I share the link how do they keep accessing the file? 3. One reason I would prefer to use excel over sheets is that I want to protect the cells that have formulas, while allowing the user to enter data in other cells. I assume that I will be able to do this using a shared 365 spreadsheet. Thanks again.

Hi Mynda!Great Explanation, Trying to Persuade My Office Manager To Try Co-Authoring...Thank You :)

Sheet views is amazing !

Very well explained.. Thanks..

Excelente aula, parabéns

Can you make changes to mistakes done after saving or send notifications/emails to the guest or co-workers after some days?

Can you also track rows that are deleted while transforming data using PowerQuery? Example: I have two row with duplicate IDs, but other important information still exists in the other columns. Using PowerQuery, I can remove the duplicate row by id. However, I would like the deleted row to populate to a new a table so I can find the correct ID. Thank you in advance! Your videos are amazing!

Ahhhh, Mendy and here I got so excited... Pitty not available for other products

Happy new year and I would appreciate if you could refresh my memory. Do all co-authors need to use their Desktop Excel to edit or this can be done on either Desktop or Web Excel? What are the cons and pros, if any?

Great presentation! Any restrictions on manipulating shared workbooks with VBA?

Do you have any videos or advice on trying to solve the below message with co-authoring a shared excel sheet which is stored on one drive with 4 people using. Below message randomly appears whilst co-authoring “New version available - We cannot apply changes made by someone else” Then asks to press reopen

Thank you so much my lord

Nice T-shirt

Dear Mynda, Thanks for another great video. I have had three ocassions on different users that people co-authoring in Excel Desktop, Excel Online and Excel in Teams find later that their changes did not go through at all or went through partially. All the files were in Sharepoint Sites. Any thoughts on why this might be happening? I know you are not a MS troubleshooter but I don't follow any of them. :-)

Thanks Mynda. Very helpful indeed. How do I prevent multiple collaborators editing each other's entries. In other words, I want my students to provide certain information in the same sheet, but I don't want to allow anyone edit another's text. Is there a way to do this?

Better than google sheets you said .. but all those features already in google sheets since way too long and it's all free for example .. version history in google sheets lets you do beside what u showed in your video: 1) revert to any old version of the sheet without loosing the last updated version. 2) copy any version to new sheet. 3) rename each version to your liking. they even took it far and created mini dashboard that track users activity and trends on the sheet so what is better exactly?

Hi Mynda, thanks for the video. I am evaluating MS excel for collaboration and have a question: Let's say I have a paid personal Microsoft 365 subscription and have saved the file on my OneDrive. Does the person I share the file with also need to have a Microsoft 365 subscription (and/or save the file in their own OneDrive) for this to work, or is it enough that they have any kind of MS Office/Excel license (including, possibly, no paid product but just the free Office-Online version). Would greatly appreciate if you could help me know how it would work in these scenarios. Thanks.

Quick question. If I need excel to select the number above or below the average of a group of numbers, what would that formula look like? Or can it perform this function at all?

Can I add Name Range and Tables to add Data Validation and still use it for Real time Co-Authoring? Also is it possible to Hide one or two sheet from others, if needed?

One question - Can you used microsoft 365 to colaberate on excel files when the file has external links/external data feed? Thanks

Great video! Does sheet view work on an excel dashboard so that 2 or more different users can apply different slicers and get different views of the same dashboard?

How many user can work at a time? Is their any limitation like few dozens, hundreds or thousands?

Thanks for your video. It is possible to "point" a user to a specific view by writing into the cells something like a link to 'table1!view2' ?

Very useful. Thank you :-)

This got us started. However, we cannot tag anyone in the comments. Any suggestions on where we look to determine why?

Question. I want an excel file to be password protected only between me and the other person I want to co-author with at the same time. How do i trigger with the co-author feature that we both can only make changes together with a password when the document is opened?

Hi Mynda, great video. Do I need to have separate licenses for external users to use and edit? Thx

Hi there, I’m currently using office 2019 on my desktop, and I subscribed office 365, can I use the co-authoring feature on the 2019? Or I need to reinstall the 365 version? Thanks a lot!

awesome many thanks ❤❤❤

Me and some of my colleagues work in a excel document together. But since recently my colleagues dont see the changes. Everyone is correctly signed in with a good internet connection. Any idea? Especially since it worked perfectly before.

Hey can u also tell us how u made that status sheet !! I already downloaded the description link but there is no description regarding that status sheet kindly guide me threw !! Thanks

How does everyone find this daily Will it be saved in their desktop excel? Do they have to reopen the email? Also is there a way to add the same file into Teams?

Can you do this with Excel 2021?

hi there...thanks for this great video...just 1 question, what if i want to share my file in real-time with my colleagues but they cannot edit on it...for viewing purposes only...thanks

Great video. I need the ability for user x to see ONLY what user x enters/edits while over 100 users update a master table. Any way to have users only see THEIR data?

Real time experience in ms Excel using drive for desktop ?

I have a question can we do this on a daily basis with our colleagues without any lag.?

How about Macros and VBA codes, does it work in excel online?

can this function able to link with power BI on real time as well? is there any function such as importrange (in google sheet) where we can transfer information from other file in real time? anyway, that supernice video!

Is there VBA code that you could use in the desktop version that would automatically populate a threaded comment with the @email in the comment to automate that process?

Do you have a video on how you created the Gantt chart shown in this vid?

Hiding columns in Sheet Views does not work - Is that correct? I tried it but the columns hidden while creating the view will simply unhide when you jump out of that view. Switching back to that view will not re-hide those collumns. Is this a bug or is it simply not possible? Many thanks in advance!

Hi. I need to know if this works with workbooks that contain queires, macros and vbs script?

awesome many thanks :)

Hello Mynda, great content like always! Do you know how can I assign a specific column to a user, meaning the this user is the only person allowed to make changes in the column?

Wondering if there is any way to have a column showing the intial of the teammate which either created or updated a record?

If I want to hide certain rows or column from other user that I don't want them to see or to unhide, is it possible to do?

Can anyone help me? I can't tag people neisthetically - when I type "@" it doesn't highlight people....

If only it worked consistently, sometimes allows co authoring and other times the same file is locked by a user. No idea why, it's random same file same staff same everything. Never found a reason or a fix.

at 3:01 you mentioned status where you have a sheet show when someone made changes. how was that made

Thanks!

sheet view it is not working with pivot table... any idea?

So, how can this be done when OneDrive and a SharePoint servers is NOT available?

do I need to have "track changes" on when co-authoring?

Very useful

Why won't the project restore unless all other people editing the document have closed it down?

FIRST