 Expression filters are working so that's I guess it's a good thing so but hello welcome everyone to another episode of office hours we're going to be discussing all things Microsoft 365 and answering questions from the community, community, community, I need to have an effect or something. My name is Christian Buckley of an office apps and services MVP and Microsoft regional director and I'm also the Microsoft go to market director at Ave Point and joining me today on our all star panel we have Dr. Sean McDonough consultant. I know he's not a doctor. He's not a doctor by any way. My wife's the only doctor in this place. Yeah. Hey, we got Neil will admit will admit Neil. But Sean is a consultant with bitstream foundry in Cincinnati, Ohio and an office apps and services MVP. We also have Mike Nelson a solution architect with pure storage in a cloud and data center management MVP based in Appleton, Wisconsin. How hostile or a senior field engineer with rolling shore and tower and Tucson, Arizona and office apps and services MVP. We also have Sherry Oswald Microsoft certified trainer Microsoft Office master and co-founder there should be again sound effects with the master. Like master of the universe or like wwe wrestling or something. I'll work on that. Yeah. And co-founder of power up learning Colorado Springs, Colorado. And we were just joined by Microsoft Seeger's program manager. Dr. Neil Hoskinson. Hello. Taking your background. Yeah. Do you go by doctor? Like I always said, if I got my PhD, I would require my children to call me Dr. Buckley. But. No, I don't. I don't. I only use the title when I have it on LinkedIn. Because that's, you know, if I ever come to look for a new job. But other than that, I only use the term doctor when someone irritates me or I have to write an official letter to like the government and say, yeah. Is that kind of like when you're in trouble and somebody uses your middle name? That's what I was thinking. Yeah, kind of. That's right. Michael, by the way. So, but I'm, I'm. Sean, I'm in God mode today. Oh, I see that. You've got Keith Richie's background on your green screen. I know. Yeah. I'm being highways. I actually have. She actually wrote a song for me. Oh, really? Yeah. I'm only one of these albums. Yeah. And we did the, it was called Pillars of Time. Pillars. There's like a, there's a Jeff Teeper song. There's a Neil Hodgkinson song, a Spence Hab song, a bunch of other MVPs. I don't know whether any of you guys are on there or not, but there's even a Bob Fox one. Yeah. So. Wrote one for me too. Yeah. That's cool. I don't, I don't believe he wrote one for me. I did reach out to him though and asked if he ever did anything that was more guitar driven on the ambient side, but that I could add drum beats and vocals to and do something. And he's like, no, not, I was thinking of doing something that's more in the electronic dance music side of things and add beats to it. He's just like, yeah, we need to use. I don't have anything that's like ready to go, but I might go explore one of these his collection and find something and add some, some layers to it. But yeah. Okay. Okay, go ahead. I'm going to say. Yeah. A few of us in the internal key, like the internal folks at Dallas, we were fortunate enough to get a private screening of a short film that Keith wrote the score for on something. So that was pretty cool. That's cool. Yeah. Should look forward to that in the future. It's going to be festivals and things, but we'll see. Well, we are underway with episode 51. So we had that, that brief hiatus there, eight episodes over on the app point channel. But the rest of it will, will still, I need to go back and, and get the recordings and do the blog post for it so that it's all in one place that you can go and find the collection. Are we calling it the point of fair? So they're still sponsoring. We'll be probably doing some blog posts around some of the questions that we answer. And so they'll go through and do, they've been getting great numbers off of the blog, just SEO of people searching on the Q and a not surprising when you have a lot of traffic to your blog and people are looking for certain problems. Like we are SEO rich in the transcripts of our discussions, whether we actually solve the problems or not. That's a different. As long as we don't use the word telephony. Well, you just did. Oh, yeah. Mike. So that's like, we all need to add a telephony. Everybody drink. But episode 51. Let's kick things off with, I know there's a few things going on message center updates and then the other news of the day that we should kind of cover. But Mike, you want to kick us off? Yeah, I need a sound effect though, Christian. I need that. You know, like the news sound effect, you know, to tell a type going on. I can do that. I can get the voice code. All right. So what do we got going on? Microsoft teams. Hey, who needs another view in Microsoft teams? You got together mode. You got gallery mode. Guess what? They're coming out with dynamic view. Oh, really redesigned and optimized meeting stage that will optimize your experience of consuming shared contact and engaging with video and audio participants. Yeah. So now they'll be able to take like video and audio will be shown separately and then audio appearing is like little circles. And then the shared contact is going to appear larger with more participants being visible. So, you know, they're just basically adding another view that you can, you know, see in teams. You know that it's good to have that because it's almost like we were talking before we got recording here like using OBS and being able to go and set up your scenes. And there are a few default views that we all want to use for those things to have, you know, along the right side, all of the speakers, the presenters, people that are just attendees don't show up at all or down at the bottom as bubbles, you know, but you can have multiple speakers on the right side and the content on the main part of the screen to be able to kind of set those up and easily toggle between those views is, you know, much needed. Yeah. I agree. I agree. From the security side, Microsoft Authenticator. So obviously everybody's supposed to be using MFA, right? Right? Everybody's using MFA. I've heard of that. Yeah, you've heard of that. So MFA, everybody knows how it works. You basically you go to a website, it gives you a code and it can give you a code a couple of different ways. Use the Authenticator app. You get an SMS message, blah, blah, blah. Now they're actually coming up with a new way to do it where you have to compare codes. So what's going to happen is that you're going to have an option where you'll be presented on the screen with three different codes and you have to match that code to the single number or code that's in the Authenticator app. So the Authenticator app will give you one code and then you'll be given a choice of three on the screen and you just click on the one that is the code. They have been. We have that already. Hang on. Some months ago. Yeah, you said. So you're saying that this has already been rolled out. I just got this message and it says it's not it's rolling out early March and be complete by early April. So if you've gotten that's awesome. Yeah, it depends what ring you're in obviously from a Microsoft standpoint we haven't this for a while. Yeah, pretty well. The thing to note for administrators is that the default is off. Okay, so you'll be able to turn it on in you have to go to authentication methods laid in the Azure portal or use the graph API to turn it on. But by default it's off so maybe earlier rings the default was on but for you know, regular users it's going to be default is off. Yeah, there's only one thing I think I'm not sure that I like it or not because my concern and I've flagged this and I think I'm probably wrong. Obviously, the notification comes to your logged in Authenticator, but it literally gives you, you know, choose one of three, right? So if someone's compromise your device, they've got a one in three chance of actually getting past that. That's right. I was to put in like a six digit pain or something. Yep, yep. And that's always going to be, you know, evolving. I bet you they go eventually though. I remember we used to have to do one security question. Then it was three security questions. No, like my like my some of my financial stuff. I've got to answer like six security questions. I mean, it's just crazy. So they just, you know, add on volume to, you know, try and justify security. Anyways, moving on their updates to the meeting chat membership. Hey, hey, how they've had an update for you. Yeah. They're updating the participants access to meeting chat and the changes will manage a user's access to a meeting based on how they were invited to the meeting. So this is, you know, when it's rolled out, it actually has a criteria of who can see and participate in chat. And that's for a single meeting or in a recurring meeting series. So there's a list. There's there's actually a list of criteria as an example. People who are invited to the meeting or forwarded the meeting invite after it is scheduled will have access to chat before, during and after the meeting. Well, that'll be okay. Yeah. And people were added to a meeting after it starts using the invite, you know, what if they gave it to you and a participant's pain or provided the meeting join invite in another way, they'll access to the chat from the time they join to the time the meeting ends. So they can't see, you know, the chat after the meeting or the chat that happened before them. They will not be able to see the chat takes place after the meeting ends. Actually came up in a session that I did this week for the government. They were frustrated. They're like, we don't want them to see everything we've been doing. Somebody popped up in the middle of our training and said, why am I in on this? And they were getting bombarded by the chat bubbles. So. Yeah. Yeah. Yeah. It's possible to go in to for the admin for the owner of that meeting or that team to see who's been invited, what level access, they almost need to have a view of that. So you can see the people that don't have access or what controls and then be able to make changes. Okay. That's my wish list there. Yeah. But be able, if I see everybody that's been invited in and based on their permission level, what they're restricted from, but then if I can also go and toggle and manually change those, that would be cool. That'd be like a good custom view, you know, for admin to be able to create a custom. Yeah. Like video, you know, can they turn or their video, can they mute themselves, all those settings that we have to do ahead of time? That's probably cool. I can mute myself no matter where I am or what technology I'm using. Yeah. We know. Unmute themselves is probably the word. I just choose not to use that feature. Nobody mutes Christian. All right. Planner, one of Christian's favorites. Planner is coming out with new roster containers. Do you know about this Christian? Do you know what a roster container is? I saw that. I didn't read in depth on it. Okay, so planner is their new type of container and planner that allow plans to be created independent of a M365 group. So when the roster container is created, which is a simple, it's just a simple list of members that are stored in planner that can contain any user with a valid AAD, Azure Active Directory ID in the tenant. Okay, so they're calling those plans contained by rosters as roster plans, which basically means that you can add anyone, even though not part of that group. The roster plans are no longer confined to a group. So why can't those be called personal plans or shared plans or something more intuitive? Roster plan, I think it's not really user. I don't know. It might have been personal cherry until Microsoft marketing got a hold of it. That's how it usually happens. A lot of people have been asking for personal plans for a long time. So it's going to be, I don't need a whole group. I just need to be able to manage my daily stuff. So that's pretty cool. And something that I think that Christian, Sean especially needs is that there's a new personal well-being insights coming to teams. This could kind of help you guys out a little bit. It helps give you balance, productivity and well-being. While you're using teams, you'll be able to tap into breathing breaks and be able to send praise to collaborators, pause and reflect anytime during the workday as well as mindfully close out the workday with a virtual commute. Isn't that exciting? Oh, wait a minute. What? Virtual commute? Yes. Well, what else? There I ask, what is virtual commute? I don't know. That's all the info that was given. I said, even my walk down two flights of stairs to the basement office does technically commute. Yeah. But you'll be able to, think of it, you'll be able to, you know, breathing breaks. Just breathe. No, I do that now. Halfway down the stairs, I take about five minutes to get my, you know, my breath back from that effort and then make the rest of the way down the stairs. So I do that now. I used to joke that after I started working from home years ago, right, that my commute is brutal. Like dog cuts me off every morning and spills my coffee. She used to be, you know, she was that dog that had to be first. So she would just let stick the landing at the bottom steps and look and be like, I win. I traffic on the stairs. Yeah. I'm going to finish up here. I've got two more things. One is announcing conglomerate branding. Anybody doesn't know what that is. You've always been, if you ever wanted to create branding for your M365, you always had to, you had one theme that you could pick from or you had, you know, the only way you could do it is just to brand it so everyone sees the same thing. Well, now you can have multiple themes based off of a M365 group. So if you have a M365 group that is finance, you could have its own theme and so on and so forth. So it's not all just one theme anymore. They're adding the ability to do alternate logos, dark mode, light mode, you know, colors, all that kind of stuff. I think that's great because, you know, look, that was a long time was a, one of the major complaints about moving to Office 365 away from the on-prem was the ability to go in and personalize that environment. And there's a, and we all know that it is important to have a space that is designed for that team. But then again, to be forced to have the same design for the entire company, larger organizations, there's different branding and style guides for different business units. And so now to be able to go and do that is pretty cool. Yeah, I think so. And finally, let's take a pause in Memoriam. Okay. Dynamics 365. You know, the announcement is, is that they're getting rid of the Dynamics 365 link and the page link off of M365. I think you see the writing on the wall, maybe. I'm not really sure. But that's going to disappear. So you won't be able to get to the Dynamics 365 from M365 any longer. And also, I knew this was going to happen. It just, you know, it was a matter of win in Dell. Anybody using Dell, the Dell mobile apps are going away. And I think that is also another kind of precursor writing on the wall that, you know, Dell might have might be on its last legs. Well, so I mean, this has been a point of discussion for a long time. I just was looking to see if I have the Dell app in my Microsoft app graveyard folder on my phone. Is it there already? No. So I'll have to go in and find and add that. But the, no, is the fact that the Dell capability, it was almost like more of a, I mean, I get it. It's a landing page. I always kind of push back against that. I said, I don't want to go. Right. But I wanted to have that experience within the many other workloads. And so that's what's been happening is that you have the, the Dell, like personalized views, like in the office apps. So you can go in and see the shared with you. The most recent kind of the intelligent filtering within each of the applications that came from the Dell path. Yeah. Well, that comes up in SharePoint too. I mean, you created, you know, you go into SharePoint and right away, it knows about your shared documents. If you're logging in your office 365, it knows about your Word documents, your Excel, all that kind of stuff. You know, kind of the same thing. Yeah. Well, so we heard about that about a year ago or longer. I don't know. Time is a blur now. But talk about how, you know, that that was the plan for Dell that was being integrated into the normal everyday experiences across the workloads. And so the fact that they're finally, if they are getting rid of, I mean, just the app is the desktop Dell app still going to be there or not and fade out. I don't, it's not that big of a deal for me because it's already being integrated in. Assimilation. I never understood why, I never understood why they had the, when you log in to Office 365, you have that landing page and then you have the Dell landing page. It should have been the same one. To me, it should have been directed to that main page because it's the same thing. Yeah. That was, I don't know, why they overlooked that. It should have been, it might have been adopted better had they actually surfaced it. People don't know it's there. It's part of that ongoing joke of, you know, how many search locations do you have search experiences and there's like always been five or six or more. And why do we need another search experience? Why not go add that capability into what we already have? And so that's kind of what's happening. Yeah. I think there's an element there, Christian, that also, you know, thinking about the back end that's used for search these days. And it's evolved significantly from what we had back in the day. So sometimes I think we just have to draw a line into the old version, old approach. Yep. And you know, we've introduced the concept of Microsoft search now, which is predominantly graph based as opposed to what we think of back in the day. Those of us that are no disrespect to anybody. I think we're all old enough to remember how search index is used to work and change. Yeah. So it's a wholly changed evolved system now. But to your point about, you know, how many locations do we need to search? It doesn't make sense to add more locations versus update the location already had to leverage the new technology. Except the teams building the new are different product teams than the ones that own other assets. So that's just the reality. But you know, sometimes, you know, the language around the one Microsoft, let's go build together would be to get those teams together, add the new features into the existing property, not create something that new. But that's me. Yeah. All right. I am done. But Christian, if you want to segue in. Yeah. Do we want to talk about the news, the exchange, the big, secure each thing? Huge news. Not just news, but huge news. So far, what I read this morning, the latest numbers are 30,000 plus organizations that are affected by the zero day, the four zero day attacks that have been identified. All four have to be executed in order to take the remote execution code to be able to do REC inside of the exchange server. But of course this originated in China and it's something that other other hackers, I don't like to call them hackers, cyber terrorists, whatever they're calling them now, they're actually taking the lead and they're there. The group out of China has given, you know, all the information. They put it out there and said, hey everybody, this is how you do this. And now there are other, you know, pockets from within the U.S. and outside the U.S. that are now engaging and making this more of a widespread thing. When hacker groups are using Facebook ads to promote, then you know it's a bad thing. Yeah. That's kind of a joke. They're not that I'm aware of. I don't know. Well, what I want to know is, well, you're Microsoft here. What did you know and when did you know it? So I have to be, obviously I have to be, I can't say because I didn't, I was told about it versus knowing about it if that makes sense. I was told, I didn't know about it until after it happened. There was a couple of things that, I read an interesting thread yesterday, actually a tweet by the famous Snover. He posted about, hey, make sure your service is a patch. Make sure this, make sure that. This is an example why. And also the follow up to that was, and why the hell are you running exchange on premises anyway? And the whole debate about, well, is it on premises more secure than cloud? Does it work for me? All that kind of thing. And obviously it then got into the next piece, which is, well, if I'm doing hybrid cloud and I'm doing hybrid identity, at this point I can't turn off an exchange service, at least one exchange server on premises. So I would have to pull the thread up to actually, you know, give the detail. But it went into interesting things. So yeah, did I know about it before it happened? No, absolutely not. I did not. Our security teams are extremely protective of that information. And if they knew about it, they're not going to tell any of us. Until that, you know, not, right? And it would be, even if I, if I knew something that was like kind of secret inside the sausage factory, so to speak, it wouldn't be, this is not the right form for me. It's not about that. But I will tell you, I did not know anything. Yeah, just to be fair, I mean the first indication of this attack was back in January, right? So the first actual zero day happened January 21st or something like that. So this is something they've been working on for a while. And I think the first patch came out the second day of March. But Microsoft has actually, has written in the ZD net article, one of the ZD net articles was that they will not either confirm nor deny that this was part of the, as part of SolarWinds, as part of the SolarWinds issue. So they're like, you know, there's no yes or no answer there coming from Microsoft. So yeah. It is interesting to understand how an external entity can, why are you publishing exchange to the accessible to the internet? Why are you even doing that? I think we've got one of the questions later where it's kind of goes out from the, you know, public facing website perspective. I know it's not exactly the same thing, but again, like is Microsoft out of that business. So there's kind of a question around that where we might resurface this topic. Well, why don't we, why don't we jump into the questions? And I know at Neil, I don't know if you saw in the email that the homework, if you had any update on the full fidelity migrations, or we can hold that time. We can, I can do, but I haven't managed to do a test, but I can report back based on, as I mentioned last time, I've been out of migrations for a while. Well, let me, let me post the question. That was asked previously. Does anyone use the SharePoint migration tool for Microsoft to move large amounts of content from SharePoint 2010 to SharePoint online? Any issues encountered? We're going to pilot this soon. And so you were looking into, you're moving content versus the full fidelity migrations with the structure and. Yeah, yeah. So if you look at the content, the content moves without issues, the structure of the migration in terms of site structure, site templates, workflows, workflows was my primary thing I mentioned last time. Right now, including even things like signature workflows and site-level workflows, list-level workflows. So they do move. The one thing I would say, if someone's planning on moving a significant amount of content, don't try and do it with one instance of the tool. Use multiple instances of the tool to gain the performance level. And aka.ms slash SSPMT has a pretty good article about how to get the best performance from the tool. So when we can pack it there, if there's a follow-up question, we can take it again. And when you say they move workflows, I mean, this is a couple of years out of date, my knowledge of it, but there was still a problem with moving in-state workflows. So if you were halfway through, it would move the workflows, but you would have to essentially restart them. I mean, it couldn't move something that had 10 steps and it's halfway through. Have they figured out how to do... Has anybody figured out how to do the in-state workflow movement? I don't believe so. No, I think that's still a... We'll move the workflow definition and attach it to the right place and essentially republish it, but it won't get... As far as I know, if you're midway through a state machine, you're kind of busted. Yeah. So that's just a big FYI, folks, on migrations. All right. Thank you for that. And so let's jump into community questions into question number one. John asks, I upgraded from Office 2010 to Office 365. Everything upgraded just fine or it seemed except my calendar. I can see on the right-hand side where there's appointments. It's over in the task view, but I can't see the items on the calendar. I could use some help in trying to fix this. So is anybody... Can I start over this when I saw this? Make sure. Yeah, I guess I'm speaking. Okay. You are speaking. Yeah. Well, I thought I had the microphone turned off so well. And it kind of puzzled me as to what exactly he's seeing. First of all, he doesn't specify whether he's using the desktop client or whether he's using the local access. And people tend to want to make these work interchangeably and, of course, they're quite, quite different. The closest I was able to come up with this is once again, a view setting. And my suspicions are he's over in the calendar. And if he goes up to his little view tab up on top, he's going to then hit Change View. He's going to find something like List or Arc or Active or Preview. Although I don't suspect Preview so much because that still shows the calendar and doesn't have his calendar selected. That's about the closest I can come to that. One, that's the only thing I know of that will produce a list on the right-hand side. I'm not showing you much of a calendar anywhere else. Yeah, because the date is there, obviously, and I'm going to go up in the task pane. And I'm with you, Hal. I'm assuming that it's desktop version. Well, the other mistake could be that he's got the tasks open, but he might be in the wrong calendar view on the left side. And so I run to this, if you have multiple profiles, like just the other day, a few days ago, where I had my desktop client up and open, and I'm like, why aren't any of these items up? And it's my Christian Buckley calendar. It's like, oh, it's on the wrong profile. And so I went and clicked on the other Christian Buckley profile. There's the entire calendar up. So I think I had it, for some reason, closed down the wrong one. It was the community tenant that I had open. And so it just shows up the same way Christian Buckley. And so you're able to see all of the tasks for all your profile. But you're seeing the wrong calendar in screen. That could be another issue. OK. Anybody else there? Any other ideas? OK. Market is solved. All right. Well, John comes back with other. That's right. Jess Deep says, question number two. Hi, I've been playing around with the various task management apps in 365, but struggling to find one that ticks all the boxes. Can somebody kindly point me in the right direction, please? I'd like. And this is for those. This is one of those questions where they're outlining stuff. And what they're really doing is like you're venturing into paid consultant time to help you set up your environment. But you wanted to get some feedback here on this. So, you know, tasks that can be viewed and assigned to the team. So four people having a field for client name, having the field for nature of task, and then general free form box for description. And so look, you can add in your free form box. I mean, you saw some comments around this like, you know, hey, you can use planner or what are you really trying to do with this kind of tracking, go build a list, you know, use the list capability, which can go and do all this tracking. And any other thoughts? Those were the same ones I had in, you know, start with the task list and then build the fields that you want. I put a couple of links in the chat there for you. But it depends on whether they're on server. If they're on prem, they didn't really mention which version they're in. So depending on which one, but Microsoft list is not on prem yet. And I mean, Microsoft list is, excuse me, it can be a very, you know, extensive, you know, you can add all those fields and things like that. So it's not something that just, you know, only does shopping lists. You know, people, some people think it just does like really basic stuff, but no, it goes well beyond that. I just indicated the question is 365. Yeah. Sorry, I was going to say, you know, one of the, you know, standard templates is a project management is this kind of tracking lists as well. So it's a common scenario, but you can then go in and customize exactly what you can go and do. Well, they've been talking about adding custom fields to planner for what, over a year, year and a half, and they haven't done it yet, which, you know, they want us to use those. Then they need to make it more flexible. So planner is an option. Progress on the roadmap for planner. I don't know. It's been in progress for eight months. They talked about it a SharePoint conference a year and a half ago. As we've been talking about, it's, you know, the website says coming soon with a little construction worker animation coming for Christmas, Christmas 2018. So soon is probably extreme overkill. But I mean, if it's, if it's so critical, then I mean, and, you know, forgive me for saying this, but as your dev option is another option, right? It seems like that'll be overkill. You're forgiven. Powerful tool, but it would certainly perform the requirements. You're using, you're using basically a Cadillac to do the work of a pinto at that point. Yeah. I'm using a pile driver to knock a small nail into a piece of wood. It'll do the job though. Well, I'm sorry. I'm hearing the Tim Taylor. Oh, in my head right there. Can. Yeah. It's, uh, see question number three. Tiger says, uh, I'm looking to convert our sites to modern. I believe the best approach is to start a new site, which is fine, except I need to move all of our documents to terabytes from an old library to a new library is the move function adequate for this is kind of that, that like the homework item, Neil. I know there is a hundred gigabyte limit. So I'd have to move at a sub folder level. I looked at mover, but you can't have the same factor for source and destination. This is true. I mean, the move option. Um, so it's, it's obviously, it's obviously online. It's converting sites to sites. I'm assuming online in any way would make sense. Um, there is a, uh, a good article actually. I pulled this article earlier when I was looking through the questions, which tells you how to convert your sites to modern. Pop that in the chat window. It's not something I really do much anymore. Um, I haven't done recently. So I'd have to do some research. Oh, shoot. I said the wrong question. I said the wrong word. Do somebody. Hmm. There's the article, which should give you everything. The biggest, the biggest issue I find with a move function is it's just like he indicates in the question, it's slow and the quantity of stuff you can move is not. Huge. In one particular batch. Well, and if you have one site that, that shouldn't be a stretch, but if you've got 20 sites, that's a big effort. Right. And. Yeah. And then does it maintain the metadata when you move it? Does it maintain the last time it was edited or monitor or saved or who created it? Or is it? I don't know. I'm asking. In, um, when you use the move function. I. I realize people want to do as much as possible with the platform within the platform without going external, but there are partner solutions that. That do all this. Yeah. And can do it much faster and more comprehensively and going back to that full fidelity migration question. Third party solutions are, you know. More able to do that then. You tend to get what you pay for. So. Yeah. If you want to do it on the cheap, you might have to battle with it a bit and make some compromises. Yeah. Your cost element is going to be time and resources. This is the cost of licensing into. Exact the window. Yeah. All right. Let's jump to question number four. Leonard asked, so this is not technically a Microsoft 365 question. I've tried multiple times to get my bookmarks from the new edge to sync to edge on my iPad with no success. Well, the first problem is you're using an iPad. No, I have searched for solutions and tried the one suggested to no avail. I have signed on with my ID both on edge copies. Oddly enough, I cloud will sync edge bookmarks to Safari, but alphabetizes them instead of leading them as on my Windows laptop. Wow. Imagine that Apple and Microsoft just not communicating well. I'm shocked. I stunned. Yeah. I don't think the problem is technical there. It's just implementation. That's my guess, but I'm going to be. I mean, if you're logged in the same profile and two edge browsers and it should recognize you and sync between the two of them. So I mean, what if you've got the latest version of edge for each of those devices and you're logged in the right way? It should pick them up. I mean, you know, I don't have the ability to go test this out. But I mean, is Apple doing something to stop that from happening? Yeah. I can't test it out either. The closest I can I can bring up is I've got edge on my Android phone and that synchronization does work. Yep. I have it on my iPhone, which works fine. I don't have a fruit device either. So. I have nothing Apple. So just saying. This is one where it's like we can't even assign to homework. We just have to. We have to say Leonard. I don't know the answer, but I admire the question. So thank you. Go to the genius bar. I had it. I had an iPad at one point and I it was a toy, not a tool for me at that point. Yeah. And I stumped the guys at the genius bar asking basic questions. And after that, I'm like, I'm never buying it. This is their genius is I'm not buying anything more Apple. Yeah, that's that's weird. So I'm just installing edge on my iPad on my iPhone right now and syncing with my Microsoft account. Alright, we'll come back. Provide us an update. We'll jump into question number five, but we might we might come back to you Leonard. So Marco says question number five. Hello. I would be very grateful to count with any help. I have been using Gmail since 2004. Now that I have a subscription for Microsoft 365. I'm trying to set up outlook for the software is delayed online. And many times I see my inbox as the one I have a Gmail Web interface, so outlook with fewer messages. What's the problem, please? Also, it seems outlook never stops to sync. Thanks in advance for your help. Once again, are we talking desktop? Are we talking outlook web access to the best of my knowledge? Gmail does not have any kind of an interface that looks like outlook. They have their own. So Gmail Web interface sounds to me like outlook web access. In which case, yeah, you're going to see fewer things because they're different. Never stops to sync. Well, OK, once again, OWA doesn't need to sync because it's already there. If you're talking outlook desktop. Yeah, it may have already synced and you don't know it. So I don't know. It's another one of those that this is a little bit more information on that. And sure you had a link there. Yeah, I put a link in the chat about customizing your sync settings because if it's constantly syncing, you can actually control that a little bit better. Also how far back and it might be the settings on their OST file. So that could be an answer. Again, to Hal's point, like what version are you using? We don't know. And are they syncing their Gmail and other used about that as well? You know, it was you can't. They're syncing. Yeah, you can bring any. You can bring Gmail and outlook and manager. I used to do that all the time, so. Well, of course, if you do it all the way, then you're talking about a connected service and that behaves quite a bit differently than just stuffing a Gmail account and outlook desktop right through that. And bandwidth. It's always the question now, right? What's their bandwidth? Right. And how long did he post this and what was he could have still been processing is trying to pull up the backlog? Does he have other filters that's turned on that it's not showing everything up? I mean, if he's going and again, if it's a Gmail, that's kind of how I read it that this was he was trying to sync his Gmail through outlook and is not seeing all the same messages in the outlook Gmail folder than he is through Gmail and could be filters. I mean, what's the frame and. Well, I haven't I have a Gmail account when I go logging in Gmail. I can't find this stuff that I see readily in outlook so they do show things differently. They don't have the same like little filtered view like this is an ad or this is a, you know, you can promotion or whatever. I don't usually go to the web plan to usually use outlook. Yeah, Gmail is also a root folder animal. And if you don't have it, then then the then the folder tree that you see is bizarre. And it may be there and you just don't see it or looking in the right place. All right, hey Neil, any update to the syncing of the edge browsers? It's interesting. It's looks like it's updated some of my previously like favorites. You know, we get like the popular icons like I've got LinkedIn's popped up, the Netflix has popped up, Facebook's popped up, but I'm not seeing anything actually syncing in my in my what would be my favorites. That makes sense in my favorites all my and my history is only showing what looks like it's pulled the history of sites from my Safari browser on the mobile but not pulled them from my what would be my regular history of browsers favorites on the my laptop. So it could just be that it's not synced yet. At least I just literally just installed it. I'll check it again later, but a few things that have come through but I wouldn't say it's in any way fidelity. Yeah. Well, you know and do we chalk this up to the fact that they're just two operating systems. It's a slightly different product and so it's just designed slightly differently. I mean there was it used to be there was a full flesh you know Mac business unit the Mac boo inside of Microsoft and people would complain all the time that an office being one of the top downloads on you know Apple devices that but they were it was a different flavor of the software and they were usually you know a year or two or more behind in feature set Windows between iOS so you know is it just a different version of the software and just acts differently. I don't know who knows who knows these things. All right, let's jump to question number six. Carthagand says is it possible to get Azure AD users custom properties or extension properties using Microsoft Graph API if the graph is not returned how to get the Azure AD custom properties or extension attributes looking for recommendations we need to get the properties and display it into based on the user search we may have 10 to 12 custom properties in the AAD I just dropped the Lincoln chat directory scheme extensions for graph that you can use to extend Azure AD and I put one in before that that actually is a conversation between MPPs about it so yeah there's definitely you got to remember though there's two different APIs there's Azure AD graph and there's the graph API Azure AD graph is going away that's being deprecated graph API is going to take over everything I mean that's that's going to be the the go to for everything in Azure so there's a difference between the two definitely okay question number seven oh here's what I was talking about earlier Julie asked I have a bit of a random question for you guys and gals we are currently on prem but moving to online over the next 12 to 18 months and on one of our training sessions I asked a question about anonymous access to a 365 site it was told that SharePoint does not support web facing sites anymore does this mean it's just no good at it or does it literally mean that you can no longer build a site or a power app solution and share it via the internet with anonymous users they're just not good at it that's what it is it's just not good it can't share it consider it an appropriate investment yeah I've got a bunch of blog posts I wrote back before they sunset them and I had to migrate a lot of different small businesses off of SharePoint online public sites so yeah Microsoft backed out decided it wasn't a strategic area they wanted to invest in so no you're not going to be able to get your anonymous users into your SharePoint site sadly it was so four years ago it was quite some time ago yeah it was yeah I put it I put the article in the chat if somebody wants to I've got a link there yeah Sean do you have an article of yours that I can post to the link as well if you could grab one I'll and put it in the chat and I'll add it to the blog post sure I'm happy to do that the in memoriam for those questions let's see another question from Marcos says hey guys what are your suggestions for someone who is coming from Libre office client and some tools from SoftMaker to learn quick Microsoft 365 I subscribed yesterday and I am now trying to learn the things so somebody coming over you know there are so many great training resources for now so depending on what you are trying to learn I mean is it broadly across along every workload there are tools in videos honestly when I have a question about any product whether it's in the Microsoft ecosystem or fixing something in my car or cooking something I go to YouTube first and there's so much great content and walkthroughs of everything that you could possibly want to know but I would start with the docs.microsoft and do the search yep I could do a shameless plug being a Microsoft certified trainer I know I've got a great on demand learning tool if people want it's a little more structured but this one I refer this to everyone who starts with office 365 and that's the office.com slash training links to a different URL that I posted there in the chat but it's a good start if you're brand new to it especially it's not going to put me out of work yet but it's the resources they're really good yet one other thing to note if anybody else is coming from Libre Office you can actually make Libre Office look like office 365 okay you can't make office 365 look like Libre I mean by default but if they still have that capability to access that they can actually make the two look so they know what to do when they get over to 365 excellent somebody spent time building that capability they did and it's free it's a free download it just basically puts the ribbon bar up there it does all that kind of stuff excellent alright let's see number nine justice I have a lot of information on teams now I just realized if I delete it by accident everything will be gone is there a way to back up all the channels why would you want to back up the channels office 365 team back set up for you you can just raise a support request for a restore there are tools out there though that do do backwards yeah it's going to be piecemeal though you're because the data resides in different places so you know exchange share point online etc so you've got a solution that covers your Microsoft 365 stores and you want to try and back it up you can go ahead and do that but you're going to be piecing things together you have to understand that that's this is a day one question that was asked about teams it's not like you are when you delete a team and it asks you are you sure that you want to do this because what you're doing is you're deleting everything that's associated with everything that was connected with it all the chat that's part of that all the content the documents have been added to that all of the permissions around those things like you're removing all of that groups yeah yep and so it's not as simple as just hey I just deleted a site and hey what's the backup for this but you do have the assets for each of those things and your organization might have a recovery retention recovery process around all of that so you know one I would start there if your organization has something that they're already doing over and above how did something happen or did you not like my answer he's frozen well that might be why he was sad there he was losing his connection but oh there he's back hey Hal but so that might be the first place to go and check and then then beyond that would be hey to Microsoft you know hey is this something that you can go and reinstate this alright there was you no that was Hal wow I think he may not have had the connection back entirely so yeah any other guidance on on that because to say deleted by accident they make it very difficult there are multiple steps to happen in that accident of a deletion yeah it's kind of like a what was deleted like you say a channel did they delete the whole team so there's no recycle bin and seriously how many times you need to be asked are you sure are you sure are you really really sure when you still call that an accident right you know Mike there is around the individual the content each of the containers which is why if you delete a channel you're telling me there's no recycle bin that you can bring that channel back I don't think so it's hard for me hard for me to believe that yeah I mean if you're just in teams and you right click and you you know say delete or remove channel or whatever it is it's hard for me to believe who Microsoft who has recycled bin everything now would not have that ability it just says you know yeah well yeah it is an orchestration whenever you provision or tear down something so huh just seems like it's something that you know I thought they would have by default it would be because you delete anything a resource you know in Azure and things like that it doesn't just go away there is the restore capability I was looking for the article for it so I've got one because you can go in because if the problem is that you're trying to go in and you want to remove permissions and archive something there's a process there's the ability to go in and archive that and then of course that's where you're removing access to those assets and removing permissions but you want to retain all the content versus deleted outright and there is a process to restore a deleted group and a deleted team so I've got the link here I'll post it into chat which I know is great for visibility here but I'll have it in the blog post as well so yes Mike there is that process you don't have to be angered of something you know that we just lose Mike seems so okay he was so fed up he was so disgusted with the fact that he thought you couldn't restore a deleted team he just laughed he stormed out he rage quit yeah like he had to start early anyway says probably what happened there he probably lost time and needed to jump alright question number 10 Carol asks is anyone else having issues creating a microsoft list from excel I formatted it as a table have no blank rows and no dates I've created new workbooks formatted them all as text tried creating from an upload from one drive from an excel store to the doc library same site I'm getting an error sorry something went wrong no matter what I try it's happening in two completely separate tenets and I'm pretty frustrated the only solution I could find that I can make work was to create a list by importing a spreadsheet to an on-prem environment using IE yuck and copying the results list to the tenant using third-party solution yeah I'm confused by that yeah that we lost and Neil in disgust stormed off as well I did something going on well I've done this often actually right now I'm working on a project where we're doing microsoft forms using the quiz and power apps does not post the score from the quiz yet there's no way to capture that if you guys know how to do that I would love to hear how you fix that but I'm having to export it from excel and paste it into a list manually and it works just fine the only thing I can think of is it's the data types that don't match or the field orders don't match whatever columns are using there's something off about that but otherwise I'm doing this all the time so I almost want to talk to Carol and find out how she's trying or who was that Julie the difference between whether it's creating it just so I'm confused is it creating it from scratch or importing data into an existing one because having the mismatched data types or columns that would make sense importing into an existing but if I was creating a list from scratch well I'm wondering if she just should remove the table formatting and just do it as plain text and copy and paste that in it might be a better option because maybe when she's formatting is a table it's recognizing something as far as the data types and not happy about it I'm not sure or you know if it's a text field only has a limit of 255 characters so if there's something in there is longer than that then it's going to air out because it doesn't meet the criteria for the destination list I do this all the time so I'm not sure I almost want to say Carol call me because these are the things I take personally like why isn't it working so but yeah and she said she's using Sharegate too so she's tried it with that as well but I'm not sure yeah so it's this is one of those scenarios where I think we can sit here and speculate but I think it needs to be a conversation and understand a little more about what she's doing so it's not even a it's not a homework item yeah like help us help you Carol I'm too obscure email me at shortcutshari.com and see if I can help her so yeah those are good should clarify that when you're saying that it's like email me me at kind of stuck it's easy to remember because nobody can spell my name correctly but and then they'd have to spell it twice correctly so if I did shari at shortcutshari.com when I'm emailing you and I type me and I get to I get I get you and Erica Tully as well has yeah I notice she did the same thing it's awesome to see you mail me which me at shortcutshari.com there you go yeah well let's see question number 11 Karthi says is there a way to copy all the teams chat history to one note or one drive while using teams exploratory license which I believe means the free license I was just looking that up because I know in my tenant they're like you're eligible for the exploratory license I had no idea what that meant so I had to go look it up but basically if they don't have a license for teams they can participate in the meetings but does anybody have a way of testing to see if they can capture the chat other than highlighting it all and copying and pasted yeah there's there was a bit of a discussion about that during the night one of the sessions and as I recall there is nothing built in that will let you do that you can copy and paste as you suggest yeah they have a send to outlook or save to or share to outlook button and some of the chat but it's not the entire history it's just one one message or one thread but it would be nice to have that just kind of like outlook you send to one note you know be nice to be able to capture all that because eventually chat goes away and for a lot of organizations actually especially the government there I think some of the agencies are limiting to 90 days of history or 30 days of history so they it all gets deleted and if you want to have that for reference later one note is your best option so yep well even if you had kind of an easy way to export to another Microsoft product like notepad you know just only export to notepad or something but if you had something just simple like that but I get it is like look if you want the richer features which includes exporting or saving the the chat files and you got to pay for the license right well and I was just going to I was going to see if anything was on user voice to have people vote that up because I think it would be a feature that be useful for many different use cases so yeah you look at something like that though it's like yeah be nice but then it's a free version so it's not something that's driving dollars for Microsoft to go and do it so it would be a load and no pry you know request taking out the exploratory license so I in my mind that would be a feature that would be helpful regardless of what version they're using but it's not available in any version so alright question number 12 Athena asked is there any way to make certain views not able to be seen based on SharePoint group or other within SharePoint online no third party options please however I'm open to low code solution so it's we see a variant of this question you know quite a bit that I think our last couple episodes we had a version of this question of restricting views that are access to a view you know there's been a like can I you know we've talked about restricting view per per item people can only see their own entry their own item that they're adding to a list yeah you can default I mean there are ways to depending on you know the specific situation there are a couple different options I mean the different queries that will pull data back can be written to center on yourself so that you pull back what you have control or have authored SharePoint audiences are another way to segment what people see but they are not a security mechanism so you know search queries if we're talking content search web part that can also be used with the query builder is very effective at building different search queries that will drive output based on how you want to partition it so there are several different ways to do this it just depends on the specific situation yeah I I use pages and create different views on pages and secure the pages but that doesn't prevent people from going to the source list if they're savvy enough there's third party tools that do that and to her point she doesn't want a third party tool but welcome to my world I've been using SharePoint for 20 years and we've been asking for a secured views for a long time the only other thing you can do is sometimes split the list so that you have a look up to another list and they recombine it in a view that people can't see but there's no good work around to that at all except making the only public view a me view and don't allow people to create their own views then that's a possibility but it still doesn't prevent them from getting into the back end of the list if they can see the list at all all right question 13 Michael asks hello all I just installed SharePoint 2016 and I'm trying to run PowerShell commands and I'm getting errors running the pss n a p i n p s snap in yes it says running the p s snap in they haven't been registered how do I register them please when you install SharePoint if you're on a farm member server go to your start menu and open up the SharePoint PowerShell console window basically that will auto that in that window the the necessary snap ins are registered if you're just trying to do it with a generic PowerShell snap in window that's probably where you're running into problems and in which point you can easily import them but Microsoft does drop a nice little shortcut in the SharePoint start menu folder for SharePoint PowerShell and that'll give you quick access to those commandlets that you're trying to get to Neil you're muted can you hear me now you can just run the or what is it there's a shortcut in NSP and you can just literally you can really change just do like star s h star and it'll just bring the SharePoint ones in OSP style just bring the SharePoint ones if you submit cheating but it works yeah so if this guy but it works if this guy's having trouble getting the snap in and the commandlets to show up he might not even be he might not have a remote sign policy set up and what not yeah it would tell you that though I mean I should yeah PES snap in so lazy yeah handful of different ways to do it and make sure you do it with an administrator prompt yes that's all you need to do should work there's a number of switches you can there as well like from Verify and Confirm and all that kind of stuff don't ever route if it's already added all those kind of things are there it's just been a while since I've done it yeah Neil's got you Michael alright let's see here oh hey this is another one where the question was written in a way that I was excited to read through there's actually three questions here but Matthew says to come on let me get that out of the way I hate when that happens this is the Kylie Minogue question yes to quote the great Kylie Minogue I'm spinning around still yep I'm still going around in circles trying to get the required privileges so can somebody clarify if I understand this correctly so three questions here is a group site basically a supercharged team site based on a team's template Sharon has put a great post in the chat window for this one for the whole piece the standard demystification of groups versus teams whenever you create a team you create a group but when you create a group you don't necessarily create a team so the teams is that layer of collaboration on top of the foundation that includes the active directory group the email account the SharePoint site so no it's kind of back the opposite would be my answer on that one is it basically a supercharged team site anybody else agree with me I want to add to that okay but I put the there's a great article there that tries to explain it and of course pictures always good so there's a picture kind of a graphic in there and what they're at I like pictures B2 and then I like crayons that's my speed B2 Neil so do we want to go to part two there was a cutting remark that I thought I was so clever when I was about 15 years old and somebody had asked repeatedly like just a dumb question and I responded shut out to them was like do you need me to write it in crayon for you and I just and I realized and I was I was in a class and it was a college class and I felt like such an ass afterwards I think it was to the TA or possibly the teacher that I was so you weren't making friends on that day I'm guessing I was not I had repeated myself several times and yeah I felt bad afterwards I'm sure you're like that sounded better when it was in my head not satisfactory and it was the should have been the internal voice not the external voice but yeah so yeah so the second part of the question Sherry to point is like if I start at the tenants parent level with a team site or group site can I only then create subsites based on the ugly teams template that's a yes but the you know Microsoft is not really encouraging the use of subsites anymore so the better structure is to create a modern site as a hub and then additional sites for the you know the sub site that he would create but I still feel there are reasons to have subsites because I use manage metadata and content types and so yes but you can add modern pages to the ugly team site template and may not be quite so ugly so doesn't mean you don't have the modern capabilities just the the templates that are there and again is he on prem or is he in the cloud so I'm assuming well teams it would assume the cloud yeah I'm guessing so but he wasn't but if somebody else has that situation and they don't they weren't actually talking about teams but yeah yeah and they were not talking about the teams the ugly teams template as a Microsoft teams were talking about the teams collaboration SharePoint template right yes thank you for that Sherry that's where I was going to go I know I just had to step away for a second so I didn't know whether you got to this point but the teams you know the concept of the teams site is the connection path like the the path you know we have like slash sites slash teams I think sometimes people confuse the two are they certainly confused when it's a slash teams I assume they're getting a team site but that's not the case it's just that that's a that's a managed path right it's different because we're reusing the same term for 20 things okay yeah yeah well I need to create a teams team for my team with a sub site on the teams sub site yep well the third point here is so it seems to me that if I start at the parent level with a communication template site I can create sub sites with either the teams template or the communications template is that right I believe so I'd have to test that but no I think the sub sites are the same I didn't get that far in my research yet so yeah Neil I think I also heard that Sherry was volunteering to take some homework I hate it I verify like I said people argue with me when they said no structure should be flat we shouldn't be having sub sites anymore but I do believe there's a place for that so I'd be I could write a blog post on that and then refer back if you want what's interesting too off of each of those templates whether you can go and create I thought again this is I'd have to go and play around but communication sites were kind of an end node but yeah yeah alright we've got Sherry assigned homework and I'll follow up with you on that communication site and team sites when you create a new site collection they have the same functionality just how the home page is presented and what content is populated by default from that template you can build whatever it doesn't mean you can't put a hero web part on a collaboration page and make that the homepage of a team site just whatever content you were hoping to start from so I don't know why there would be a different option for sub sites underneath the two different options so what's the longer conversation around Matthew's questions and what are you trying to accomplish getting caught up in what templates and what should be in each of the different places like you can go and build whatever you need to do there it just how much overhead how much management will require based on if you move away from the standard out of the box templates or navigation make sure you plan it that's the biggest thing that people fall short on is they don't plan their structure their architecture correctly and then they just start building stuff that doesn't fit together and then that's why people like me as a consultant have a job because they want us to come in and clean up their mess because they have 20 sites that are doing the same because nobody sat down and planned it out together so you know I don't if you saw there was a so Mark Cashman and Sue Handley published an information architecture kind of shortcut guide that's awesome okay let me let me find the link here yes I will I follow Sue and I will she's my spirit animal yeah yeah before I joined this community I had people say do you know anyone else like you and I said really no but now I do like so it's awesome I love Sue she's amazing and Mark too you know obviously yeah Mark's okay he's alright a lot of my children's reading material came from Sue from her kids when they were done she had a bunch of young children's books that she gave to us when we were in DC one time for like a SharePoint Saturday or something and we took them back oh that's awesome yeah I kept a few that my children loved dearly in the anticipation that they have kids someday but we did the same thing we donated them to the school and to a preschool so you got to share a lot of I just saw that Gennady had a a cashman coffee cup really that's awesome I want a cashman coffee cup and come on where's this alright I'll continue to look and I'm not for some reason why am I not finding that I'll see if I can find it if you want to go to the next right yeah okay let's see question number 15 says hi guys how are you doing how do you restrict members of the group from accessing the group recordings on the channel so you've got a channel you've recorded meetings you've recorded group recordings and now you want to restrict access to those things those recordings go to one drive now right well that was my question it depends where was it stored to because it was in stream or is it in a library if it's in the library you can change the permissions on it but yeah stream right stream everyone in the group everyone in the meeting has access but with what with the newer the homework member last time we had the homework about understanding why we moved it to one drive so that would then be in a library so you could modify the permissions it's one of those questions that needs more elucidation to use a posh word nice one Neil I read that somewhere I'm sorry I was still looking for the link because here it is is it this one is the IA value oh so that's back from July I'm just looking on our white papers on our site this is it right here so I'll add that to the link to the last one as well alright so we got six more minutes to see if we can one or two more here number 16 Jonas asked my company is in a process of deploying teams throughout the company and I want to be able to use teams to do status reports and track monthly goals is there a feature already embedded to do this any advice on how to track projects from the engineering perspective kind of goes back to some of the answers that we had I mean like there's different different things here like one tool to rule them all to track projects from an engineering perspective you've got planner for the lightweight, flexible more ad hoc side, you have DevOps which is what most you know technical engineering organizations are using DevOps more and more which is you know again that con bond management but you know over within DevOps called JIRA yep Azure DevOps or third party solution JIRA for status reports I mean there's so many different ways that you could do that SharePoint site you know planner, a power app with a form a list where people upload or fill out the list directly I mean it depends like what what flavor do you prefer and Power BI dashboards based on a SharePoint list to be able to if they're looking for a real scorecard that's what came to mind for me yep yeah I'd agree sorry that's what we do my team you know I track I'm running with about 50 customers right now we have a custom CRM for tracking that but basically the back end there's literally a list we use SQL but it's effectively putting Power BI dashboard on top of that SQL list and allows us to track and build custom rules and custom reporting and flag you know this report this project's running late this project's on target all of that kind of stuff you can do Power BI integrates really well I just realized at question 7 the next one 17 is pretty much the same yeah Don says I would like to create a company scorecard to keep track the weekly goals and performance yeah Power BI dashboard for that kind of thing each department could have their own data and later consolidate to one that's how you do that roll up yeah the biggest problem there I think is it says the department user should not access other departments data but can access to the company dashboard so the dashboard is going to have to be published as a separate entity and not like if it's Power BI if you don't have access to the underlying data they're not going to see the dashboard at all right so it's well it's it's achievable yeah well it's just pulling from those different data sources you don't have to have direct access to the data source but can see the view of that consolidated data source so that's the way to do that you have to turn off the drill down in Power BI so that they can't get to deeper yeah yeah that's kind of where it's going they want to see the top level but not see all of the all the sausage making thought to underneath yeah all right sorry phrase a long number so the last question that I had captured here let's see if we can round it out here in a minute and a half as Lam says I have a macro code added via all the excel sheets in an Office 365 group that allows users to send emails from the excel sheet itself and we now we have now thousands of these sheets my question is if I need to change the SMTP mail as an example or change anything in the macro code and need this change to be applied across all the other sheets is there a cloud based on a third-party app that can do that oh god if you write one it's like just because you can does not mean you should oh my god well a you cannot have macro enabled sheets in a library you have to you can't open them in the browser you have to open them directly oh my goodness I'm so yeah just because you can does not mean you should oh here take key I would say the most probably there's no good answer to this but I think one possibility is if you need to change the SMT mail and it sounds to me like there's thousands of sheets and all of this mail is going to the same location since he's saying how can I change it all. Create an alias for that email address and then you just need to change the alias. That's what I would do. I think the solution is not right. The solution needs to be redesigned but that would give them a shortcut. If it's just a list of data then to me why is that not just a list in a SharePoint site or a Microsoft list now? I don't know why people are still using Excel as a database when there's better tools. I'm sorry. This is a personal thing. The tail of an Excel as a database that I built along while ago that the people decided they wanted to move to Excel which they did and I'm still left speechless. Yeah I wrote it. That would be tons of VBA code. Excel is not an RDBMS. That's okay. You can drive a nail with a pipe wrench. Well you've got as a hammer. Everything looks like a nail. I think, Eslam, you have all of us, we have all of our sympathies with this one. And on that high note, this episode of Office Hours and thank you for watching. Of course, I'll have the blog post up on Buckley Planet hopefully by end of day today which will have the link list to every question that's covered. It's all of the links that we've shared in our chat so you didn't have to take copious notes around those if you didn't catch them. Share all the links there but you can find that on buckleyplanet.com. Of course the recording out on YouTube, out on the Collab Tech channel so be sure to subscribe and join us. We'll be back at 8 a.m. Pacific and time is changing everyone so get ready to lose an hour of sleep here in the U.S. at least. That's happening what Sunday? Saturday night Sunday morning? Yeah. Because you're going two weeks later. At least we're not traveling anymore and having to change. Usually on spring ahead weekend I am going to the East Coast and then I lose like three hours. How does it change at all? There's like two or three locations in the U.S. that don't need to change. But anyway, well thank you all for joining on the panel. Thanks for those that are watching and we'll catch you next week for the next live show. Absolutely. Thanks gentlemen. Bye. Bye.