Recent Discussions
Microsoft Launches Preview of Exchange Admin API
Microsoft launched the preview of the Exchange Admin API on November 17. The new API is intended to close known feature gaps that exist in the Graph APIs and allow developers to migrate from EWS before Microsoft retires EWS in October 2026. Think of the Exchange Admin API as a discardable time-limited API that allows clients to submit cmdlets for processing. It’s certainly one way to approach the EWS problem! https://office365itpros.com/2025/11/18/exchange-admin-api-preview/Creating a Service Principal Analysis for a Microsoft 365 Tenant
Understanding the set of registered and enterprise apps active in a Microsoft 365 tenant is important. Attackers can sneak in and plant an app to exfiltrate or otherwise steal data. This article explains how to use PowerShell to create a service principal analysis report that highlights common problems and gives tenant administrators the data needed to manage apps. https://practical365.com/service-principal-analysis-report/
I broke my spreadsheet dropdowns
Somehow, the dropdowns (data validation list) stopped working within my entire workbook. It is the "Weekly Schedule Planner" template that Excel offers. I added 2 additional picks to the list. Then I updated the conditional formatting to assign them specific colors. Somewhere in this process or perhaps accessing this shared file through M365 Copilot on my phone, the dropdown arrow on the cells is gone! The options are still there when using the formula box at the top, albeit only when I backspace first. I have tried everything I can think of to get the dropdown arrow to show, and it doesn't. The first column in the To do items as well as each day is set up with the list. I used Ctrl-G to make sure there wasn't an extra cell hiding somewhere, too. We will probably start fresh with a new file in 2026, so it's not the end of the world if I have to struggle through the next six weeks, but it might be. TIA for any advice that might fix this.SharePoint sync issues when opening from File Explorer
Hi there, Some users in my company are having issues with files not syncing with SharePoint when they save them and are also unable to concurrently edit files. They open the files via File Explorer and the 'autosave' functionality is disabled. Enabling autosave prompts them to save as a new copy. These users have recently switched to a new laptop running Windows 11 (previous laptop was Windows 10) and had no sync issues when using the old laptop. If the user first opens Excel/Word and then uses the File menu to open the document then the autosave is enabled and the file syncs with SharePoint. Here are some of the troubleshooting steps I've tried: stopping the sync and starting it again unlinking the pc and re-syncing the SharePoint site uninstalling and re-installing OneDrive Has anyone come across this issue or know of a fix that I haven't tried yet? Regards, Steve
Filter Function or any Logic
Dear Experts, I have a data like below , Column "H" has rnti's , Column "F" has sfn which can range from 0~1023( and once 1023 it shall start again from 0) slots that can range from 0~9, each sfn(say 252) has slots(0~9), Column "J" is Sn( Sequence number) , In Output , I want like this, example for the rnti 384, column "B" = count of spdu-1 for the rnti=384, and so on How the spdu-1 counted? (spdu-x's are counted per rnti & per-rlcCtrlAckSn_ ,) as below for example for rnti==384, Thanks in Advance, I posted this earlier also , not sure why post got deleted somehowMicrosoft FastTrack – Helping Businesses Adopt the Cloud
In today’s digital-first world, most organizations understand that moving to the cloud is no longer optional—it’s essential. From improving operational efficiency to enhancing security and enabling remote collaboration, cloud technology is at the heart of modern business transformation. However, the journey to the cloud can still feel overwhelming, particularly for companies with complex systems, strict compliance needs, or limited IT resources. This is where Microsoft FastTrack comes in. Microsoft FastTrack is a customer success program designed to help organizations adopt Microsoft Cloud services smoothly and confidently. Whether a business is embracing Microsoft 365, Windows 365, Azure, or Dynamics 365, FastTrack provides expert guidance, best practices, and resources at no additional cost to qualifying customers. Its mission is simple: to help businesses deploy cloud technologies faster, more securely, and with greater long-term value. https://dellenny.com/microsoft-fasttrack-helping-businesses-adopt-the-cloud-effectively/Privacy and Compliance Standards (ISO, GDPR, HIPAA) in Microsoft 365
As organizations move toward cloud-based productivity solutions, ensuring data privacy and regulatory compliance has become a top priority. Microsoft 365 stands out not only because of its powerful collaboration tools but also because of its deep commitment to meeting global compliance frameworks. Whether you operate in healthcare, finance, education, manufacturing, or the public sector, Microsoft 365 offers built-in capabilities that help you meet the strict privacy and security standards required in today’s digital landscape. In this blog, we’ll explore how Microsoft 365 aligns with three of the most influential compliance frameworks in the world: ISO, GDPR, and HIPAA. Understanding these standards—and how Microsoft supports them—helps organizations confidently adopt cloud services while maintaining control over sensitive information. https://dellenny.com/privacy-and-compliance-standards-iso-gdpr-hipaa-in-microsoft-365/How to Set Up Basic Security Policies in a Microsoft 365 Trial Tenant
If you’ve just created a Microsoft 365 trial tenant, one of the first things you should do—before adding users, syncing identities, or deploying apps—is lock down your environment with some essential security policies. Even in a trial tenant, you’re working with powerful cloud services that, if left unprotected, could be vulnerable to unauthorized access or misuse. The good news? Microsoft 365 comes with built-in tools that make it relatively easy to enforce best-practice security controls, even for beginners. In this guide, we’ll walk through how to set up foundational security policies in your Microsoft 365 trial tenant so you start off on the right foot. https://dellenny.com/how-to-set-up-basic-security-policies-in-a-microsoft-365-trial-tenant/
Simply cannot delete a section break. It is impossible. Cannot be done. Please prove me wrong.
So I was introduced to section breaks as a means of getting page numbering up-to-spec for book I've written (roman. numerals in the front material, arabic numerals in the book itself). I'm using the latest version of Word (16.8?) on Mac. To my horror, I've found that it is impossible to delete section breaks once they're in my document. I have spend an entire day in Google on this subject, and every single suggestion fails. So I have enabled showing markup, so I can see page breaks, section breaks, paragraphs I cannot select a section break. Word will not allow that. So I can't select and delete it. I cannot put the cursor after a section break and then hit the delete button as many suggest. Word will not allow the cursor to be placed after a section break. Putting the cursor before the section break, as other articles recommend, is just wrong. All you're doing there is deleting text before the section break. Why is this so hard? I've lost a whole day on something that should be simple. In the screenshot from my document below, The section break simply cannot be touched.
Excel help
Hello Excel Community. I would appreciate some help and support if possible with Excel. I am trying to set up a racking inspection check sheet, various aisles, bays and levels. The intention is to prioritise the severity of defects for repair/replace (Red, Amber and Green) with colour co-ordinated cell fill and record one of four types of defects against the earlier colour. Examples of defects would be, Upright, Beam, Crossbar and Pins. The first 3 defects could fall into all 3 repair priorities. Any support or guidance you could offer would be greatly appreciated. Many thanks ExampleHow to highlight duplicated sequential rows
I have a data like below sfn can range from 0~1023, and then again start with 0, slots can range from 0~19 I want to highlight the rows like below:- so, 331.12 is repeated in ROWS(4,5) so highlighted in Yellow, 331.13 is repeated in ROWS(6,7) so highlighted in Yellow and so on. if any Conditional formatting or anyother logic, by which we can highlight these data , would be helpful. Worksheet attached. Br, AnupamHow to Integrate Tasks from Teams Copilot to To-Do List
Microsoft Teams Copilot makes it easy to track action items from meetings and discussions. By integrating these tasks with Microsoft To Do, you can streamline your workflow and stay on top of your responsibilities. This blog will guide you through the process of syncing Copilot tasks with your To Do list. https://dellenny.com/how-to-integrate-tasks-from-teams-copilot-to-to-do-list/
Can multiple users fill out the same form?
I am looking to create a form that multiple users can fill out: For commercial purposes, I am seeking to fill out the first two questions of a given form. I want to then submit those answers and send the form to a third party (with a notification) for them to fill out the remaining questions of the form. Finally, I want them to be capable of sending through the remaining answers back to me. Is the above realizable through Microsoft forms?Outlook Encrypted Email Issues
I have deployed M365DLP controls to block password protected atachments that cannot be scanned and am telling users to use Outlook Encryption instead to protect outgoing email attachments. However, a number of external companies have reported not being able to open the encrypted messages and the screenshots provided show that they are trying to authenticate as a guest user in my Entra ID instance (rather than using their own IdP, SSO or an OTP). What would cause that and how do I resolve?
power query/ dax measure , multiple conditions/ multiple answers
I have loaded multiple tables in power query table of revenue per category: category revenue EM01 86.000 EM02 68.000 EM03 93.000 EM04 87.000 EM05 6.000 EM06 96.000 EM07 87.000 EM08 54.000 table of share per category per accountmanager: employee accountmanager share accountmanager EM01 AM1 75% EM01 AM2 25% EM02 AM1 100% EM03 AM2 100% EM04 AM3 100% EM05 AM2 60% EM05 AM3 40% EM06 AM1 100% EM07 AM1 50% EM07 AM3 50% EM08 AM2 100% Note: in same cases (EM01, EM05, EM07) multiple accountmanagers are in charge for a category. Total of share per category is always 100%. How to organize in power query to connect both tables to get table of revenue per per category per accountmanager? Use measure? Which? Or other solution? Answer (in pivot table) should be: employee AM1 AM2 AM3 total EM01 64.500 21.500 - 86.000 EM02 68.000 - - 68.000 EM03 - 93.000 - 93.000 EM04 - - 87.000 87.000 EM05 - 3.600 2.400 6.000 EM06 96.000 - - 96.000 EM07 43.500 - 43.500 87.000 EM08 - 54.000 - 54.000
Look Up FX Rate by Transaction date
Hello Folks, Attached you will find a link for a sample file where I am trying to do the following: https://docs.google.com/spreadsheets/d/1NeCSt8oAcEM86DAxI-8LkqTQK4D6WQvv/edit?usp=sharing&ouid=103354753371375324640&rtpof=true&sd=true Under the Data tab, if B2="C", then C2/xlookup(A2/FX Rate Oct 2025), C2) basically, if the Currency Code is C for Canadian then divide the Canadian $ on that transaction date by the reported FX Rate for that month that is stored in the FX rate tab. Otherwise, just return the contents of that cell. I tried to do a xlookup by the transaction date but since the data file is converted from a flat file template, I think my lookup function is not recognizing the lookup field between the array and the cell reference. I am more than happy to create a helper column for the Transaction date that will match the format of the month in the FX rate tab. Hope you can point out a clean solution for this approach. Thank you. Regards, Shams.Outlook Classic for M365 - File > Encrypt > 'Encrypt-Only' option applies 'Do Not Forward' label?
I recently joined a new company and am helping support their M365 tenant and admin duties. I'm running into a very weird issue where no recipients can actually read/view the message when we encrypt emails using only 1 specific method (our organization largely uses the Outlook Classic for Microsoft 365 desktop app). If a user follows this method, for some reason the 'Do Not Forward' label is applied to the encryption, despite specifically selecting 'Encrypt-Only' - it defaults to 'Do Not Forward' every single time: New Email > File > Encrypt > Encrypt-Only Sending emails with this method gives any/all recipients a "You don't have sufficient permissions to open the mail." regardless of where they try to open the email (OWA, Outlook Classic, New Outlook) Yet, if the user tries this other method below - the proper Encrypt-Only label is applied, and any Outlook client immediately and opens/views the email as you'd expect: New Email > Options ribbon > Encrypt properly applies the Encrypt-Only label I verified IRM (Identity Rights Management) is enabled for our tenant: And encryption tests pass with flying colors: Ultimately, I'm at a loss for what's going on here and specifically where to check to fix this issue for this 1 specific encryption method. Poking around in the Purview portal, I'm having a hard time figuring out where these encryption policies/settings lie and how to get this method to stop defaulting to 'Do Not Forward' even though 'Encrypt-Only' is checked.
CANNOT OPEN THE SPECIFIED FILE with tel:-hyperlink
Hi, I have several "tel:" hyperlinks in a Excel sheet (xlsm). Yesterday, they sended the phone numbers to whatsapp. But today i become the errer:"CANNOT OPEN THE SPECIFIED FILE". I saved yesterday a xlsx file as xlsm, after the conversion, the links were still working. What goes wrong?
Events
Learn, Connect, and Be Inspired at ESPC25
Join us in Dublin for ESPC25! One of Europe’s largest community conferences, ESPC25 is your opportunity to expand your Microsoft 365 Copilot, Collaborative...
In-Person
Recent Blogs
- Rewriting text in your PowerPoint slides is now quicker and more intuitive. With just one click, you can condense, rephrase, or structure any written content.Nov 17, 2025
- We’ve repositioned the search dropdown to minimize overlap with your page, so you can browse while seeing more of your canvas.Nov 14, 2025
