Recent Discussions
Excel formula to determine missing numbers
In column S of Sheet 1 I have a list of case numbers. They all start with the year that the incident occurred &, followed by the incident number. On Sheet 2, I want to be able to quickly determine if any numbers in the sequence have been skipped. For instance, 2024-033, 2025-001, 2025-003, etc. There are never a set number of cases per year, so it wouldn't matter whether there should've been a 2024-034 after #33, but I would need to be able to readily see that 2025-002 was never input. If it matters, each year begins with '001' and not '000' and I'm working with Excel 2016.
Conditional Access enforces MFA but Service Account still ask to secure account
Hi, I've setup Conditional Access policies to enforce MFA. But it excludes a group for service accounts. Whenever we login to a Service Account, they all ask to secure your account. Hit next > It says no MFA options are available > Skip. Both our own MFA conditional access policy and MS per-user conditional access policy excludes this group. The Legacy per-user authentication policy has all accounts disabled there in favour of the conditional access policy. We must be missing something here. Some of these are shared inboxes, others regular user accounts. Many of these services requires login through the typical Microsoft sign in screen to authorize access. Some does not support OpenID. So how do I 100% exclude service accounts from MFA? And how do I get rid of this popup to secure these accounts when it says no MFA options are available? TIA
Group objects
Hi, I am a longtime user of Word. I have just transferred to a new and stronger laptop; however, when trying to group more than 5 items Word stops responding and sometimes crashes. I disabled all add-ons, hoping it would help. Any ideas? I usually insert the figure in a table and just group the callouts and text boxes with arrows.
Section Headers and Footers - 'Same as previous..'
Hi All Just seeing if anyone has a workaround for section headers and footers issue i'm having.... I have a document that multiple sections, each section has a 'Different First Page Header/Footer' as there are different header images for each section. The footer is pretty standard across the document - page numbers and specific document info... My document has..... (for example) Section 1: First Page Header/Footer (page 1) Section 1: (pages, 2, 3, 4, 5) Section 2: First Page Header/Footer (page 6) Section 2: (pages 7, 8, 9,10) and so on.... If i try 'Same as Previous' on 'Section 2 First Page' footer (page 6) it takes the footer text from 'Section 1 First Page', rather than Section 1: Page 5 If i try 'Same as Previous' on 'Section 2: Page 7' footer, it takes text from Section 1: Page 2, rather than Section 2: First Page: page 6 Is there any way of just making the footer continuous across the whole document? without changing the header which is different for each section.?? At the moment i'm having to edit each footer for each section which can be tiresome at best. Anyway, hope that makes sence Thanks for your help in advance. JAccessing an App through 'Open in new window' from Teams only opens file error
Hello, I have deleted an Excel file from a SharePoint folder that I don't need anymore. Now, when I try to open Excel 365 from 'Open in new window' in Teams, I don't get to the usual landing page with recent files, options for a new file, etc. but just an error message: 'Sorry, this file has been deleted or moved', referring to the file that I have indeed deleted. I can access the usual landing page if it's in the Excel 365 window embedded in Teams, but opening the app in a new window is no longer possible. Why would the landing page for opening an app in a new window not be the normal landing page, but just an error message, with no option to open another file, seems counter-intuitive. Does anyone have a solution? Best regards, MJTroubleshooting Common Issues in SharePoint Online
SharePoint Online, part of Microsoft 365, is a powerful collaboration tool that helps organizations manage documents, workflows, and content across teams. However, like any platform, SharePoint Online can occasionally run into problems. Below are some common issues users face and troubleshooting tips to resolve them quickly. https://dellenny.com/troubleshooting-common-issues-in-sharepoint-online/
Windows Sound Problem
Hello, I am using windows sound control now but have a lot of problems. I am using Steinberg UR24C and Focusrite as soundcards. I have three speaker systems connected, one for my computer, one for music production and one for home cinema Windows detect these but most of them gives no sound when selected. I therefor am lookiing for a replacement of windows sound control. Any who have similar problems and can hint me for a good replacement program? Regards, Bernhard
Range showing (table array) in the wrong place
I’ve got a VLOOKUP pulling data from another excel file (sources.xlsx) the formula works as intended it's pulling the right department names based on id number, but here’s the weird part, when I double click the formula to check it, the table array ($A$2:$B$23) gets highlighted in the current sheet instead of the actual source sheet (which is in the other file). The data is still coming in correctly, just excel is showing the range in the wrong place. Is this normal when referencing another workbook? I never experience this before, and I am not sure if it new thing or a bug ExampleOffice 365 Problems
Hello everyone, I have been experiencing the following problem since today: As soon as I try to open Excel, Word, Outlook, etc., they close again immediately. Online repair and reinstallation did not improve the situation. Some of my colleagues are experiencing the same problem. Background: We roll out updates at intervals. The users who were in the first interval are experiencing these problems. The update interval has been stopped, but unfortunately I can no longer undo the update. The following version is displayed: Version 2509 Build 16.0.19231.20138. The computers are running Windows 11 with the 24H2 update. Does anyone have the same problem or know a solution? Thanks in advance.Maintaining Productivity During Hybrid or Phased Rollouts in Microsoft 365
Rolling out Microsoft 365 (M365) in phases—or running a hybrid setup where cloud and on-premises environments coexist—can help organizations manage risk, budget, and change effectively. However, without proper planning, these transitions can easily disrupt productivity. The good news: with the right approach, your workforce can stay connected, collaborative, and efficient throughout the rollout journey. In this post, we’ll explore how to maintain productivity during hybrid or phased rollouts in Microsoft 365, focusing on practical strategies, governance, and change management. https://dellenny.com/maintaining-productivity-during-hybrid-or-phased-rollouts-in-microsoft-365/External people can't open files with Sensitivity Label encryption.
Question: What are the best practices for ensuring external users can open files encrypted with Sensitivity Labels? Hi all. I've been investigating proper setup of sensitivity labels in Purview, and the impact on user experience. The prerequisites are simple enough, creating and configuring the labels reasonably straightforward, and publishing them is a breeze. But using them appears to be a different matter! Everything is fine for labels that don't apply encryption (control access) or when used internally. However, the problems come when labels do apply encryption and information is sent externally. The result is that we apply a label to a document, attach that document to an email, and send it externally - and the recipient says they can't open it and they get an error that their email address is not in our directory. This is because due to the encryption, the external user needs to authenticate back to our tenant, and if they're not in our tenant they obviously can't do this so the files won't open. So, back to the question above. What's the easiest / most secure / best way to add any user we might share encrypted content with to our tenant. As I see it we have the following options: Users have to request Admins add the user as a Guest in our tenant before they send the content. Let's face it, they'll not do this and/or get frustrated. Users share encrypted content directly from SharePoint / OneDrive, rather than attaching it to emails (as that would automatically add the external person as a Guest in the tenant). This will be fine in some circumstances, but won't always be appropriate (when you want to send them a point-in-time version of a doc). With good SharePoint setup, site Owners would also have to approve the share before it gets sent which could delay things. Admins add all possible domains that encrypted content might be shared with to Entra B2B Direct Connect (so the external recipient doesn't have to be our tenant). This may not be practical as you often don't know who you'll need to share with and we work with hundreds of organisations. The bigger gotcha is that the external organisation would also have to configure Entra B2B Direct Connect. Admins default Entra B2B Direct Connect to 'Allow All'. This opens up a significant attack surface and also still requires any external organisation to configure Entra B2B Direct Connect as well. I really want to make this work, but it need to be as simple as possible for the end users sharing sensitive or confidential content. And all of the above options seem to have significant down-sides. I'm really hoping someone who uses Sensitivity Labels on a day-to-day basis can provide some help or advice to share their experiences. Thanks, Oz.
Azure AD Health Failing
I am on the latest version of Azure AD Connect (2.5.79.0)... There are no network/DNS/connectivity issues at our site, it seems to me that Azure AD Health Service is having trouble because the endpoint is experiencing a service issue.. Is anyone else having the same problem with failure alerts/etc? I checked by running "Test-MicrosoftEntraConnectHealthConnectivity -Role SYNC" command, the stack trace throws an undocumented error number and complains of rate limiting issues... smells like the server is being overwhelmed or there are other issues slowing down the endpoint/service with the consequence that connections are piling up causing this error: Connectivity Test Step 1 of 2: Testing dependent service endpoints begins ... AAD CDN connectivity is skipped. Connecting to endpoint https://login.microsoftonline.com Endpoint validation for https://login.microsoftonline.com is Successful. Connecting to endpoint https://s1.adhybridhealth.azure.com/providers/Microsoft.ADHybridHealthService/diagnostics/version Endpoint validation for https://s1.adhybridhealth.azure.com/providers/Microsoft.ADHybridHealthService/diagnostics/version is Successful. Connectivity Test Step 1 of 2 - Testing dependent service endpoints completed successfully. Connectivity Test Step 2 of 2 - EventHub data upload procedure begins ... Tenant Id is successfully collected during agent registration. Server rejected Eventhub data upload, here is the exception: Microsoft.ServiceBus.Messaging.ServerBusyException: The request was terminated because the entity is being throttled. Error code : 50002. Sub error : 101. Please wait 4 seconds and try again. To know more visit https://aka.ms/sbResourceMgrExceptions and https://aka.ms/ServiceBusThrottlingS:N:ADHSPRODWUSEHSYNCIA:EVENTHUB:ADHSPRODWUSEHSYNCIA~22527,CL:30,CC:32,ACC:356250,LUR:WinEnd,LUT:2025-10-08T03:03:12.2035867Z,RC:1 TrackingId:<<< anonymized tracking ID>>> 0, SystemTracker:adhsprodwusehsyncia:eventhub:adhsprodwusehsyncia~22527, Timestamp:2025-10-08T03:03:13 at Microsoft.ServiceBus.Common.ExceptionExtensions.ThrowException(Exception exception) at Microsoft.ServiceBus.Common.AsyncResult.End[TAsyncResult](IAsyncResult result) at Microsoft.ServiceBus.Messaging.EventHubSender.Send(EventData data) at Microsoft.Identity.Health.AgentV1.ConfigurationPowerShell.TestAzureADConnectHealthConnectivity.TestInsightServiceDataUploadProcedure() Azure AD Connect Health agent could not communicate to the Health Service using port 5671. As a result, agent communication will fall back to use port 443, but use of port 5671 is recommended. Please allow outbound communication using port 5671. Tenant Id is successfully collected during agent registration. Server rejected Eventhub data upload, here is the exception: Microsoft.ServiceBus.Messaging.ServerBusyException: The request was terminated because the entity is being throttled. Error code : 50002. Sub error : 101. Please wait 4 seconds and try again. To know more visit https://aka.ms/sbResourceMgrExceptions and https://aka.ms/ServiceBusThrottlingS:N:ADHSPRODWUSEHSYNCIA:EVENTHUB:ADHSPRODWUSEHSYNCIA~22527,CL:30,CC:32,ACC:356837,LUR:IncomingUsage_ADHSPRODWUSEHSYNCIA-5,LUT:2025-10-08T03:03:54.9448143Z,RC:1 TrackingId:<<< anonymized tracking ID>>>, SystemTracker:adhsprodwusehsyncia:eventhub:adhsprodwusehsyncia~22527, Timestamp:2025-10-08T03:04:00 at Microsoft.ServiceBus.Common.ExceptionExtensions.ThrowException(Exception exception) at Microsoft.ServiceBus.Common.AsyncResult.End[TAsyncResult](IAsyncResult result) at Microsoft.ServiceBus.Messaging.EventHubSender.Send(EventData data) at Microsoft.Identity.Health.AgentV1.ConfigurationPowerShell.TestAzureADConnectHealthConnectivity.TestInsightServiceDataUploadProcedure() Azure AD Connect Health agent could not communicate to the Health Service using port 5671. As a result, agent communication will fall back to use port 443, but use of port 5671 is recommended. Please allow outbound communication using port 5671.Data Validation Conditional Formating
I have a shared spreadsheet where coordinators enter staff codes for particular tasks they would like them to do (it's not a timesheet, just a future planning tool). I have set up a data validation to warn them if they enter a staff code that is not in the list, however if someone leaves after their code has been entered, the validation doesn't re-check so the now-invalid code remains happily in the spreadsheet. I need the cells to highlight if the staff code is not in the list. Does anyone know if this is possible? Currently, I need to search for each code as someone leaves and manually remove them from the spreadsheet and then ask coordinators to re-enter new values. It would be great if it would just flag them in red when I remove them from the staffing list and coordinators can see if there is (now) an error that needs fixing. Not sure how to attach a file as it's not 'link'able with a URL, so here's screen shots:EN-GB locale number formatting
Number format string "#, # # 0 ;[Color3] (#, # # 0 )" is not working when Excel is installed with en-gb locale. Any other language works but en-gb fails to parse "Color" - and expects it to be "Colour". Why is excel not following standard openXML in case of en-gb? How does one solve this portability issue when the workbook is generated on the server?Entra Agents are Promising but Could do More
Microsoft's Alex Simons came to the TEC 2025 conference to talk about the future of Entra ID, a lot of which hangs on the use of AI in components like the Entra agents that are now in preview. The idea of using agents to relieve hard-pressed human administrators is great, but only if those agents do more than a skilled human administrator can do, and that's not the case so far. https://practical365.com/entra-agents-could-do-more/
Recent Blogs
- Thanks to new enhancements in how images are anchored to surrounding text, screen readers can now detect and navigate floating images effectively.Oct 07, 2025
- In today’s fast-paced business landscape, small and medium-sized businesses (SMBs) face a constant challenge: do more with less and do it faster. The pressure to innovate, respond to market shifts, a...Oct 06, 2025
