Recent Discussions
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.
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.[Excel Formula?] How to calculate a product's sales rank based on 3 criteria
Hi, is there a formula that can calculate a Product's Sales Rank in year 20xx (starting with 1 as the 'highest' rank in the year 20xx) that corresponds with the Product Name AND the Sales Year. The end goal is to have the formula in columns D, E, and F, so that columns D, E, and F each show how the different Products ranks in total sales. The end-user wants those ranks displayed in 3 separate columns directly to the right of the sales total (so the rank values replace the question marks). The end-user is primarily interested in analyzing the results in columns D, E, and F, and in seeing how each product's ranking has changed between 2021-2023. The end-user fully understands that columns D, E, and F will contain duplicate results. Those duplicate results are important to have displayed. Thank you. Sales Year Product Name Sold Sales Rank in 2021 Sales Rank in 2022 Sales Rank in 2023 2022 Red Hat 100 ? ? ? 2023 Red Hat 75 ? ? ? 2023 Green Hat 60 ? ? ? 2021 Yellow Hat 55 ? ? ? 2021 Red Hat 115 ? ? ? 2023 Yellow Hat 90 ? ? ? 2021 Green Hat 20 ? ? ? 2022 Yellow Hat 40 ? ? ?Microsoft Deprecates Graph CLI and Toolkit
Microsoft has depreciated the Microsoft Graph CLI and Graph Toolkit. It’s nice to see some rationalization in this area, but the real need is for better quality and coverage across all the Microsoft 365 administrative actions. Even after fourteen years of development, too many undocumented and private APIs exist in use today in places like the Microsoft 365 admin center, which is an unacceptable situation. You should vote for a feedback portal item (link in article) to ask Microsoft to do better. https://office365itpros.com/2025/09/02/microsoft-graph-inconsistencies/
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
