Recent Discussions
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
Can't access Microsoft Authenticator for business accounts
Hello. I am the tech support for a small church, where I am the admin for our MS 365 accounts, which are set up as "business accounts". I have been using Microsoft Authenticator for MFA for years. Recently I switched to a new phone and installed Microsoft Authenticator. All of my personal Authenticator accounts transferred over just fine, but all of the church's business accounts say "Scan the QR Code provided by your organization to finish recovering this account". The thing is, I am the "organization" and I don't know how to generate any QR code to recover the accounts. It was suggested that I could do something about this by logging into my Microsoft 365 administrator account, but when I try to log into my admin account, the only MFA option is "enter the code from Microsoft Authenticator". It's not offering a text or alternate email, only Microsoft Authenticator, which is what I'm locked out of. So I'm stuck in a loop. I opened a ticket with Microsoft Support nine days ago. I have received one phone call since then. The support person insisted that they needed to talk to the account's "alternate administrator", which I set up as my pastor, who is pretty computer savvy but not a deep IT person. They tried to call him one time, but he was not available to answer right then. There has been no communication since then. I'm hoping someone in this group can help me figure this out.
Link 2 sheets, then sort column A on sheet 2 alphabetically and match correct data
I have two sheets on the same spreadsheet, and I want to pull in the data from 4 different columns to the second sheet and have it automatically update when there are changes or additions to the first sheet. I have a couple issues making this happen - the main one is that the data in my first sheet is custom sorted by color, but I want the new sheet to take the data from column B on sheet 1 and sort it alphabetically, and take the other columns and match them correspondingly to the correct values they match to from column B on the first sheet. Secondly, for blank cells, I want it to leave them blank instead of inputting zero, or any dates. I don't know if this is all even possible, or if I should just remove my custom filters from sheet 1 by cell color and just link it that way. I've spent hours trying to find formulas that work. Please see attached images for reference on what I've tried, and for more clarification as to exactly what I'm requesting. Sorry for the copious redacting, I wanted to be safe rather than sorry with identifiable info regarding this. Any help would be greatly appreciated.Microsoft Teams – “Save this message” feature missing in both Desktop and Web clients
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } Hello, We are experiencing an issue in our Microsoft 365 tenant where the “Save this message” feature in Microsoft Teams is not available, neither in the Teams desktop app nor in Teams Web. Details The feature should be available globally, as Microsoft planned full rollout between August and October 2025 (Microsoft 365 Roadmap ID 496369). This is confirmed in multiple official and community‑published sources. https://m365admin.handsontek.net/microsoft-teams-users-can-save-chats-channel-messages-later/, https://supersimple365.com/teams-save-chats-and-channel-messages-for-later/ Microsoft also stated that no admin controls exist to disable this feature and no configuration is required in the tenant. https://m365admin.handsontek.net/microsoft-teams-users-can-save-chats-channel-messages-later/ Despite this, the option does not appear at all in the message overflow menu (… → More actions) in both: Microsoft Teams Desktop (version 26032.206.4355.6508) Microsoft Teams Web (teams.microsoft.com) Troubleshooting already performed Full cache removal for the new Teams client under: %localappdata%\Packages\MSTeams_8wekyb3d8bbwe\LocalCache Log out / sign‑in cycle Full Teams desktop restart Verification across different clients (desktop + web) Verification from multiple messages and channelsPlanner’s Newly Redesigned Interface
Microsoft has launched a redesigned user interface for the Planner app. The big news is the inclusion of task chat. Goals are also available, but only to people with a Microsoft 365 Copilot or Planner Premium licenses. Task Chat is a nice feature, and I am sure that it will be popular. UX redesigns often disappoint. At least this one offers new features. https://office365itpros.com/2026/02/27/planner-new-ux/#Connect Error in Excel for StockHistory Function
Evening, I am an O365 subscriber and am trying to set up an Excel sheet as a VAR template, and I wanted to populate my workbook with some historical data without uploading a CSV. Figured I would try out the StockHistory function. I keep getting "#connect" for my cells, and I am not sure why. I am not in developer mode, do not have any crazy add-ins, I am signed in, and connected to the internet. Do I need to be connected to a source? I am fairly new to learning about the StockHistory Function. Any thoughts on the matter are welcome. I tried all that I could from this site below: https://support.microsoft.com/en-us/office/how-to-correct-a-connect-error-584f7de9-b238-480c-8e8f-de0ba2c1aac9
I am getting the message "WORD did not save the document C:\...\AutoRecovery save of...
Recently I am getting the message "WORD did not save the document C:\...\AutoRecovery save of..." This happens when I am working on large WORD documents, of about 700 pages. I have gotten the message when using WORD on two computers, in different locations. I have worked on these large documents for months without getting this message. I will appreciate advice.
Still learning Excel and got an update that changed my open screen
It looks like Excel updated last time I closed it and now when I start it all my favorites are gone as well as recent files. I don't use One Drive and it just defaults to looking at One Drive. Even after I have opened different files on my computer they do not show up in the Recent files. How can I reset this so I can get back to my old screens and set up favorites again as well as see my recent files opened and not default to One Drive. I have changed the settings in the Save Options so it does not save to the cloud and the default location is not One Drive, but I can't seem to get the opening screen to show recent files or my favorites. Any help will be appreciated. Thank you in advance for this. Take care.Update changed open settings
I don't know if it was an Excel update or OneDrive update, but I no longer have my favorites or recent files that I saved on my computer showing up in the home screen. Now it just defaults to the One Drive location even though I have turned off save to One Drive and turned on save to computer and given it a default location. I am at a loss any help will be appreciated. I thought I published this earlier, but cannot find it so am trying again. Thank you for any help and take care.
Cell Use from one sheet to Another
Hello. I have a multi-page workbook that requires using cells from one sheet on other sheets in the same workbook. I have one instance that in trying to work it out, has caused a second issue. When I try to add the cell from the one sheet to the next sheet using +=, then clicking on the sheet and cell to acquire it, when it posts is a 0. In trying to solve my issue and going to the sheet and cell in question, this is what I see. Highlighted cell. So, initially I was able to total that column. Now I can't because it no produceds a 0. It seems for some reason that cell does not show as =+'Wages'!G15, if I manually input that in the cell I need it in (on the other sheet) it still posts as 0. The source sheet for Wages is below this sheet. Can anyone help me get this worked out so I can use the required cell on the sheet i need to use it on?
Excel Drag and Fill Handle not working as I would like
I am copying references from one workbook to another for organization. Both Workbooks are organized in tables. Earlier today I was able to filter table 2, by category in Column I, and paste the new Reference code in the correspoding Column M cell. For example I would filter by Column I in Book 2, Table 2, and the copy the reference from book 1, table 1. I would paste the reference into Cell M2. Because I had the filter applied I wanted to apply the reference to the end of the table in column M. So I was able to double click the drag and fill handle, and it would populate the rest of column M below in the table with identical references. Now, when I use the exact same method, double-clicking the drag and fill handle changes th reference entirely to previous reference no longer needed. The only options I have accessed were "Special" trying to clear formulas in other columns while leaving the text. Enable Fill handle and cell drag and drop, and Automatic Flash fill are both enabled. what is causing my issue, and how do I fix it?
Excel not publishing OLE
Excel no longer publishes any OLE clipboard formats in build 16.0.19725.20078. Copying a cell and using Paste Special in Word/OneNote shows no “Paste Link” and no “Microsoft Excel Worksheet Object.” Only text/HTML/bitmap formats appear. This blocks creation of linked or embedded Excel objects. Issue is fully reproducible: new workbook, enter value, copy, open Word → Paste Special. Expected: Paste Link + Excel object formats. Actual: missing. Verified after full repair, reinstall, Safe Mode, new profile, add‑ins disabled. Excel→Excel copy works; Excel→external OLE formats do not. This appears to be a regression in the OLE clipboard publishing pipeline for this build family.Microsoft Places desk declined despite check-in
Each We've just started using Places in our office and a few users have reported recieving a desk decline email due to no check-in on the desk, despite them using the check-in button on the Places app to check-in on arrival to the office. Has anyone seen this previously? Each desk has two monitors, which I have associated with the desks in the Teams Pro Management portal to enable detection and check-in. Reservation settings for all desks are as below.Copying column widths and row heights from one sheet to another
Hello everyone. I have to reformat a rubbish PDF i get sent everyday so i can make it legible. i have arranged the cell widths and heights and cut and pasted the data but there are 14 columns and as many as 30 rows. I have this information on PDF everyday. Is there a way i can automate this so my sheets are all the same looking?Only Powerpoint templates in Create in Office.com
Why do I see only our Organisation Powerpoint templates in https://m365.cloud.microsoft/create/?auth=2 In the desktopapp alle are accesible Word, Powerpoint, Excel, but not online. Anyone? This: Connect-SPOService Set-SPOTenant ` -OrganizationAssetsLibraryUrl https://tenant.sharepoint.com/sites/sjablonen/OfficeTemplates ` -OrganizationAssetsLibraryType OfficeTemplateLibraryPublish an Excel Add-in by just submitting the add-in manifest to Microsoft Marketplace
I am working on Excel Add-in built using the react template. We are planning to host the add-in code on our domain and update the manifest to point to the URL for our domain. Can I just submit the add-in manifest to Microsoft to publish it in Microsoft Marketplace?Extending Protection for Confidential SharePoint Online Files
Sensitivity labels offer great protection against unauthorized access, but sometimes files that aren’t encrypted escape from a document library. SharePoint Online can now use sensitivity labels configured with user-defined permissions (UDP) to extend protection to downloaded files. The magic works by configuring permissions on download based on the membership of the user who downloads a file. https://office365itpros.com/2026/02/26/sensitivity-label-extend-protection/
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
- Agent mode in Microsoft 365 Copilot Chat now enables you to query locally stored Excel workbooks on Windows and Mac desktop.Feb 27, 2026
- You can now have Copilot in Outlook reschedule personal appointments and one-on-one meetings if a conflicting event arises that takes priority.Feb 27, 2026
