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🙏
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!
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.
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.
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!
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.
@@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?
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?
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
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?
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. :-)
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.
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?
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
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.
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?
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 ;-)
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?
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.
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.
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.
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?
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
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.
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.
@@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.
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?
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).
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!
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
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?
@@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!
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?
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.
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?
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
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!
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?
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.
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!
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.
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.
Surprisingly comprehensive. I assumed 'what more could I learn about this topic?'.
Glad it was worth your while David!
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🙏
So glad you enjoyed it!
Hi Mynda. Interesting collaboration features. Thanks for sharing them :)) Thumbs up!!
Thanks for watching, Wayne!
Thanks Myanda for sharing this. May God bless you!
You are most welcome!
I am deeply appreciating your hard work and useful tips)
Thanks so much! 😊
Excellent explanation Mynda!!! Thank you.
Glad you liked it, Ivan!
Hi, You are one of the best on Excel!
Wow, thanks so much 🙏
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 🥰
That's wonderful to hear!
Very concise and informative - thank Mynda
Cheers, Tony!
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!
Great to hear, David!
Hola Mynda, excelente video, muy claro todo
Thanks, Leonidas!
Wow great features i am really excited thanks for your training
Great to hear!
Really great video Mynda!
Thanks so much, Chris!
Sheet views is amazing !
Glad you liked it 😊
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.
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.
@@MyOnlineTrainingHub Thank you for such a quick response. You are truly awesome!
Hi Mynda!Great Explanation, Trying to Persuade My Office Manager To Try Co-Authoring...Thank You :)
Good luck with that, Darryl. It’s awesome!
Very well explained.. Thanks..
So nice of you :-)
Thank you so much my lord
My pleasure 😊
Excelente aula, parabéns
Obrigado!
Ahhhh, Mendy and here I got so excited... Pitty not available for other products
What do you mean 'not available for other products'? What other products?
Hi, I mean for otger versions like Excel 2013, 2016 etc... Is it not only for office 365 with excel online?
Ah, yes. Only the latest version of Excel gets the bells and whistles!
Can you make changes to mistakes done after saving or send notifications/emails to the guest or co-workers after some days?
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.
Very useful. Thank you :-)
Great to hear 😊
awesome many thanks ❤❤❤
You're welcome 😊
awesome many thanks :)
Glad it was helpful!
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!
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.
Nice T-shirt
Thanks, Iwan!
Great presentation! Any restrictions on manipulating shared workbooks with VBA?
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.
@@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?
Thanks!
My pleasure 😊
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?
You can use either. Web version doesn’t have all Excel functionality.
@@MyOnlineTrainingHub Thank you!
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
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.
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?
Yes, it will.
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. :-)
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.
@@MyOnlineTrainingHub Thanks for the comments and keep it up! :-)
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?
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
@@MyOnlineTrainingHub Thank you
Real time experience in ms Excel using drive for desktop ?
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' ?
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.
How many user can work at a time? Is their any limitation like few dozens, hundreds or thousands?
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.
This got us started. However, we cannot tag anyone in the comments. Any suggestions on where we look to determine why?
hmmm, check you're all in the same tenant.
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?
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 ;-)
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?
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.
@@MyOnlineTrainingHub Ok awesome thanks. i will try.
Hi Mynda, great video. Do I need to have separate licenses for external users to use and edit? Thx
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.
I have a question can we do this on a daily basis with our colleagues without any lag.?
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.
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.
As long as you share the file with anyone, your users don’t need a license.
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.
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.
@@MyOnlineTrainingHub thanks for your response, i will tell them to try it.
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?
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
Do you have a video on how you created the Gantt chart shown in this vid?
Not a video, but this tutorial explains it: www.myonlinetraininghub.com/excel-gantt-chart
Very useful
Glad to hear that, Pankaj!
@@MyOnlineTrainingHub Thankyou for makeing such kind of video
By profession i m a business Analyst please suggest some videos which can help ..
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.
@@MyOnlineTrainingHub Thankyou so much
sheet view it is not working with pivot table... any idea?
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.
@@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.
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?
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).
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!
It's not possible, but you can use grouped columns and expand/collapse them: www.myonlinetraininghub.com/excel-group-and-outline-data
@@MyOnlineTrainingHub Hey, thank you so much for this useful information! This will come in very handy for a usecase!
@@MyOnlineTrainingHub Subscribed!
One question - Can you used microsoft 365 to colaberate on excel files when the file has external links/external data feed? Thanks
Yes.
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
I used an Excel Chart for the Gantt chart as explained here: www.myonlinetraininghub.com/excel-gantt-chart
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
You can make it read only.
thanks ma'am but how? 🙏😊
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?
Not unless you use a form for them to enter their data into: ua-cam.com/video/Eys3YTmtK2s/v-deo.html
@@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!
Can you do this with Excel 2021?
No. It requires Microsoft 365.
How about Macros and VBA codes, does it work in excel online?
No, Macros and VBA cannot be executed online. For that you need to use scripts.
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?
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.
@@MyOnlineTrainingHub Good idea! You are the best.
Hi. I need to know if this works with workbooks that contain queires, macros and vbs script?
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.
@@MyOnlineTrainingHub Awesome thank you so much
Can anyone help me? I can't tag people neisthetically - when I type "@" it doesn't highlight people....
You have to be logged into Excel with the same tenant as your connections, and connected to the internet.
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?
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
Wondering if there is any way to have a column showing the intial of the teammate which either created or updated a record?
Not that I'm aware of, Mohammad. You'd have to get them to enter that info upon data entry.
@@MyOnlineTrainingHub Thank you!
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!
You need to install the 365 version.
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?
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.
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?
With workbook/worksheet protection: www.myonlinetraininghub.com/excel-workbook-protection
So, how can this be done when OneDrive and a SharePoint servers is NOT available?
There's no support for co-authoring without online access, sorry.
@@MyOnlineTrainingHub This is why I've turned to Google Sheets. The collaboration, ease of use and cost are just way better.
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!
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.
at 3:01 you mentioned status where you have a sheet show when someone made changes. how was that made
If you follow the link in the video description to download the file you can see how it’s made.
do I need to have "track changes" on when co-authoring?
No, it automatically does it for you.
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.
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.
Why won't the project restore unless all other people editing the document have closed it down?
I presume you mean refresh. The file should show updates from other users in real time.
@@MyOnlineTrainingHub I tried and it told me that all other users need to close the application first before I can restore a previous version.
Hmmm, maybe someone checked the file out.
FIRST