Recent Discussions
Excel 365: dd-mmm-yyyy now gives Sept instead of Sep
Excel 365: dd-mmm-yyyy now gives Sept instead of Sep — that breaks the documented format standard. Who thought this was a good idea? They linked it to the Unicode locale standard. But it violates the formatting of "mmm". Work arounds for USA locale format as [$-409]dd-mmm-yyyy → 05-Sep-2025 UK locale [$-809]dd-mmm-yyyy → 05-Sep-2025 AU [$-C09]dd-mmm-yyyy → 05-Sep-2025 NZ [$-1409]dd-mmm-yyyy → 05-Sep-2025 Problem is this is not portable. PLease can someone reach out to the devs and get this reverted? Formulas trying to pick out Sep & year from the string now will break.
My Azure login is stuck at MFA and cannot proceed
In August, I was still able to log in to Azure, and by logging in through GitHub I could bypass 2FA. But now, no matter how I try, logging in via GitHub always requires 2FA. I can’t access my Azure account anymore—nothing works. The system prompts me to use Microsoft Authenticator to confirm a two-digit code in real time. My Microsoft Authenticator on my iPhone is logged into the same Microsoft account, but I’m not receiving any verification requests for Azure login. No matter how much I refresh, nothing shows up. I’ve already updated the Microsoft Authenticator app to the latest version from the App Store. However, my personal Microsoft account works fine and can log in without any issues.What to Do When SharePoint Search Doesn’t Return the Right Results
SharePoint search is one of the platform’s most powerful features—when it works as expected. But many organizations face a common frustration: search results that don’t seem accurate, complete, or relevant. If your users are struggling to find what they need, it can quickly undermine adoption and productivity. The good news? Most search issues can be diagnosed and fixed with the right approach. Here’s a practical guide to troubleshooting when SharePoint search isn’t returning the right results. https://dellenny.com/what-to-do-when-sharepoint-search-doesnt-return-the-right-results/Avoiding SharePoint Sprawl Without Killing Collaboration
SharePoint has become the backbone of collaboration for many organizations. Its flexibility is a blessing—teams can create sites, share documents, and manage projects with ease. But without governance, that same flexibility can quickly turn into SharePoint sprawl: a maze of redundant sites, duplicated files, and forgotten content that frustrates users and undermines productivity. The challenge is clear: how do you prevent sprawl without choking the collaboration SharePoint was designed to enable? Let’s break it down. https://dellenny.com/avoiding-sharepoint-sprawl-without-killing-collaboration/Common Mistakes When Upgrading from Older Office Versions to Microsoft 365
Many organizations are moving from older on-premises versions of Microsoft Office (like Office 2010, 2013, or 2016) to Microsoft 365’s cloud-based suite. The transition brings big benefits—real-time collaboration, enhanced security, and always-up-to-date apps. But without proper planning, the move can create frustration for users and headaches for IT teams. Here are some of the most common mistakes businesses make during the upgrade, and how to avoid them: https://dellenny.com/common-mistakes-when-upgrading-from-older-office-versions-to-microsoft-365/ExcelAt40 – Day 11: Lookup Wars – VLOOKUP vs XLOOKUP
Hello Excel fam 👋 Today’s post dives into the differences between VLOOKUP and XLOOKUP — with a visual comparison, practical tips, and even a quiz to test your lookup knowledge. We also covered how to use XLOOKUP with IFERROR for cleaner formulas and wrapped it all up with a cheat sheet. Would love to hear: 👉 Are you still using VLOOKUP? 👉 What’s your favorite XLOOKUP trick? #ExcelTips #ExcelCommunity #LookupFunctions #OlufemiBuilds #ExcelAt40
All the sensitivity labels are not showing in the new outlook
I recently noticed that some sensitivity labels are missing in Outlook. I used to see all four labels—Public, Internal, Confidential, and Restricted—but now I only see Public and Internal. The full list still appears in Word and PowerPoint. I just switched to the new Outlook experience and the issue persists there.People Settings Appear in the Microsoft 365 Admin Center
The Org Settings section of the Microsoft 365 admin center has a new People Settings section where you can choose properties for the Microsoft 365 profile card instead of using PowerShell. The kicker is that the old method of using Exchange custom properties to customize what appears on the profile card is being replaced with standard Entra ID properties. A migration is needed, and it’s easily done with PowerShell. https://office365itpros.com/2025/09/04/microsoft-365-profile-card-2/Cloud app conditional access exceptions
I have a lot of issues with attackers coming from VPN and anonymous IP's. Im trialing a Conditional Access policy to apply Conditional Access App Control. Ive created a Cloud App, Access Policy to blocks using IP address, Category, equals and listing a few categories like VPN and Risky. Then another Access policy to block IP address, Tag, equals Tor, Anonymous, Random, Botnet etc. Testing shows this works. But I've been asked what if we wanted to allow a specific service like NordVPN. How can I achieve this?
Formula to Autofill Value Based on Another Cell
I solved part of this but not the second part. I have these three columns on a document I am working on. I need a formula to do two things: If Column I lists a frequency (Annual, Biannual, Triannual) then K will autofill the next review date based on the date in Column J. If Column I lists TBD, then Column K should also autofill with TBD. In this scenario, Column J will remain blank. The formula I have so far is =IFERROR(EDATE(J2,LOOKUP(I2,{"Annual","Biannual","Triannual"},{12,24,36})),"") (I'm using IFERROR to hide the #NA returns in the blank cells.) I can't figure out what formula to add in to return a value of TBD instead of a date if Column I is TBD.
Help with formula
Hello! If I'm trying create a formula that pulls data from one sheet into another. I want it to pull in data in column E if column B has a january date AND column C has the word discover in it, into another tab within the same workbook. The formula below works perfect but the only problem is it has to be only the word "discover" (yellow cells) in the cell, if it says "discover - food" (green cells) it doesn't pull. Is there a way to have the formula pull the data if the word "discover" shows in column C but with other words like in the green cells? My current formula that kinda works: =INDEX('My ✓ing'!E:E,MATCH(1,(MONTH('My ✓ing'!B:B)=1)*('My ✓ing'!C:C="Discover"),0)) Pulling from this sheet below Into this sheet in the same workbook. The yellow ones work because it just has discover, the green is not cause it has Discover - food. Is there a way to get it to search for the word discover and not necessarily match? Thank you for any help!
Task Bar Office context menu shows wrong recent file
I try to always save my office files locally, and let Onedrive sync to the cloud. However, the TaskBar right-click context menu of (say) Word always offers the cloud version under 'recent'. I have to go and find the local version, and open that from File Explorer. Then i get TWO versions under recent, and can delete the online version (which I don't want to load). I have a single personal PC, and prefer to work with local files (quicker) but know I have the online files for security/backup, and can access them from iPad and phone.Accessibility Features in Microsoft 365 That Most Admins Forget to Enable
Microsoft 365 is packed with accessibility tools designed to make digital workplaces more inclusive for everyone. However, many of these features remain overlooked or underutilized by IT administrators. Ensuring accessibility isn’t just about compliance—it’s about empowering every user to contribute fully. Here are some accessibility features in Microsoft 365 that admins often forget to enable (or configure correctly), along with steps on how to turn them on. https://dellenny.com/accessibility-features-in-microsoft-365-that-most-admins-forget-to-enable/Lesser-Known Microsoft 365 Features That Save Hours (Beyond Teams and Outlook)
When most people think of Microsoft 365, they picture Outlook for email and Teams for meetings. But beneath the surface, Microsoft 365 is packed with lesser-known features that can shave hours off your week—if you know where to look. Here are some of the hidden gems worth exploring, along with quick “how to” steps so you can try them immediately. https://dellenny.com/lesser-known-microsoft-365-features-that-save-hours-beyond-teams-and-outlook/Enabling macro in trust center
Under the Trusted Center, Macro Settings and Macro Settings dialog the “Enable VBA Macros” has been selected along with “Enable Excel 4.0 macros when VBA macros are enabled” has selected. Along with this I am using the Personal.XLSB file to hold the macros. I have attempted multiple times to enable the macros within the workbook with no success. I first open the Personal file then the workbook of interest. Upon opening I do not receive a header to enable the macros. I then attempt to run a macro and continuously receive the error message that I must enable the macro and reopen the workbook.
Validação de Dados: como evitar que Ctrl+V contorne as regras?
Olá a todos, Gostaria de partilhar uma situação com a comunidade para perceber se existe alguma solução ou truque menos conhecido. (sem macros) Estou a utilizar a funcionalidade de Validação de Dados no Excel para restringir a introdução de valores num determinado intervalo (exemplo, apenas números inteiros entre 1 e 5). Quando os utilizadores introduzem os dados manualmente, a validação funciona corretamente e impede entradas inválidas. Contudo, se os utilizadores fizerem Ctrl+V (colar) seja de outra folha, do mesmo ficheiro ou até de outro ficheiro o Excel ignora completamente a validação de dados e aceita os valores, mesmo que não cumpram os critérios definidos. Já experimentei as seguintes alternativas: Proteção da folha → não impede colagens. Formatação condicional → apenas assinala visualmente, não bloqueia. Listas suspensas com validação → também são ignoradas em colagens. Sei que através de VBA é possível detetar e anular colagens, mas a minha questão é a seguinte: Existe alguma forma de impedir a colagem (Ctrl+V) num intervalo com validação de dados, sem recorrer a VBA? Agradeço desde já qualquer partilha ou sugestão que me possa ajudar a contornar esta limitação. Se não existir uma forma de impedir esta situação sem recorrer a VBA, então considero que seria útil sugerir esta funcionalidade à Microsoft, para que a Validação de Dados pudesse ser respeitada também em colagens (Ctrl+V), tal como já acontece com a introdução manual. O que acham? Aguardo o vosso feedback e, caso já tenham passado por esta situação, seria muito útil conhecer a vossa experiência e forma de lidar com o tema.
Recent Blogs
- Your product will still work, but when Microsoft says a product has reached "end of support", it means the product will no longer receive: Security updates Non-security updates Bug fixes Ne...Sep 04, 2025
- Customers in Austria now have new options for managing the location of their Microsoft 365 data.Sep 02, 2025
