Recent Discussions
Improving How Outlook Classic Handles Reactions
A fix due in May 2026 will make sure that the Outlook classic client will handle Outlook reactions properly if the reactions are blocked. Of course, if tenants don’t like responding to email with an emoji, they can create a transport rule to insert the x-ms-reactions header. Detecting the header is an instruction to Outlook clients to suppress reactions that Outlook classic has been ignoring up to now. https://office365itpros.com/2026/04/17/outlook-reactions-classic/
Counting non identical columns
Could anyone explain how to count how many, or remove non-identical entries there are in a set of columns? e.g. In this table, in lines 1- 4 column A and B are identical, but lines 5 - 9, column A is the same in each but column B has a different value in line 9 than in lines 6-8. I want to find a way to count lines 1-5 as one entry and lines 5 - 9 as two entries (i.e. same code in all five lines but different date in one of them.) so the number of unique entries is 3. Line A B 1 G123456 01/01/2026 2 G123456 01/01/2026 3 G123456 01/01/2026 4 G123456 01/01/2026 5 H123456 03/01/2026 6 H123456 03/01/2026 7 H123456 03/01/2026 8 H123456 03/01/2026 9 H123456 05/01/2026
[DataFormat.Error] We received a malformed web response and credentials issue
Hi team :) Happy Friday !! There is an excel spreadsheet being connected with data sources and shared with users. Upon, hitting data refreshes it asks every user to edit credentials every time they hit data refresh or shows dataformat.error with malformed web response. There is no data format error though. Can anyone please assist here or know how to solve this issue ?? Thanks HappyDefault search scope in "find and replace"
Hi all, is there any way to make the search scope in the "fine and replace" menu (under "more") default to "all"? I have files with text boxes and the only way to make sure they are included is with "all", so every time I have to change it manually... Many thanks ahead!
Bad registrar on 365 side
Hello, We created a Microsoft 365 tenant several years ago but never used the online email services. We added and verifed our domain, which was registered with Orange at the time, and then created some users manually to use PowerBI. Today, we begin to migrate to Exchange Online. We have installed AD Connect and synchronized some users. Since creating the tenant, we have changed registrars (to Gandi), but I've noticed that the registrar hasn't been updated in the tenant 365. An `nslookup` correctly identifies Gandi as our current registrar. Microsoft has remained with Orange... and this is causing errors in the hybrid Exchange configuration assistant due to bad autodiscover. How can we "refresh" the registrar on the Microsoft 365 side ? Thanks for your advises Nicolas
Large text which repeats more than 500 times in a document - how can I delete it?
Hi all, I have a Word 365 document - 1170 pages, where I have one and the same text repeating more than 500 times. This repetitive text contains several paragraphs and a table and I want to remove it from all its instances. Is there any way to remove it quickly? I am not a word advanced user and cannot use macros.
Two days of edits inexplicably disappeared
I have a 2021 MacBook Pro and two days ago I updated my OS to Tahoe 26.4.1. The update seemed to work fine, and I continued working on a Word document I had been editing for the next two days. I always save after every line I write, and I use the auto-backup feature. There was no indication that my saves were not going through. Just now, however, I opened up the document to discover that all my edits (as well as the "last saved" time) had reset to what they were two days ago, around the time of the OS update. This is the case both in Finder and when I go to the Dropbox website, which I use to automatically upload everything I work on to the cloud. This is very alarming. Why has this happened, and is there a way to recover the lost edits? When I try to do "File -> Browse Version History" the menu item is dimmed and I can't click on it. Help!Conditional formatting for a whole column, based on same-row-cells, but in one single rule
I need conditional formatting, where the color of the cell in column F is changed based on the value in the cell in column W in the same row: I have done it like this: The cell F119 changes colour to orange if this is true: =OG($W$119<>"x";$W$119<>"CNG") This works fine. But I have not been able to find a way to make one rule do this for the entire column. So I have set an individual rule for each cell in column F and I have 376 rows so far. When I need to change the rule, or troubleshoot the rule, this is not operable. Also a lot of the cells have been edited with copy-paste, and now the conditional formatting is all over the place 😒 I would prefer one single rule, that checks the cell in column W in each row, and changes the colour in cell F in the same row, if the conditions are true.
Differences in Word for Mac and Word for Windows
I've been using Word on Windows for many years but recently have purchased a Mac mini and am trying to get used to Word for Mac. So far I've noticed one super annoying feature of Word for Mac: the spaces, tabs, paragraph symbols, etc., show up in blue instead of in the same color as the text. This is going to create a real problem when I start working on documents where I'm tracking changes, since the paragraph symbols might look like they've been inserted during an edit if the edits are being shown in blue--something I have no control over since other people will have already worked on the document before I get it. As far as I can tell, there's no way to change this. So I staretd wondering : How many other things are this vastly different on Word for Mac? Are there still keyboard equivalents of all the usual functions (like toggling Tracking on and off, adding a comment, saving, etc.)? Are there any functions completely missing from Word for Mac that are on Word for Windows? I still have time to return the Mac I got and try to find a Windows pc that meets other requirements I have. Thanks for any info you might have. I've done a lot of searching on the internet for this and have found very little detailed info.Excel changes multiple series colors at once
I have a simple X-Y chart with five series of markers, no lines. When I change the color of the markers on Series 5, Series 1 also changes to the same color, and when I change Series 1 back to the color it was, Series 5 also changes. It's like they've been linked somehow. Has anyone else seen this issue?Microsoft Forms – users submitting form without filling in required fields
Hi, can anyone shed light on a problem we're experiencing? We have a Microsoft Form for submitting content requests managed through Teams and using a Power Automate flow to pull responses through to Freedcamp. Recently multiple users have submitted responses without filling in required fields such as contact details etc. And one user was able to submit a form after uploading a file that was over the maximum size limit, which caused the Power Automate flow to fail. The fields are definitely marked as required on the form and appear with an asterisk. I am unable to replicate the problem. When I try to submit a form it flashes up a warning message saying 'The question is required'. The only edits we have made since the form was set up are to the text of questions. We haven't added/deleted questions or changed branching etc. Has Microsoft brought in any changes that could have introduced a bug? Thanks AmyFormula for adding multiple sheets
I am trying to add multiple things across multiple sheets. example : On sheet one, I have column a date, column b check number, column c name of place, column d category, column e withdrawal amount, column f deposit amount, column g balance, column h status (cleared or pending). this same information in on sheets 2,3,4,5 and so on. I want to create a sheet that will tell me how much I have spend with each name of place (column c). let’s say sheet one looks like this 3/23 (date) 777 (check number) John Doe (name of place) 2.00 (withdrawal amount) etc. 3/23 778 John Doe Jr. 3.00 etc sheet two 3/24 666 Joe Doe Jr. 3.00 3/24 668 Joe Doe 4.00 on my total sheet with the amount I have spend with each person/place to look like this Joe Doe — 6.00 (from the 2.00+4.00) Joe Doe Jr — 6.00 (from 3.00+3.00)MO 365 Excel - Difficulty Changing a Date format
I am using MO 365 - apps for Business, currently received an Excel Spreadsheet and am attempting to change date format in Excel and have tried all the usual methods however the dates remain unchanged. I need to change the date from month /day/year as 1/31/2025 to Year/Month/Day 2025/1/31 Any Suggestions? Thanks CJ
Changing color of connector lines in a waterfall chart for Mac
I am assembling a waterfall chart in Excel for Mac and I want dark, visible connector lines. However, when I highlight the connector lines I can't separate them from the border around the bars in the chart. This means when I make the connector lines dark, the borders of the bars in the chart turn black too- which I don't want. Can anyone explain how to separately change the color of the connector lines? Thanks!DLP Extends Its Ability to Control Copilot Processing
A new action for the DLP Policy for Copilot allows Microsoft 365 tenants to block Copilot from performing (Bing) web searches if a prompt contains sensitive information types. The new action allows Copilot to continue to process prompts using Microsoft 365 content (if the user has a Microsoft 365 Copilot license) while stopping potentially sensitive data being sent to Bing. https://office365itpros.com/2026/04/16/dlp-policy-for-copilot-web/
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
- Learn how we are leveraging AI to modernize our approach to change management and give you the tools, information, and processes you need to fully realize value from Microsoft 365.Apr 16, 2026
- Building in the era of AI can get very challenging. That’s exactly why we’re here to help you debug, refactor, and level up at the Microsoft 365 Community Conference, happening April 21–23, 2026 in O...Apr 15, 2026
