Surprisingly comprehensive. I assumed 'what more could I learn about this topic?'.
@MyOnlineTrainingHub
Жыл бұрын
Glad it was worth your while David!
@wayneedmondson1065
3 жыл бұрын
Hi Mynda. Interesting collaboration features. Thanks for sharing them :)) Thumbs up!!
@MyOnlineTrainingHub
3 жыл бұрын
Thanks for watching, Wayne!
@davidfamilydoctor9430
Жыл бұрын
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!
@MyOnlineTrainingHub
Жыл бұрын
Great to hear, David!
@saaranevalainen8916
2 жыл бұрын
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🙏
@MyOnlineTrainingHub
2 жыл бұрын
So glad you enjoyed it!
@IvanCortinas_ES
3 жыл бұрын
Excellent explanation Mynda!!! Thank you.
@MyOnlineTrainingHub
3 жыл бұрын
Glad you liked it, Ivan!
@gpclarkejr
5 ай бұрын
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.
@MyOnlineTrainingHub
5 ай бұрын
Thank you! 1. I'm pretty sure that as long as you set the link up with "anyone with the link can edit", then the users don't need 365 but they will have to open the file in Excel Online. 2. Yes, they need to click the link to open the file each time in Excel Online. 3. Yes, you can set worksheet protection on specific cells.
@gpclarkejr
5 ай бұрын
@@MyOnlineTrainingHub Thank you for such a quick response. You are truly awesome!
@saqibyounus9500
Жыл бұрын
Thanks Myanda for sharing this. May God bless you!
@MyOnlineTrainingHub
Жыл бұрын
You are most welcome!
@muhid-dinsafarmamadov5153
3 жыл бұрын
I am deeply appreciating your hard work and useful tips)
@MyOnlineTrainingHub
3 жыл бұрын
Thanks so much! 😊
@ravichandrankannappan6552
Жыл бұрын
Hi, You are one of the best on Excel!
@MyOnlineTrainingHub
Жыл бұрын
Wow, thanks so much 🙏
@chrism9037
3 жыл бұрын
Really great video Mynda!
@MyOnlineTrainingHub
3 жыл бұрын
Thanks so much, Chris!
@leorc564
3 жыл бұрын
Hola Mynda, excelente video, muy claro todo
@MyOnlineTrainingHub
3 жыл бұрын
Thanks, Leonidas!
@tjb233
3 жыл бұрын
Very concise and informative - thank Mynda
@MyOnlineTrainingHub
3 жыл бұрын
Cheers, Tony!
@oluwafunkeolaiya7180
11 ай бұрын
Can you make changes to mistakes done after saving or send notifications/emails to the guest or co-workers after some days?
@MyOnlineTrainingHub
11 ай бұрын
Yes, it's just like any Excel file where you can continue to edit it. If you want to alter co-workers to issues, you can tag them in comments.
@GodWillIncreaseNitzborn
3 жыл бұрын
Ahhhh, Mendy and here I got so excited... Pitty not available for other products
@MyOnlineTrainingHub
3 жыл бұрын
What do you mean 'not available for other products'? What other products?
@GodWillIncreaseNitzborn
3 жыл бұрын
Hi, I mean for otger versions like Excel 2013, 2016 etc... Is it not only for office 365 with excel online?
@MyOnlineTrainingHub
3 жыл бұрын
Ah, yes. Only the latest version of Excel gets the bells and whistles!
@liamkane101
Жыл бұрын
Great presentation! Any restrictions on manipulating shared workbooks with VBA?
@MyOnlineTrainingHub
Жыл бұрын
You can't execute VBA online, so that's a non-starter. However, you can execute VBA in a shared workbook that's open in the desktop app.
@liamkane101
Жыл бұрын
@@MyOnlineTrainingHub Hi Mynda, thanks for the reply. I need to build an app that hides a lot of the data entry manipulation behind some forms and where multiple teams can collaborate. Have use Google Script + Google Sheets before, but lots of companies won't allow Google Sheets in their environments. I don't need a full web app with a real database. Any thoughts?
@WynstonaJackreece
11 ай бұрын
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!
@MyOnlineTrainingHub
11 ай бұрын
You could number the duplicates and then separate the records numbered 1 and records numbered 2 (the duplicate records) into separate tables. See this tutorial: www.myonlinetraininghub.com/numbering-grouped-data-power-query If you get stuck, post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum as I won't see follow up replies to this thread.
@ajzambranop
2 жыл бұрын
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. :-)
@MyOnlineTrainingHub
2 жыл бұрын
Hi Alberto, not sure why that would be. Sometimes my OneDrive sync tool doesn't connect properly and I have problems saving the changes, but this is rare.
@ajzambranop
2 жыл бұрын
@@MyOnlineTrainingHub Thanks for the comments and keep it up! :-)
@moesadr3342
Жыл бұрын
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?
@MyOnlineTrainingHub
Жыл бұрын
You can use either. Web version doesn’t have all Excel functionality.
@moesadr3342
Жыл бұрын
@@MyOnlineTrainingHub Thank you!
@steveprice7009
Жыл бұрын
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?
@MyOnlineTrainingHub
Жыл бұрын
Yes, it will.
@jacobxavier05
Жыл бұрын
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 🥰
@MyOnlineTrainingHub
Жыл бұрын
That's wonderful to hear!
@chahineatallah2636
2 жыл бұрын
Sheet views is amazing !
@MyOnlineTrainingHub
2 жыл бұрын
Glad you liked it 😊
@AdelM2007
Жыл бұрын
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?
@MyOnlineTrainingHub
Жыл бұрын
Great to hear! You can't lock the cells, but you can share sections of the workbook with specific people so they know where they should be entering their data: support.microsoft.com/en-au/office/share-a-section-of-a-workbook-dd5d3385-a8f7-4a25-9283-ff505ad8ddb4
@AdelM2007
Жыл бұрын
@@MyOnlineTrainingHub Thank you
@mdexcelpro8495
3 жыл бұрын
Wow great features i am really excited thanks for your training
@MyOnlineTrainingHub
3 жыл бұрын
Great to hear!
@darrylmorgan
3 жыл бұрын
Hi Mynda!Great Explanation, Trying to Persuade My Office Manager To Try Co-Authoring...Thank You :)
@MyOnlineTrainingHub
3 жыл бұрын
Good luck with that, Darryl. It’s awesome!
@ljwalker9271
2 жыл бұрын
Hi Mynda, great video. Do I need to have separate licenses for external users to use and edit? Thx
@MyOnlineTrainingHub
2 жыл бұрын
Glad you liked it! Guest users can edit in Excel online (I think). You can test it in a browser. Make sure you’re logged out.
@amitsondhi333
2 жыл бұрын
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.
@MyOnlineTrainingHub
2 жыл бұрын
As long as you share the file with anyone, your users don’t need a license.
@leslieaikens9199
3 жыл бұрын
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?
@MyOnlineTrainingHub
3 жыл бұрын
Hi Leslie, Yes, you could use some nested functions to do this. Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@MrBrunoptavares
2 жыл бұрын
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?
@MyOnlineTrainingHub
2 жыл бұрын
There's no security feature in Excel that does this. At best you can lock the cells in that column and give the password to the user you want to allow to edit it.
@MrBrunoptavares
2 жыл бұрын
@@MyOnlineTrainingHub Good idea! You are the best.
@moesadr3342
2 жыл бұрын
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?
@MyOnlineTrainingHub
2 жыл бұрын
Yes, you can use defined names and data validation with co-authoring. You can share a specific region of the worksheet with users as explained here: support.microsoft.com/en-us/office/share-a-section-of-a-workbook-dd5d3385-a8f7-4a25-9283-ff505ad8ddb4?WT.mc_id=M365-MVP-5003849 (although I'm not sure this prevents them from wandering elsewhere in the file).
@markd1230
Жыл бұрын
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
@MyOnlineTrainingHub
Жыл бұрын
I get this message from time to time too and I'm not sure what the fix is other than to reopen the file, sorry.
@mrkd4126
Жыл бұрын
One question - Can you used microsoft 365 to colaberate on excel files when the file has external links/external data feed? Thanks
@MyOnlineTrainingHub
Жыл бұрын
Yes.
@stefanspath1322
3 жыл бұрын
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' ?
@MyOnlineTrainingHub
3 жыл бұрын
You're welcome, Stefan! You could add a hyperlink for the user to click that takes them to the cells you want them to enter.
@mohamed.montaser
3 жыл бұрын
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?
@MyOnlineTrainingHub
3 жыл бұрын
Excel can do 1, 2 and 3 too (not sure of the value of the dashboard), plus Excel has 17 Billion cells vs Sheet's 5 Million. On top of that Excel has Power Query and Power Pivot. Sheet's is fine for basic stuff, but Excel is for serious spreadsheeters ;-)
@arshadshaik3020
2 жыл бұрын
How many user can work at a time? Is their any limitation like few dozens, hundreds or thousands?
@MyOnlineTrainingHub
2 жыл бұрын
I'm not sure if there's a hard limit. You used to be able to configure the number of concurrent users in SharePoint Server, so this may also be the case for SharePoint online.
@FlyOpenBallsOut
Жыл бұрын
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.
@MyOnlineTrainingHub
Жыл бұрын
Hmmm, not sure why that would be. My first thought would be to reboot all PCs connecting to the file and re-open it from OneDrive/SharePoint.
@FlyOpenBallsOut
Жыл бұрын
@@MyOnlineTrainingHub thanks for your response, i will tell them to try it.
@danielbabor
2 жыл бұрын
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
@MyOnlineTrainingHub
2 жыл бұрын
You can make it read only.
@danielbabor
2 жыл бұрын
thanks ma'am but how? 🙏😊
@elecirlisboa9155
3 жыл бұрын
Excelente aula, parabéns
@MyOnlineTrainingHub
3 жыл бұрын
Obrigado!
@kwantingjackyyip3066
2 жыл бұрын
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!
@MyOnlineTrainingHub
2 жыл бұрын
You need to install the 365 version.
@shannonadams281
2 жыл бұрын
This got us started. However, we cannot tag anyone in the comments. Any suggestions on where we look to determine why?
@MyOnlineTrainingHub
2 жыл бұрын
hmmm, check you're all in the same tenant.
@dhananjaypinjan2643
3 жыл бұрын
Very well explained.. Thanks..
@MyOnlineTrainingHub
3 жыл бұрын
So nice of you :-)
@jacobxavier05
Жыл бұрын
I have a question can we do this on a daily basis with our colleagues without any lag.?
@MyOnlineTrainingHub
Жыл бұрын
Yes! The only lag is the time it takes to upload your edits to SharePoint/OneDrive and download the edits of your co-workers, which is minimal.
@series25a
Жыл бұрын
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?
@MyOnlineTrainingHub
Жыл бұрын
If you set a password to edit the file, then you and the other person you want to have edit rights can open the file in edit mode and make changes. All other users will not know the password to edit it, so they will be able to open it in Read Only mode. The password is set in the Save As dialog box > Tools drop down > General Options. Set the password in the 'Password to modify' field.
@series25a
Жыл бұрын
@@MyOnlineTrainingHub Ok awesome thanks. i will try.
@MyHCLondon
2 жыл бұрын
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?
@MyOnlineTrainingHub
2 жыл бұрын
The file is saved on OneDrive and each person opens the file on the desktop or in Excel Online or in Teams. If they open it in the Desktop client they will have the OneDrive sync tool installed so the file is constantly in touch with OneDrive and updating their view of the file.
@anu11356
2 жыл бұрын
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
@MyOnlineTrainingHub
2 жыл бұрын
I used an Excel Chart for the Gantt chart as explained here: www.myonlinetraininghub.com/excel-gantt-chart
@jimbrown746
Жыл бұрын
Hi. I need to know if this works with workbooks that contain queires, macros and vbs script?
@MyOnlineTrainingHub
Жыл бұрын
Yes, but keep in mind that VBA is not executable on the web, so if the file is opened in Excel Online, then the VBA won't run.
@jimbrown746
Жыл бұрын
@@MyOnlineTrainingHub Awesome thank you so much
@vossenjonk3448
Жыл бұрын
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!
@MyOnlineTrainingHub
Жыл бұрын
It's not possible, but you can use grouped columns and expand/collapse them: www.myonlinetraininghub.com/excel-group-and-outline-data
@vossenjonk3448
Жыл бұрын
@@MyOnlineTrainingHub Hey, thank you so much for this useful information! This will come in very handy for a usecase!
@vossenjonk3448
Жыл бұрын
@@MyOnlineTrainingHub Subscribed!
@big1975E
3 жыл бұрын
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?
@MyOnlineTrainingHub
3 жыл бұрын
Probably, but I haven't tried it. Here's the documentation for the Excel Threaded Comment object: docs.microsoft.com/en-us/office/vba/api/excel.commentthreaded
@muhammadfathiabdulrahim7150
3 жыл бұрын
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!
@MyOnlineTrainingHub
3 жыл бұрын
Glad you liked it, Muhammad! Yes, you can connect to Excel files with Power BI using Power Query and schedule updates. Not real time, but at specified intervals. The equivalent of importrange is to use Power Query to get data from other sources.
@damatar
2 жыл бұрын
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?
@MyOnlineTrainingHub
2 жыл бұрын
Not unless you use a form for them to enter their data into: kzitem.info/news/bejne/pq-pmY2KpqZ8Zag
@damatar
2 жыл бұрын
@@MyOnlineTrainingHub Thanks Mynda. :) I've toyed with the idea of doing forms, but there are 24 columns of data and some users have dozens of rows, so they would need to enter the form potentially 1000+ times. Good to know, though as I work through my options. If confidentiality is on the table, I may just wind up having users save their worksheets into a folder, then user power query to combine into the master table. (The process I inherited has them email me, then I copy/paste into a master table. 0_o) Have a great day!
@mohammadsadrzadeh4067
Жыл бұрын
Wondering if there is any way to have a column showing the intial of the teammate which either created or updated a record?
@MyOnlineTrainingHub
Жыл бұрын
Not that I'm aware of, Mohammad. You'd have to get them to enter that info upon data entry.
@mohammadsadrzadeh4067
Жыл бұрын
@@MyOnlineTrainingHub Thank you!
@iwankarim7063
3 жыл бұрын
Nice T-shirt
@MyOnlineTrainingHub
3 жыл бұрын
Thanks, Iwan!
@wisconsinwoodsman1987
3 жыл бұрын
Do you have a video on how you created the Gantt chart shown in this vid?
@MyOnlineTrainingHub
3 жыл бұрын
Not a video, but this tutorial explains it: www.myonlinetraininghub.com/excel-gantt-chart
@lucone1973
2 жыл бұрын
sheet view it is not working with pivot table... any idea?
@MyOnlineTrainingHub
2 жыл бұрын
Sheet view was designed to work with Tables and other hidden/filtered content. PivotTables change the actual data in cells, so I'm not surprised this isn't supported.
@lucone1973
2 жыл бұрын
@@MyOnlineTrainingHub first of all, thanks for your reply. In my opinion, if Microsoft is talking about collaboration systems, certain functions have to be really collaborative. Sheet view, regardless of tables or pivot tables, must be an independent viewing system for users. Otherwise it makes no sense. We hope for the future. Happy day.
@FunFact-ory
Жыл бұрын
How about Macros and VBA codes, does it work in excel online?
@MyOnlineTrainingHub
Жыл бұрын
No, Macros and VBA cannot be executed online. For that you need to use scripts.
@Sai-jh5ti
2 жыл бұрын
Real time experience in ms Excel using drive for desktop ?
@bezso0222
3 жыл бұрын
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?
@MyOnlineTrainingHub
3 жыл бұрын
With workbook/worksheet protection: www.myonlinetraininghub.com/excel-workbook-protection
@dariuszmariusz8505
6 ай бұрын
Can anyone help me? I can't tag people neisthetically - when I type "@" it doesn't highlight people....
@MyOnlineTrainingHub
5 ай бұрын
You have to be logged into Excel with the same tenant as your connections, and connected to the internet.
@sampsonasare9437
3 жыл бұрын
at 3:01 you mentioned status where you have a sheet show when someone made changes. how was that made
@MyOnlineTrainingHub
3 жыл бұрын
If you follow the link in the video description to download the file you can see how it’s made.
@marysmith3710
Жыл бұрын
Can you do this with Excel 2021?
@MyOnlineTrainingHub
Жыл бұрын
No. It requires Microsoft 365.
@duartemorais9063
Жыл бұрын
Thank you so much my lord
@MyOnlineTrainingHub
Жыл бұрын
My pleasure 😊
@lookslikerain75
3 жыл бұрын
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.
@MyOnlineTrainingHub
3 жыл бұрын
I haven't had that problem, Gareth, but be sure to send a frown via the Help tab in Excel so the Excel team can investigate.
@dennistucker1153
Жыл бұрын
So, how can this be done when OneDrive and a SharePoint servers is NOT available?
@MyOnlineTrainingHub
Жыл бұрын
There's no support for co-authoring without online access, sorry.
@dennistucker1153
Жыл бұрын
@@MyOnlineTrainingHub This is why I've turned to Google Sheets. The collaboration, ease of use and cost are just way better.
@alexrosen8762
3 жыл бұрын
Very useful. Thank you :-)
@MyOnlineTrainingHub
3 жыл бұрын
Great to hear 😊
@Nitaka12
2 жыл бұрын
do I need to have "track changes" on when co-authoring?
@MyOnlineTrainingHub
2 жыл бұрын
No, it automatically does it for you.
@Abu.Al_Mortaja
2 жыл бұрын
awesome many thanks ❤❤❤
@MyOnlineTrainingHub
2 жыл бұрын
You're welcome 😊
@biniesh7097
3 жыл бұрын
Thanks!
@MyOnlineTrainingHub
3 жыл бұрын
My pleasure 😊
@omenninja1967
3 жыл бұрын
awesome many thanks :)
@MyOnlineTrainingHub
3 жыл бұрын
Glad it was helpful!
@dreamsunlimited0783
3 жыл бұрын
Very useful
@MyOnlineTrainingHub
3 жыл бұрын
Glad to hear that, Pankaj!
@dreamsunlimited0783
3 жыл бұрын
@@MyOnlineTrainingHub Thankyou for makeing such kind of video By profession i m a business Analyst please suggest some videos which can help ..
@MyOnlineTrainingHub
3 жыл бұрын
Hi Pankaj, at a minimum you should know Power Query and Power Pivot. You can see these tools in action in some of my Dashboard tutorials, and all of my Power BI tutorials, as Power Query and Power Pivot are integral to using Power BI.
@dreamsunlimited0783
3 жыл бұрын
@@MyOnlineTrainingHub Thankyou so much
@plasmaglowmusic1655
2 жыл бұрын
Why won't the project restore unless all other people editing the document have closed it down?
@MyOnlineTrainingHub
2 жыл бұрын
I presume you mean refresh. The file should show updates from other users in real time.
@plasmaglowmusic1655
2 жыл бұрын
@@MyOnlineTrainingHub I tried and it told me that all other users need to close the application first before I can restore a previous version.
Пікірлер: 163