Recent Discussions
Purview eDiscovery Simplifies Content Searches in February 2026
As part of the modernization of the Purview eDiscovery solution, Microsoft will simplify the content searches UX in February 2026 to remove features that are inappropriate for the way that content searches are intended to be used. The change is logical and reasonable because you should use a full eDiscovery case to access all the eDiscovery functionality. https://office365itpros.com/2026/01/15/content-searches-change/
Loss carry forward for limited years
Hello Excel Community, Excel Version: O365 (Enterprise) I’m running into a mental block trying to model loss carryforward with limited years using a spill formula. Below is a simplified example of what I’m trying to build a formula for. Rules: • A loss from any year can be carried forward for N years, after which it expires and can no longer be used. • In any year with a positive tax liability, if there is any remaining loss from the past N years, you deduct using a FIFO approach (oldest losses used first). • Any unclaimed balance from year N+1 expires, even if it hasn’t been fully used. I’ve found plenty of examples showing loss carryforward without expiration, but I’m struggling to build something that handles both FIFO and expiration in a dynamic array formula. I feel like this must be a solved problem and I’m just missing something obvious. Any help would be greatly appreciated! ------------------------------------------------------------------------------------------How do you respond to...
Hello my Excellers, I wish you all a happy new year full of great things. I have a question and I am not sure if this is a purely an Excel question or something else but maybe I start here and see how it goes: As you all may have noticed the AI craze is blooming like crazy. If you want to sell lettuce slap AI on its label and step back. I use Bing to search for VBA examples. For example I typed "excel vba code to find cells with formulas" and I get AI to find or "compose" a decent example that with minimal editing will work perfectly. But then at the end of the code and its explanation I sometimes find these kind of questions: "If you want to list the addresses of formula cells instead of highlighting them, I can give you a version that outputs them in the Immediate Window or a new sheet. Do you want me to provide that listing version as well?" How do you say YES I want that code that would list the addresses in a sheet? I see buttons like "Undo" rounded Left Arrow, or "Redo" rounded Right arrow, and a "Copy, "Export", and then "Tweak Content", "Rewrite" button, A "Testing Tools" dropdown with options like "Generate test data" and "Integrate test cases", and another dropdown called "More Actions" with options like "Perform code review", "Explain the code", "Add error handling", and "Make code compliable" and the last dropdown "Work Report" with its own options. But I do not see anything that would allow me to say YES I want that code that would list the addresses in a sheet? Thanks for any insight... GiGi
Display Last Value in Column when certain criteria match
Hello all, I am trying to find a way of displaying the last value in a column when certain criteria match... Criteria that need to match would be Design, Colour and Size, so the quantity column would populate with the latest stock quantity: Thanks all! MichaelTeams External Collaboration Administrator Role Arrives
Microsoft is introducing a new Entra ID role. The Teams External Collaboration administrator role allows users to manage external collaboration settings. Quite how often Microsoft 365 tenants need to manage these settings is unknown, but it’s a useful prompt to review the current set of roles used and users who are members of those roles. Time for an annual clean-up. https://office365itpros.com/2026/01/14/new-entra-id-role/
Word Document - Projector screen and Monitor Screen
Hi, I am not sure if I can get any best recommendation here. We have a document (usually converted into PDF) that the management used during meetings. The presenter will show it on the big screen via projector in front of a big audience as well as on his wide in a small audience. In the past, the document is using paper size A4. I am not familiar with such projector and screen settings but according to the presenter, the screen (both projecter screen and on his wide screen), the visual does not fill up all the screen space. The new presenter does not like it this way. He wants us to find a solution to get the document "Stretch" or "Fill" up the entire screen (whether projector screen or any wide screen he uses). A stupid idea is to use a custom paper size 16 inches by 9 inches in Word for it....but even that it does not ensure all projector screens and all monitor screens will fit. Therefore this is not a dynamic solution, plus it will messes up all the formatting (example columnal layout width and table width etc) copied from the old A4 file. Does anyone know a good solution for the above request?Help with Excel Sorting
Hello! I am looking for help with sorting data on a sheet with form responses to different excel sheets. I want to filter by column G to different sheets ("Near Miss", "Adverse Event", "Sentinel Event". The data automatically goes to sheet1 via form responses, but I am trying to streamline the data into specific types of events. I'm using office 365. TIA!SharePoint Site Administrators Can Now Control Restricted Content Discovery
Restricted Content Discovery (RCD) is a feature that blocks access by Microsoft 365 Copilot and agents to the files stored in a SharePoint Online site. Instead of relying on tenant administrators, site administrators can now enable or disable RCD. It’s a natural evolution of what is an essential feature to keep sensitive and confidential information being leaked inadvertently by AI. https://office365itpros.com/2026/01/13/rcd-site-level/Web-Addins stopped working for Office apps version 16.100 for Mac
Dear experts, Since version 16.100, the web add-in functionality has stopped working with the Office apps for Mac (PowerPoint, Word and Excel). In may case, Templafy web add-in is not being loaded. According to Templafy's support page: https://support.templafy.com/hc/en-us/articles/29028257609501-Templafy-Web-Add-ins-no-longer-accessible-on-Mac-after-Microsoft-Office-update-16-99 this seems to be a bigger issue. Clearing web add-in cache or deleting the WEF folder will not resolve the issue. I have also tried with a full clean uninstallation of Office365 apps and re-installation, same issue. Note that New Outlook for Mac is not affected, just PowerPoint, Excel and Word.Excel crashes whenever file tab is clicked
I have been having a lot of issues with Excel on a vm that we use, and I cannot try and fix these issues due to not being able to click on the file tab. Whenever the file tab is clicked, excel freezes and if anything clicked again goes to not responding. I do not get anything from windows diagnostics. I have also reinstalled Office 365 several times and excel always has this issue. the VM is a 2019 data Center and excel is 32 bit. running in safe mode does nothing. Book.xltx or Sheet.xltx is not in the XLSTART folder, if it was, I would have to wait for plant downtime to restart the vm. Deleted the excel key in HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel, restarted excel and issue still persists.A Method to track current and upcoming changes to M365 Products
Good evening (from Ireland at least), I've spent most of today traipsing down a variety of dead-ends and soon-to-be-discontinued features looking to create a useful location where I can find/send all new updates to products that I can peruse and ultimately highlight ones that may be of particular importance in my organisation. I've had a long chat with Copilot today and while I've made significant progress in some areas (had upwards of 30 great questions according to Copilot! ;P), when it comes to the final product, there's always some missing connector, or some RSS feed that is no longer supported. What I'm looking for here is any input on how you manage to stay ahead of changes and I'll share everything I'm doing and have learned as well, in the hope that the discussion is somewhat mutually beneficial. What I do: Message Centre: Manually check the Message Center (under Service Health in M365 Admin Center). You can sort by product here and by relevance which is quite handy. Link: https://admin.cloud.microsoft/?#/MessageCenter (Access to the M365 Admin Center on your tenant is required for this). Today I found out you can also send emails to yourself (and Teams channels) here so awaiting the next message to see if this has worked. Unfortunately, there doesn't seem to be a way of migrating past messages over so I'll have to go through these myself first. Road Maps: These have been the bane of my day. Currently, I actively check the road maps of the products I manage but going forward, I'd like to be able to track major changes to products used in my organisation so I can give users a heads up. I initially tried Power Automate to send updates to myself, however, it's not a feature widely used in our org yet and isn't well supported, so I wasn't too surprised when my efforts were blocked by existing policy. Not long after, I found RSS feeds, which seemed to be the answer to my problems. I created RSS Feeds for each of the Road Maps that I found useful, assured by Copilot that these would work. The assurance wasn't fell founded however as, true to form, once I showed Copilot by errors, they remembered that they were there all along! :') I'm yet to find a useful solution here beyond my current efforts so any assistance would be greatly appreciated. Community Blogs The final recommendation was these Community Blog posts which, to be fair, I've had immense success with to date. However, there is a slight issue with filtering. While I did finally get the RSS Feed to work on something (the Tech Comm M365 RSS Feed), it did then proceed to send me a mass of emails on every topic under the Sun & Moon. I've decided to return to the drawing board tomorrow with this, but I'm content in knowing that RSS isn't just a myth at least. I think what I'd like here is just to receive notifications when approved Blogs are posted (i.e., Monthly OneDrive Updates and the equivalent for other products). OneDrive Office Hours: This is a fansastic resource I do use every month as it gives you the opportunity to get in contact with the people who know the most about the product and the issues you're facing. I've spent weeks in a ticket before, only to raise it in one of these meetings and get a solution that took half an hour to set up. You'll get a yes or a no, but at least you'll have an answer. Copilot Chat: I don't have the full Copilot license because I haven't had a need for it yet. Everything I've wanted to do, I've been able to do in Copilot Chat. We haven't yet looked too much into Agents, and as a Public body, aren't going to rush into it until we know it's viable and can be supported. In the interim, I'm happy to test the waters with Copilot Chat asking it for Monthly Summaries on a variety of products, time frames, etc. It isn't perfect but it's faster than I am. It can find the sources for me and I can take it from there. As an organisation, we'll be pushing out all users on the most recent version (-1) on the Monthly Enterprise Channel. This means that they'll be supported whilst also being shielded from any brand new features. Our team will be on the most recent version and will be able to note any upcoming changes ahead of time. These are what I'm using so far but would be very grateful for any further input. Thanks in advance, Chris Martin
Bookings - No more notes or extra fields available
Hi there and happy new year to all. Starting from mid-december, we are facing an issue with our company Microsoft Bookings: basically the custom fields (like address, notes and so on). The book page will just ask for Name & Surname, E-mail Address and Phone Number. On our Administration back-end, the Customer Notes fileds is greyed out (you cannot enable it), and all the custom fields disappeared, you have just the standard ones. We have this issue in all our different booking pages, and all the services are affected. Any hint about this? Thanks!
I haven't seen anyone talking about this online store
There is this office and windows key store called esd codes and they sell office keys. They seem legit since they're affiliated with Microsoft and they have mostly positive reviews but I the description of every office key and I mean every has a note stating "if office (literally every single one) version is not available, you will receive the Professional Plus version at the same price" which they are trying to make it look like an upgrade but from what I searched the professional plus versions are bought in bulk by big companies and organizations and after they stop being updated they are being sold for cheap probably by employees. I have found multiple for less than 2 or even 1 buck and I feel they are scamming people.
How to separate non-indented number points from indented number points?
I'll explain. I have a document that's about fifty pages in length, with about 500 numbered points in total. The list randomly is dispersed going down, with some numbered points having no indentation while some have it (text down and to the right, down to the right and so on). It looks like this: Example 1 (Actual Layout): This Is An Example How The Document Is Listed Trying to sift through it all and sort the list manually is proving to be too time consuming. Trying to sort the lists alphabetically left all the indented text out of order with no way to figure out what numbered point it belonged to what. It looked something like this: Example 2 (Alphabetized Layout): An Document Example How Is Is Listed Of The This Is there any way to have it so word can separate Example 1's points, 1, 4, 5, 6, and 7 and points 2 and 3 away from each other, creating two separate lists with all the indented numbered points all corresponding to the correct main indented point? Like this: Example Three (Desired Layout): This Is The Document Is Listed Is An Example How Thanks. Sorry for the length.Microsoft Copilot
Is anyone else having issues today? I was using copilot today like I have been for months. Using the same prompts I have been using for months when I started getting this response "I'd really like to help, but it seems this topic is off-limits for me. sorry about that!" I was trying to discuss with the AI what the issue was and tried showing the prompt when all of a sudden it said I was suspended for an hour. I tried to talk with support but they were no help.
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
- There are now two faster, more intuitive ways to bring text-based data directly into Excel.Jan 15, 2026
- Managing app security and compliance in Microsoft Teams just got easier! With recent updates in Teams Admin Center (TAC), IT admins can now quickly identify trusted apps and enforce organizational st...Jan 14, 2026
