Recent Discussions
How to Test a File Against DLP Sensitive Information Types
Sensitive Information types (SITs) are definitions of data like credit card numbers used by DLP rules to detect potential external sharing violations. Knowing what SIT to use in a DLP rule is often difficult, which is why the Purview developers have added a test option to allow tenants to test files against individual SITs or all SITs to see what happens. https://office365itpros.com/2026/03/04/sensitive-information-type-test/
Conditional Formatting a specific word
First post here, so hoping someone can help me. I work for a repair facility. I track our repairs in excel. I have an “order” tab that tracks all the important information for the repairs. I also have an “inventory” tab that shows what parts we have in stock in our inventory. Also on this tab I do a daily data dump of all the parts needed for each order. I use this dump to fill in a “parts needed” column on the repair tab to show what specific parts, based on part name, an order needs to be completed. Is there a way for me to condition the “Parts Needed” cells on the repair tab to highlight the part name if the part shows in stock on the inventory tab? I.E - Repair tab: order 0001 for Jane Doe Started work 1/23/45 needs parts: mouse, keyboard, monitor, hard drive Inventory Tab: Daily parts dump: order 0001 - part needed: mouse order 0001 - part needed: keyboard order 0001 - part needed: monitor order 0001 - part needed: hard drive In stock report: Mouse 10 Keyboard 0 Monitor 0 Hard drive 5
Excel Map - One region is recognized but not showing up in color
Hi, As shown below, I am trying to map out the number of farmers in our data in each of Georgia's regions. Samegrelo Zemo Svaneti is recognized and the data label appears but the color does not. If I change the map to show only the regions with data, it does show in color but I need the full country map.
Conditional Formatting or a Specific Filter Rule
Dear Experts , I have a data like below:- here the Column-O, txNumber can go from 1,2,3 (txNum=2 and 3 means a Retransmission), I want to filter all the pairs for all Transmissions and their corresponding Retransmissions ( either by coloring them all using a conditional formatting) or using a specific filter Rule. How to identify the Transmission and it's corresponding Retransmission for a Specific HarqId( say for dlHarqProcessIndex ==7, the blue color Row-37 is my 1st transmission(txNumber ==1) for the dlHarqProcessIndex==7 with a tbSize of 852696, and adaptRetxStatus == NOTACTIVATE, and it's corresponding 2nd transmission( Retransmission , txNumber==2) Row-45, tbSize remains same(as it's corresponding 1st transmission) in all retransmissions and adaptRetxStatus changes to "APPLY" for all retrans txNumber==2,3) and similarly for other pairs like for dlHarqProcessIndex==13. Attached is the Worksheet.
File always corrupt
Anyone have the same problem with me? I use microsoft excel 365 on my mac. At the beginning everything alright, until i use formula and then save the file. When i want to re-open the file, the messagebox showed up "we found something wrong in your content...". It gives 2 option, yes and no. If i click no, the file wont open. If i click yes, the file open, the excel do the recovery, the file open but end up with all the formulas is gone, deleted by excel and just left the value. What should i do? Do the file can still be fixed?
Word - Same Line Page Breaks Visibly Change Formatting
Within the last week or so, Word suddenly has started changing the formatting of visible text when a page break is used on the same line. How can this be corrected? (To be clear, yes, a page break could moved to the next line or deleted if there is not room for the extra line, but this impacts dozens of templates I have been using for years and I just want to set the formatting back to how it has worked in the past, where a page break inserted at the end of a line with centered text did not change the formatting of the visible text in said line.) Example 1 below is how it always used to appear whether the page break was on the same line as the centered title text or not. Example 2 below is how it looks now when the page break is on the same line.
Side load office add-in?
I've created an office.js add-in that I can test with debugging in VS Code. I have deployed it including the manifest to a web site, but now I can't find the option to add it to my Excel anymore, where has that option gone? I'm on Microsoft® Excel® for Microsoft 365 MSO (Version 2602 Build 16.0.19725.20126) 64-bit Thanks GJ
Microsoft Celebrates SharePoint 25th Anniversary with a Bunch of Announcements
Microsoft celebrated the 25th anniversary of SharePoint with a batch of announcements, including AI in SharePoint, intended to help administrators to manage all aspects of SharePoint Online through natural language. Other interesting announcements included department-level payments for Microsoft 365 Backup and the renaming of the Connections app in Teams as the SharePoint app. Well, the last wasn’t that interesting… https://office365itpros.com/2026/03/03/ai-in-sharepoint/SharePoint 2013 Workflow Retirement: What It Means for Your Business
Microsoft has officially entered the final chapter of SharePoint 2013 workflows, and for many organizations, this update is more than just another lifecycle announcement — it’s a wake-up call. The retirement of SharePoint 2013 workflows in SharePoint Online marks a decisive shift away from legacy automation toward modern, cloud-first workflow platforms. For businesses that still rely on approval flows, notifications, and automated processes built years ago, the message is clear: those workflows will stop working, and planning can no longer be postponed. This updated news article explains what the retirement means, what changes technically after the deadline, and — most importantly — how organizations can migrate and modernize their workflows step by step. https://dellenny.com/sharepoint-2013-workflow-retirement-what-it-means-for-your-business/
Excel Macros Issues
Hi all, A few years ago, a friend wrote a Macros for an excel sheet we use to populate an action plan. The concept is very simple. The Macros goes through the tab and pulls relevent cells through to an another tab creating an action plan. Each item goes under a heading and creates a new line. This has worked like a dream for the last 5 years. Just recently, the macros has started throwing up errors when i run it. Its having issues with Row Height, and doesn't finish running the script, and Excel just hangs. I've replicated this issue on a number of computers, new and old, and tried to swap between Mac and PC. This issue remains the same. The only commonality is the latest version of Excel. Unfortunately rolling back a version is not an option. Have MS updated something that would affect the way this Macros works? Can anyone suggest a solution? Any assistance is appreciated. Many thanks D.Announcing Office 365 for IT Pros (2026 Edition)
Office 365 for IT Pros (2026 edition), the 12th in an eBook series going back to May 2015, is now available. Covering all the essential aspects of Microsoft 365 tenant management from Entra ID to Exchange Online, SharePoint Online, OneDrive for Business, Teams, data lifecycle management, information protection, and more, Office 365 for IT Pros is an indispensable companion for tenant administrators who want to understand how Microsoft 365 really works. https://office365itpros.com/2025/07/01/office-365-for-it-pros-2026-edition/XLOOKUP search w/multiple output
I've been working on a project and I am completely stumped. I cannot wrap my brain around how to get this to work. In the example below, I want to Enter a number in either of the top two field and have the last three fields populate. Now, I can get this to work for one, but not the other and for some reason when I switch from bottom search to the top search the old data doesn't clear and the search doesn't work. This is the formula I have so far //=XLOOKUP(H8,A2:A10606,B2:B10606) Anything I have done after has been a disaster
Events
You’re passionate about what you do, and we’re passionate about empowering your potential. Microsoft 365 Community Conference - is your chance to keep up with AI, build game-changing skills, and take...
In-Person
Recent Blogs
- Here's a summary of bug fixes in the latest version of Access: Bug Name Issue Fixed Monaco query editor applied unwanted autoformatting to passthrough queries The Monaco SQL edit...Mar 02, 2026
As organizations continue to scale Microsoft 365, protecting data has become a technical and operational requirement. Microsoft 365 Backup delivers fast, native recovery for SharePoint, OneDrive, and...Mar 02, 2026
