Recent Discussions
REGEX+TEXTSPLIT
Dear Experts, I have a data like below in column"A":- And , I want to split it in the way like in "Yellow" So, after each consecutive Alphabet or number it should be splitted, I tried to do something in Column "B" but not succesful. Could you please share any solution if possible by using a comb of regex + textsplit? Thanks in Advance, Br, AnupamWhat’s the Best Way to Manage Guest Accounts?
Guest account management should be a part of every Microsoft 365 tenant administrator’s checklist, unless the tenant has no guests. That’s possible but given the way that workloads like Teams and SharePoint Online create new guest accounts, the average tenant is likely to have quite a few guests. The question is how to manage guests – with Microsoft’s tools or using tenant-designed PowerShell scripts? https://office365itpros.com/2025/09/18/guest-account-management/
Excel Formula Help
Hi everyone, i am needing help pulling data from one sheet to another. The "DATA" tab is a bunch of data that is pulled from a Microsoft forms survey and i copy and paste it in the sheet. Once i copy and past the data i want all the other sheets to pull this data into its perspective tab. On the "DATA" tab in coloumn G is the district and each district has a different column for the module. So MRD districts module is column I, SLRD districts module is Column J, SBRD districts module is column K and so on. What i would is when data is pasted i want MRD ABC123 to pull the data from the "DATA" sheet onto this tab but it has to meet the 2 criterias. 1st criteria for the "MRD ABC123" tab is the Job Code in Column F on the "DATA" tab has to match ABC123 and the District column G in the "DATA" tab has to match MRD and then pull that data from the row on the "DATA" tab into the perspective columns on the "MRD ABC123" tab. Im just looking for a formula that will work for each column on the "MRD ABC123" tab to pull the data from the "DATA" tab. i have tried Index Match, Xlookup, and Filter functions but i know im doing something wrong. Any help would be amazing. thank you.
OneDrive Personal file path to Power Query
Hi, To get a file from Onedrive Personal to Power Query there was a method that used to work, and I used it few times successfully (video here: https://www.youtube.com/watch?v=RsL77ddhXoYbasically works with the path generated by the Embed option). However, this method doesn't work anymore as Onedrive changed something and the path generated is not the same, thus Power Query cannot identify the generated and altered path. Any idea how to work with the new generated path? Regards, Ayal Telem.Issues using Quick Import to create a multiple choice quiz
Hi, I'm having issues using the Quick Import option in Forms to create a multiple-choice quiz. It doesn't seem to matter how I format my Word document; when I use the quick import option, it dumps all the questions/ answers into one section. This is the Word doc format I am using. Any suggestions where I am going wrong?
Markup Panel appearing with every word document. Comments column now in some weird thing.
Good day, I am so confused I do not even know how to explain all the issues. 1) Opened a word document today that I closed yesterday. Opens up with some thing called a Markup Panel. Go to review and select no markup. Fine for now, but then appears every time I reopen the document, and all other documents. 2) Up until today, my comments were nicely formatted in a column on the right side of the screen. Now they are in some thing called a "reviewing panel" which is terribly formatted and located in the wrong place until I drag to to the right side. Is this something I have caused or some Word Update (God, I hope it is not the latter.) 3) Also, the little indicators next to the lines where the comments are located are no longer present, so the only way I know there is a comment on that line is by clicking on the comment in the stupid "reviewing panel" How do I get back to what I had yesterday? Thanks so much for your help. Dave
How to add 3 months to existing date mergefield in Word
I'm looking for a way to add 3 months on from an existing mergefield date («Calculation Date») in Word. Say the starting date is 16 September 2025 we'd want the new value to be shown as 16 December 2025. I cannot do this calculation in Excel as the mergefield data comes from a database and I have not used Macros etc before. Thanks
Cant access admin panel
Hi Everyone, I have done something really silly and I don't mind if I get a laugh or two, I have locked myself out of our two admin accounts due to both had 2FA on and the phone that the notifications went to sadly has been reformated without the person checking with me first, I have an E5 Licence but without being able to access the admin page I can't access support to get this resolved 😞 - I'm kind of stuck and at the moment even though we only have a few licenses (mix of E5and F3) Feeling really silly about this but if anyone has an idea of how I can resolve this I would be really grateful JoeHow to Build a No-Code Business Workflow in Microsoft 365
In today’s fast-paced digital workplace, organizations are constantly looking for ways to optimize processes without heavy reliance on IT or expensive developers. Luckily, Microsoft 365 offers a robust ecosystem of no-code tools that empower anyone—from business managers to project leads—to design and automate workflows with ease. With tools like Power Automate, Power Apps, SharePoint, and Teams, you can streamline tasks, improve collaboration, and boost productivity without writing a single line of code. Here’s a step-by-step guide to building your first no-code workflow in Microsoft 365. https://dellenny.com/how-to-build-a-no-code-business-workflow-in-microsoft-365/Staying Connected on the Road How Travelers Can Make the Most of Microsoft Teams
Traveling is exciting—new places, new cultures, and new adventures. But if you’re someone who works remotely, studies while traveling, or just needs to stay connected with your team, staying productive on the road can be tricky. That’s where Microsoft Teams becomes a true travel companion. Here’s how I’ve been using Teams to balance work and adventure while hopping across cities and time zones—and how you can do it too: https://dellenny.com/staying-connected-on-the-road-how-travelers-can-make-the-most-of-microsoft-teams/Access Still Struggles on Data Import
More of a comment than anything else I have been a frequent flyer of Access since version 2.0. We used it almost daily for several years. I have since retired, and was away from it for a couple years now. However, due to a recent Office 365 account I started using again. One of the problems we had over the years with Access was on large data imports. This appears to be the same problem today as it was 30 years ago. Excel does not have this problem. Some of the same issues with Access "Does not recognize header name" Checking to insure header name was not a keyword and all rules were enforced, still did not allow the data to be imported. Since I needed to quickly turn around the information I had to link to an Excel file and run the queries. Pondering if MS has really done any improvments or serious upgrades with Access. I know programs cost resources to update. The other 3 Office apps have far more users than Access. I think Access is going to wither away within the next couple years. Was a great run when everything worked right. I have used a lot of different databases over the years. However, Access was the runt who was very user friendly and an awesome reports generator.Entra ID’s Keep Me Signed In Feature – Good or Bad?
The Entra ID Keep Me Signed In (KMSI) feature creates persistent authentication cookies to allow users to avoid sign-ins during browser sessions. Is this a good or bad thing and should Microsoft 365 tenants enable or disable KMSI. I think KMSI is fine in certain conditions and explain my logic in this article. Feel free to disagree! https://office365itpros.com/2025/09/17/kmsi-good-or-bad/
Recent Blogs
- We’re making changes to the Microsoft 365 Copilot app for iOS that put key AI-driven capabilities and experiences front and center.Sep 17, 2025
- New Outlook for Windows has top-requested capabilities like pin important emails, add shared mailboxes as accounts, and newsletters.Sep 16, 2025
