Recent Discussions
How XLOOKUP arguments apply in this case
I'm not an Excel newbie, but I have never had cause to use XLOOKUP, INDEX, or MATCH before. I'm not understanding how the xlookup arguments would apply in my case or if index/match would be better. I have an array with months as my row headings and dates as my column headings. The array itself is filled with number of pages read each day. I'm trying to have a cell indicating on which date I did the maximum amount of reading. So I want to start with the max value of my array and return the month (row) and date (column) heading using xlookup. Whether those are in one cell or two, doesn't so much matter - it's a hobby tracker, but no matter how I try and call this, I end up with a value error So for example, I would want this to return January 3rd. Every example I'm finding seems to show how to input Jan 3rd and return the value 758. What am I missing to look this up the other way around? Should I be using index or match instead?
Filtering an Array based on a list of Criteria
I have an array that tracks every project that every project manager, project engineer, and superintendent is on and I am trying to set up a function to search through a single list of names and return just their projects. The PM, PE, and SUP on the array all have their own columns since there can be 1 of each on a single project. and the list im pulling from is within a single separate column pulling on the names I select. I have had success pulling from one column at a time using a FILTER(ISNUMBER(MATCH)) function but I cant get it to search and return all values from all three columns. Any thought on how to expand the search? Thank you!Move Existing Sharepoint Linked Database to a different Sharepoint Site
Hi. I have a Sharepoint Linked Database that is working well within our company. We would like to use it within another subsidiary company that operates with its own Name and Sharepoint sites. Could you please assist as i am struggling to do this. Thanks
Removing Old MS 365 Account
I had a Office 365 account under the discontinued educational organization license. The cloud storage was supposed to be disabled by MS at some point. So, I bought a personal Ofc 365 subscription. I tried to remove references to the old account and register my new license under a different email address, however my machine is still ate up with it, it still tries to save documents to that supposedly disabled Onedrive location and Office applications still confuse it. I scanned the system registry and there are hundreds of references to the old account & configuration. This is a problem on several of my home machines. How do I totally nuke that old account?
Text to Column
Hello Everyone. I'm trying to split data into 2 columns. The original data is made up of cities and states: Notice that some items have a comma and others don't. Also, the cities states are different lengths. So, I cannot use a space or a comma as a delimiter. I'm trying to figure out how to separate them. I came up with this formula to add a colon so I can use the delimiter to separate them. The problem then becomes the fact that I have to count the number of spaces in each city to add the colon. Then, I have to copy and paste special as values. Also, notice that in New Orleans (for example), it keeps the comma: One more issue, if I get a new report with added cities and states, then I have to re-do the calculations. HELP!!!! Balta
Using calculated columns in pivot table
I already used calculated fields to get some datas in my pivot table. They're displayed as count or sum. I want to make a new calculated fields using a Sum of working time, divide it with the number of operations. How can I use the count and the sum ? Right now, it doesn't seem to use the sum nor the count : Here I want Sum of MBTF to be : Sum of working time/ Count of Stop but the values in Sum of MTBF seems to use the values in Stops (they are dispalyed in my original table as 6/7 numbers, but I used the function count to only get the number of occurences). I believe that's the thing causing my Sum of MTBF to show 1.68E-07 numbers ( for the first line it should be 52.001) : How can I get to have a column displaying the right values (52.001, and others for each line) ? Thank you in advance for your help !Multi-line Text Box misleading text and cursor display
Starting with 365 Version 2603 on 4K monitor, in a multi-line text box, typing multiple words followed by line feeds (Enter key) then moving cursor back up to previous line causes trailing characters to disappear, entering characters at the end of the line shows the new character with the cursor in front of it, and other bizarre behavior. Selecting all the text shows it is all there but trailing characters at the end of a line can disappear depending on cursor position. If I change the monitor resolution to 2K, the issue goes away. If I rollback to version 2602 the issue goes away. This is an issue with version 2603 on 4K monitors. We have many customers reporting the same issue.Unified Multi-Tenant Management Console for MSPs and IT Providers
Microsoft would benefit from offering a truly unified, multi-tenant console designed for MSPs and IT support providers, enabling them to manage multiple client organisations from a single interface. This solution should support the integration of each client’s own domains, centralised administration across Microsoft 365, Azure, and Entra ID environments, granular delegation of permissions, and consolidated visibility into users, devices, licences, policies, and incidents. Such a tool would significantly reduce operational complexity, strengthen security, and address a genuine need for partners who manage multiple tenants on a daily basis.
Hello from New Hampshire 👋
Hi everyone, I’m Lissette. I work in enterprise HR technology and project delivery, with a strong focus on using Microsoft 365 and AI to help teams work more efficiently and scale what’s working. A lot of my day‑to‑day work sits at the intersection of technology, structure, and enablement, translating complex requirements into practical solutions, and using AI and automation to accelerate delivery and reduce friction for teams. I’m here to learn from the community, share practical experiences, and exchange ideas around modern ways of working. Looking forward to learning from you all and contributing where I can. I’m especially interested in real‑world M365 practices that improve collaboration, governance, and adoption at scale.Access adds brackets to text in quotes in Iif statement
I have a query of 1 short text field. If the field has the value "NOCOV" I want to return Null, otherwise I want the value in the short text field. The problem is that Access add brackets around "NOCOV" and treats it like a parameter. I enter: PRM_PreMedicare_Plan_ID: IIf([PRM Pre-Medicare Plan ID]=“NOCOV”,Null,[PRM Pre-Medicare Plan ID]) The result is: PRM_PreMedicare_Plan_ID: IIf([PRM Pre-Medicare Plan ID]=[“NOCOV”],Null,[PRM Pre-Medicare Plan ID]) It doesn't matter if I use <> or Like instead of = or Switch instead of IIf. The same problem occurs. I don't know how to prevent Access from adding brackets. I'm using Access for Office 365 Version 2603.Config Question: Microsoft 365, Microsoft Authenticator, Mac Mail Users
Hello All, We are currently using Microsoft 365 which is "hosted" or "federated" through GoDaddy. I want to pilot Microsoft Authenticator, so that we can have either MFA, SSO, or a combo of both. I'm running into a possible issue when I enable MFA for myself, as an enduser. We run TEAMS, and I only get asked to re-login into Teams to authenticate, which does work. However, if Mac Mail running as a client on the endpoint machine, should I assume that MFA will not work, since it is always communicating to the "hosted/federated" backend? That it never disconnects the connection? If there is something I should do differently with the config, I'd appreciate the guidance here.
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?Viva Engage Communities Gain Support for Sensitivity Labels
Viva Engage communities now support Purview container management labels (sensitivity labels that manage settings for groups, teams, communities, etc.). The update makes it possible to manage community settings like privacy through labels instead of settings applied to individual communities. Once communities have container management labels, you can manage the labels in the same way as when applied to Teams and Microsoft 365 groups. https://office365itpros.com/2026/04/03/container-management-labels-viva/Excel repair strips all formulas from large .xlsm after March 2026 security update (KB5002849)
Hi everyone, I'm a master's student at Karolinska Institutet in Stockholm. My thesis is a health economic cost-effectiveness model built entirely in Excel — a gender-neutral static Markov cohort model with 34 worksheets. The file has become completely unusable after what I believe is the March 2026 security update, and I'm running out of options. The file: - .xlsm, ~46.5 MB compressed, ~370 MB uncompressed XML - 34 worksheets, four of which are 73–92 MB each (Markov trace sheets) - ~65,000 formulas, ~33,500 shared formulas - Heavy use of LET, LAMBDA, XLOOKUP, XMATCH, CHOOSECOLS, TAKE, MAP, SWITCH - 771 defined names including ~147 hidden _xlpm.* LET/LAMBDA variable placeholders - Stored on OneDrive via KI SharePoint, 34,000+ AutoSave revisions - Contains VBA (vbaProject.bin) The problem: Every time I open the file — on Excel for Mac or Excel Online — the repair engine triggers and strips ALL formulas from every sheet, replacing them with cached values. The file shrinks from ~46.5 MB to ~26 MB. Clicking "No" on the repair dialog just closes the file. There is no way to bypass the repair. What I've verified: - Extracted the .xlsm as a ZIP and confirmed all formulas (<f> tags) are fully intact in the raw XML - Libr€Office Calc can read the formulas but cannot execute them (Err:508 — no LET/LAMBDA support) - Removed 158 broken named ranges (#REF! and #NAME? entries) from workbook.xml and rebuilt the archive — repair engine still strips all formulas - The issue reproduces on every OneDrive version history copy (up until I largely used LET formulas in my sheets - but there is still 1,5months of changes lost) - The issue reproduces on both Excel for Mac and Excel Online Suspected cause: The March 10, 2026 security update (KB5002849) patched CVE-2026-26108, a heap overflow in Excel's file parsing during loading. The same patch was applied to Office Online Server (KB5002846). I believe the tightened parsing now rejects or flags my file's large XML structures as potentially malicious, triggering the repair engine to strip all formulas. This is consistent with: - The known _xlfn. namespace bug on Excel for Mac (reported by multiple users on Microsoft Q&A since late 2024) - The timing - the file was working before this update flawlessly up until March 16th - The fact that Excel Online is also affected (same server-side patch) My questions to the community: 1. Has anyone else experienced formula stripping on large workbooks after the March 2026 update? 2. Is there a way to bypass the repair engine on Mac, or roll back the specific security patch without downgrading all of Office? 3. Would opening this file on Windows Excel (pre-patch or current) preserve the formulas? If anyone with a Windows PC would be willing to try opening and re-saving this file, I would be incredibly grateful. 4. Is there now effectively a size/complexity ceiling for Excel workbooks that makes models like this unviable? If so - should I be migrating this to another environment (R, Python, etc.) going forward? This file represents six months of thesis work. The formulas are all there in the XML. I just need Excel to stop destroying them on open. Any help, pointers, or similar experiences would be hugely appreciated. Thank you, Florian BoschekMicrosoft Excel Update Changed Formula
I've used Excel for the last 2-3 years to track changes in a sheet by month the data listed is added or changed. The formula I've used worked fine until today, when I started receiving an _xlfn in the formula. It now reads as follows: =IF(ISBLANK($A6),$A2,IF((_xlfn.MAXIFS(A$7:A$41,D$7:D$41,">"&0))>=$A$2,_xlfn.MAXIFS(A$7:A$41,D$7:D$41,">"&0),"")) My goal was to have Excel look if there were updated values in D6 and enter the most recent date associated with that value from A6 to A41. Does Excel no longer support MAXIFS?PowerPoint NEW Image Editing Tools Explained — Remove Background, Upscale & Edit Images Instantly!
🚀 PowerPoint just received one of its most powerful updates ever! Microsoft has introduced a brand‑new built‑in image editing experience, allowing you to enhance visuals without leaving PowerPoint. In my latest YouTube video, I walk through all the new capabilities now rolling out in Microsoft 365, including: ✨ Remove background 🧽 Erase unwanted objects 🔄 Move elements inside an image 🔍 Upscale low‑resolution pictures ⚡ Auto‑enhance lighting & contrast 📝 Add or edit text directly on images All of this happens directly inside PowerPoint, making slide creation faster and more intuitive than ever. These features are now available on: 💻 Windows 🍎 Mac 🌐 PowerPoint for the Web If you work with presentations daily, this update is a real productivity boost. 📹 Watch the full breakdown and demo here ➡️ https://youtu.be/OZzfFi2qpAk Let me know what feature you find the most useful! 👇 #Microsoft365 #PowerPoint #Productivity #AI #Presentations #Microsoft365Insider #Creators
Events
REGISTER HERE
As content continues to grow, organizations need better ways to manage inactive data without sacrificing security, compliance, or discoverability.
Join us for an overview of how M...
Online
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 Edge Browser Control didn't navigate from code when inside a tab control When the Edge Browser con...Apr 02, 2026
- An update to Accessibility Assistant in PowerPoint for Windows improves how it detects color contrast issues.Apr 02, 2026
