Recent Discussions
errore nel salvataggio di maschere ERRORE DEFINITO DELL'APPLICAZIONE O DALL'OGGETTO
Da qualche giorno, a seguito di aggiornamenti, non si riesce a creare maschere e report guidati con Access. Al momento del salvataggio della maschera, compare il messaggio ERRORE DEFINITO DELL'APPLICAZIONE O DALL'OGGETTO. Faccio presente che fino a 10 giorni fa funzionava tutto perfettamente. Ho anche provato a disinstallare e reinstallare il prodotto.
Cannot Create Conversation on multiple ios and android devices with translator app.
Our schools heavily use the Microsoft Translator application on iOS and Android devices. Starting 10/2 all devices have started receiving the following error message "Cannot create a new conversation, please try again". This has been tested on iOS and Android devices and on multiple networks to verify the issue isn't related to filtering / firewall rules. Application has also been uninstalled / reinstalled and still receive the same error. It's clear this is affecting lots of customers yet we can't get any response from Microsoft on the issue. https://learn.microsoft.com/en-us/answers/questions/5580071/microsoft-translator-conversation-feature-stopped?comment=question#comment-2261689
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.Microsoft 365 Tips for Non-Profits with Limited Budgets
Running a non-profit means balancing passion with practicality. You want to maximize your impact — but every dollar counts. Fortunately, Microsoft 365 offers powerful tools that can help you streamline operations, improve collaboration, and boost productivity — often at little or no cost for eligible non-profits. Here are some smart, budget-friendly ways to make the most of Microsoft 365. https://dellenny.com/microsoft-365-tips-for-non-profits-with-limited-budgets/
Complete Form for various data
I need to create a form to be filled by users; the form should contain areas to add text and other areas to add photos, with a selection and dropdown lists. The form should have restrictions on the word count (a counter of the total words written and the remaining to reach the limit should exist on each tab beside the head of the tab or at the end after the final line), the photo size, and the format. I have tried to make a sample, and this is my best (edit pass is: 123): https://docs.google.com/document/d/1-Y1xjT8rCTEVFBijYS5wTGWSjewSjUKNAPmNaN3D7Qc/edit?usp=sharing I can't remove the highlighting on the text area and can't control or keep the document font and format when pasting from an external source (the current format is corrupted by pasting), and I can't even add the written words counter. Any advice is appreciated in this regard ...Spell Number in Bangladeshi/Indian Style By Excel Formula.
On web there is SpellNumber() VBA custom function which spell numbers to word in million, billion. We Bangladesh, India, Pakistan spell amounts like lakh, crore etc. Here is a formula to convert amounts to word in Bangladeshi/Indian style. In attached file there is also a generalize LAMBDA() named function SpellNumberBD(). =LET(x,A2,lr,TEXT(INT(x),"00000000000000"),cr,LEFT(lr,7),lc,RIGHT(lr,7),dec,ROUND(x-INT(x),2)*100,c,CHOOSECOLS, digits,{"One","Two","Three","Four","Five","Six","Seven","Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"}, Tenths,{"Ten","Twenty","Thirty","Fourty","Fifty","Sixty","Seventy","Eighty","Ninety","Hundred"}, SPELL,LAMBDA(val,abr,IFERROR(IF(val<20,c(digits,val),c(Tenths,LEFT(val,1)) & IFERROR(" " & c(digits,RIGHT(val,1)),"")) & SWITCH(abr,6," Lakh ",5," Thousand ",3," Hundred ",1," Poisa Only.",""),"")), Taka,SPELL(--MID(cr,1,2),6) & SPELL(--MID(cr,3,2),5) & SPELL(--MID(cr,5,1),3) & SPELL(--MID(cr,6,2),"") & IF(--cr>0," Crore ","") & SPELL(--MID(lc,1,2),6) & SPELL(--MID(lc,3,2),5) & SPELL(--MID(lc,5,1),3) & SPELL(--MID(lc,6,2),""), Poisa,IF(dec<=0," Taka Only."," Taka And " & SPELL(dec,1)),TRIM(Taka & Poisa)) Alternate Download Link (Google Drive).
Inconsistent “Wrap Text” Behavior Between Excel Desktop and Excel Web
We’ve observed inconsistent behavior with the “Wrap Text” format across different Excel environments (Windows Desktop vs. Web). Steps to Reproduce: Create or open an Excel file. Enter multi-line text in several cells and enable Wrap Text. Save the file locally. Upload it to OneDrive or open it in Excel for Web. Observe the displayed cell content without resizing the columns or reapplying formatting. Observed Behavior: On Excel for Windows (Desktop) → Wrapped text displays correctly. On Excel for Mac (Desktop) → Wrapped text displays correctly. On Excel for Web → Text may not wrap properly by default, requiring manual reapplication of “Wrap Text.” Expected Behavior: Cell content formatted with Wrap Text should display consistently across all Excel platforms (Windows, Mac, and Web) without requiring manual adjustment or reapplication. Excel Mac Desktop: OneDrive:Few cells in Date column is no formating
The "Date" column (E)was pulled from another excel file using xlookup. When I Try to format Date column few cells don't change at all. The cells containing dd-mmm-yyyy don't change. The cells containing 30 september 2025 changes when I format date column. I don't have issues with other columns. I tried custom formatting as well on date column but still the same few cells dont change at all. Can someone please help?Conditional Formatting
Hello, I am developing a conditional formatting rule that allows me to enter a specific text value, and if it matches the content of another cell, that cell will be highlighted in green. However, instead of highlighting only the matching cell, the entire selected range is being highlighted each time I enter a text value.Setting Up Conditional Formatting in Microsoft Lists
Microsoft Lists is a powerful tool for organizing, tracking, and managing information. But beyond just storing data, Lists also lets you visually highlight important details using conditional formatting — a feature that can make your lists more intuitive and actionable at a glance. In this post, we’ll walk through what conditional formatting is, why it’s useful, and how you can set it up step by step. https://dellenny.com/setting-up-conditional-formatting-in-microsoft-lists/
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.
Office 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.
Agent in SharePoint option is not visible in the M365 admin center
Agent in SharePoint option is not visible in my M365 admin center under pay as you go service and it's only show Syntex services option not the Agent in SharePoint. As before we were able to see both options like Agent in SharePoint and Syntex services but now Agent in SharePoint is not visible. I have also attached the screenshot where both of the options were visible but now the Agents in SharePoint option is not visible, so is there new update in admin portal or is this is some kind of issue?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.Microsoft Translator Conversation feature stopped working (“Unable to create new conversation”)
When trying to start a conversation, the mobile app (Android/iOS) shows the message: "Unable to create a new conversation. Try again." (Swedish version: "Det går inte att skapa en ny konversation. Försök igen.") About two weeks ago, the live transcription started to become very slow, with text appearing in large chunks instead of line by line. Shortly after that, the Conversation feature stopped working completely. We have tested this on multiple devices and platforms: – Android (several users, including myself) – iOS (tested by a colleague and a user we support) All users experience the same issue — no new conversation can be created. This function is used as a speech-to-text accessibility tool for deaf and hard-of-hearing users, so it is critical for communication support nationally in Sweden.How to filter visible cells by formula after applying filter to a dataset.
I have a dataset from A1:B11 (in real case many more). I apply a filter on dataset, for example filter data for Retailer1 and Retailer3. I want on a separate sheet to filter these visible cells using formula (not VBA). Preferably using a generic LAMBDA function like =FILTERVISIBLE(A2:B11). Any thought or idea to achieve it?
Recent Blogs
- You used to have to rely on external tools to crop a picture before putting it in OneNote. Not anymore!Oct 09, 2025
- 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
