Recent Discussions
XLOOKUP not working for multiple criteria
Hi all, I am setting up a workbook for boardgames played for someone and he wants to see the high score returned for each game. I have tried xlookup in multiple ways and have had no success. Here is an image of the first worksheet which shows the formula in the cell I have had no success in any form with xlookup so far. This is the worksheet I am referencing: Any suggestions or insights into what I am doing wrong will be appreciated here is the formula written out so you don't have to try and parse it from the image. =XLOOKUP(1, ([High Score]=GameStats[Score])*(GameStats[Board Game]=[Board Game])*(GameStats[Board / Scenario]=[Board / Scenario]),GameStats[Player],,0,1) Thank you for your help. Regards, Larry
Latest updated removed all of my Quick Access Toolbar customizations.
Latest updated removed all of my Quick Access Toolbar customizations. It's not hidden - it's there, it's just empty of everything but the default commands. I have checked for a *.qat file in these directories C:\Users\<username>\AppData\Roaming\Microsoft\Office C:\Users\<username>\AppData\Local\Microsoft\Office but there's nothing there. I have never exported it (did not know you could) so there is no *.exportedUI file to use I have around 40 commands and don't even remember all of the correct names to rebuild it.
Complex formulae with data model
Over the years, I have developed a significant excel data sheet which has gotten slower and slower with time. I have discovered the idea of excel's data model this week and have learnt how to import the data I need from its source CSV to the data model and I now have a power pivot which looks like what I originally had in excel. What I would like to do next, is to replicate some of the formulae I had in excel to calculate if something should be counted or not. I would not want the red one to be counted as this row would have been counted in the previous month. In excel I was using the following formula- =IF(COUNTIF(B5:M4,">0"),SUM(Patient!B5:M5*0),Patient!N5) is there a way of achieving this with the data model or would I have to hardcode this into another sheet? I was trying to avoid doing this to minimise the number of formulae... Many thanks for your help...
Can't save MS Word files anymore on my Mac
Hi all, I have a macbook air 2020 version with an Intel chip. I'm using OS Sequioa 15.7.4 Microsoft Word version 16.107.1 Since this week I'm having issues with saving Microsoft Word files on my Mac. When I'm trying to save a file I'm getting the following message (translated from Dutch): "saving has failed because of insufficient memory or space on the hard disk" My hard disk is using 133 GB out of 500 GB. So that can't be the issue. I've tried already the following things: Reinstall MacOS (via cmnd R) Reinstall Word Log off out of word, restart, and log on into word. Reset Office 365 on mac via Office-Reset.com Saving the file in another folder / external disk Transfering all my files to a new Mac with OS Tahoe 26.3.1 and start working from there On both Macs I'm investigating deeper what goes wrong and this is what I've noticed so far I can open a new word file, typ in it and save that file. But the moment that I start pasting things from certain (a lot but not all) other files the problems start. I can't undo previous actions anymore I can't save the file I'm working on anymore (USB / Mac / onedrive) These issues occur on both MacOS. These issues occur often when I'm pasting pictures or formulas from those certain word-files. Does anyone has any idea how to fix this? Many thanks in advance. Kind regards, StephanPowerPoint 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 #CreatorsMarkdown and OneNote
2025 and still no markdown support in OneNote(touch supported version). This is Post ChatGPT era and all the LLMs generate text in markdown format. And I am pretty sure, a lot of people out there nowadays generate quick and concise notes through LLMs. But no, OneNote does not wanna render markdown. However, keeping source formatting can format text somewhere close to LLMs output. But not perfectly. The code snippets and tables does not render and appear as a mess. In simple words, I cannot copy LLM output for "Give me code examples of Rust's thread::spawn() function" directly into OneNote because it will be just appear gibberish. NOTE: There are two types of copying. 1) Select text and copy 2) Dedicated copy button in LLM output. So when I say copy I mean *2 as it preserves the markdown syntax.
Can a font become 'corrupted,' and how to replace?
This refers to MS Word from Office 2019, running under Windows 10 Pro. I have a somewhat large (10MB) Word .docx I've been adding to as time permits. It has text, illustrations, pictures and captions for the pictures in text boxes. suddenly, when I open the file, some of the captions are garbled. The font I used is Arial 10pt, bold and regular. The bold is just fine, the regular is garbled. However, if I highlight the garbled text and change it to bold, italic or any other font, it appears just fine. Here is an example of what I'm talking about. First the .docx as it appears on my screen: Then if I highlight that garbled text and change it to Bold, or any other font, it looks good: If I change point size the problem persists. It's just Arial Regular that garbles, and only in this document, and . Other .docx files using that same font display fine. Also, I can take this file and open it on my other computer, which is running Office 2010 under Windows 10 Pro, and it opens properly. I do have Word programmed to embed non-system fonts in the document, so I'm assuming that Word is fetching Arial Regular to display when opening the file on this computer, and that my other computer maybe has a good Arial Regular installation, which is why it looks good there. Something else I just noticed, referring to the two screenshots that follow. Other 10pt. Arial Regular that was NOT in a text box seemed okay in this document. But on close examination, the kerning seemed a bit off. So I changed that non-text box text to another Helvetica-style font and it did look better, but then when I set it back to Arial, it was garbled too. So do I have a bad Arial Regular on this computer? If so, why don't other documents show this problem. And, most important, how do I fix it? Thanks in advance, and... HELP!
Upgrading from Personal to Family
The support in have read says to upgrade from Personal to Family I buy the new plan and any remaining subscription will be converted to the Family plan but I will lose some of the remaining time. I have 18 months to go on my Personal plan so does that mean if I buy a year of Family now I will be charged the full yearly price for 12 months then have the remainder of the Personal plan added so my next yearly subscription payment would be in about 2 years? Also does anyone know how the remaining conversation works and how much I would get for my 18 months of Personal?
Sorting data on multiple sheets
Hi, I'm using Excel to track data from my team for analysis. I have 5 sheets in my workbook one for each week and a monthly overview. each week totals all data and totals are added to overview using SUM function, however when i sort a column, let's say i sort column a (Name) A-Z, all the data for each person on the monthly report changes. the same happens on the weekly sheets if i change the order of a column everything get mixed up so that each persons stats change. is there a way to stop this from happening? I want to be able to arrange it so that all the data in a row stays the same on each sheetHow to remove deleted images that still appear in Bing via TSE cache?
Hello, I am looking for help regarding images that were already removed from the original websites months ago, but they are still appearing in Bing search results. I tried to request removal through the Bing Webmaster Tools, but I encountered the following message: “We can only remove content if we have the URLs for the Source Page and matching Source Image where the content resides. We cannot remove content if we are provided with URLs containing www.bing.com or http://tse because these pertain to search results and are not the original location where the image resides. If this is what you are coming up with for the source image URL, you will need to go to your original query that brought up the image to find the correct source image URL.” The problem is that I no longer have the original URLs of those images because they were deleted from the source websites months ago. The only URLs that still exist are Bing “tse” cached image links. The images themselves appear to be indexed and served directly through Bing, even though the original content no longer exists. These images were removed a long time ago from the original pages, but they are still accessible through Bing search results. I am not sure what else I can do at this point. Is there any email address for Microsoft support that I can contact directly? Or is there another process for removing images that are no longer hosted on the original websites but are still indexed or cached by Bing? It is very important for me that these images are fully removed, as I do not want them to remain publicly accessible in search results. Thank you for any guidance.ChatGPT Enterprise Apps Grab Some Work IQ
If installed into a Microsoft 365 tenant, ChatGPT Enterprise apps can access SharePoint Online files, Exchange Online email and calendar, and Teams chats, messages, and tasks. The Entra ID apps created by ChatGPT have the necessary permissions to access information accessible to the signed-in user. Microsoft 365 Copilot can access more information, but being able to process files, emails, calendar items, and chats and channel conversations delivers access to a lot of Work IQ. https://office365itpros.com/2026/03/24/chatgpt-enterprise-apps-workiq/TechCommunity Report — Word extremely slow to open files (now resolved)
Issue summary Starting on March 22nd, Word became extremely slow when opening any .docx file (even new empty files). A document that normally opens in 5 seconds suddenly required 8–10 minutes. The issue affected all my devices (Windows PC, mobile, and Word Online). Symptoms observed Word took several minutes to open any file, including newly created ones Word Online displayed “servers are busy” errors My Microsoft account portals sometimes failed to load or did not recognize my identity The issue appeared immediately after an Office update on March 22nd PowerPoint and other Office apps were unaffected Another software opened the same files much quicker Reinstalling Office, repairing Office, and attempting System Restore did not fix the issue Key diagnostic findings The problem was not related to my files (another free online software opened them much quicker) The problem was not local to my PC (same behavior on mobile and Word Online) The issue was clearly linked to Microsoft cloud services or the March 22nd Word build System Restore failed, but the issue persisted exactly the same afterward The problem disappeared suddenly without any local change Resolution The issue resolved itself spontaneously. A document that previously took 10 minutes to open now opens in 5 seconds again. This strongly suggests that the root cause was on Microsoft’s side (cloud service dependency or faulty build). Current configuration After reinstalling Office, I am now on: Microsoft Word for Microsoft 365 Version 2408 — Build 16.0.17928.20148 (64-bit) This build is stable and does not exhibit the issue Request If possible, could Microsoft confirm whether there was a service degradation or a problematic build released around March 22nd? This would help users understand the root cause and avoid unnecessary troubleshooting. Thank you.Side Bar Index
I'd like to create a ln Edge (side-bar) index in a large document. In my mind it looks a little like the lovechild of the 'find in page' bar in Chrome, where the grey bar shows you how far the document you are, and the edge index on a multi lingual instruction manual, where the languages are typed in light grey on the side of the page, but black for the section that matches the language. I've worked out the edge index using section breaks for each chapter and colouring in the edge index for the chapter you are in, but I'm stuck on the progress bar... In Excel you can use a cell attribute, can you do this in Word with page number?Modern SharePoint Architecture: Best Practices for Scalable Intranets in 2026
In 2026, SharePoint has evolved from being a basic collaboration portal into the backbone of digitally-connected organizations. With businesses demanding agility, security, and personalized employee experiences, the architecture of your SharePoint intranet isn’t just “plumbing” it’s a strategic asset that shapes how people work, share knowledge, and innovate. In this guide, we’ll explore modern SharePoint architecture principles, practical best practices, and technical steps that will ensure your intranet scales with your organization securely and intelligently. https://dellenny.com/modern-sharepoint-architecture-best-practices-for-scalable-intranets-in-2026/
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
- Register now and save your spot for the chance to ask questions and share feedback with hundreds of Microsoft executives, engineers, and product leaders. By making your voice heard, your feedback wil...Mar 24, 2026
- At the Microsoft 365 Community Conference this April 21–23 in Orlando, we’re proud to spotlight a range of experiences created to support, connect, and celebrate women across the tech community—from ...Mar 24, 2026
