Recent Discussions
How to anonymise user file uploads in MS Forms
Hi, I've created a form to allow users to anonymously report IT incidents, but when someone uploads a file I'm getting an email from Sharepoint Online telling me the name of the user who's uploaded it. The red in the top right is the users name. The form itself doesn't tell me the username, that part of the anonymisation is working fine, it's just this bit related to file upload. This kind of defeats the point of allowing anonymous reporting, and whilst the users wouldn't know, it is a breach of trust when we're trying to create a positive attitude to security. Is there a way to turn this off?
Unable to view Active user and unable to add shared mailbox
Hi Team, I'm trying to add a shared mailbox under MS 365 Admin, I am unable to 1. Add a new user (admin role error) 2. View active user (which I'm logged in with) 3. Add a shared mailbox (retry again/ from last few days) 4. Contact Support - error loading chat Any help would be appreciated.Entra and Microsoft 365 Could Improve License Reporting
License insights is a new feature in the Entra admin center. The Microsoft 365 admin center also shows some license insights in a dashboard card. The two views don’t line up. This isn’t very surprising because different teams generated the information, but it would sure be nice if Microsoft delivered comprehensive license reporting for Microsoft 365 tenants, including the Entra premium licenses. https://office365itpros.com/2026/04/24/license-insights/
Cross Referencing Data in Excel
Hello, I have a spreadsheet that lists document numbers that are stored in a document management system. I have to cross reference the documents in that management system, which means I have to go into each individual document in the management system and add in all the documents where that individual document is referenced. The attached spreadsheet lists all the documents in our system (column B) and each document where they are referenced (columns C-AP). Is there a way to have Excel search columns C-AP, find a specific value, and provide me with a list from column B where that value is found in columns C-AP?
What is this Madness? Weird Average and Sum results
What is this devil math? What am I missing? The darker green value and blue value should match. I checked for truncated decimal values, even rebuilt the sample to ensure nothing was weird about the original cells. This is not an insignificant difference for what I'm doing, and I don't understand why these aren't lining up. I'm sorry if I'm missing something simple, but please, help!
I need Help with Cell Formatting to be able to copy
I have a number in a cell 2022 NET 260 $ 241.32 and I want to get the NET of that value by taking the 260 and multiplying it by another cell Monthly Percentage 7% and subtracting that number from the original 260. I then want to be able to copy the formula and paste it down the column yet making sure that the 7% Cell remains constant unlike the 260 cell. I forget how to do that. Help
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.
Word Version Incompatibility
Good morning everyone, I've switched from Microsoft 365 Personal to Microsoft Plus 2021 Business. My question is, is there any incompatibility between the Word versions of these two services? I ask because when I try to work with a file saved as a "Microsoft Word 97-2003 Document," I get a memory error message. However, when I save the same file as a "Microsoft Word Document" and work with it, I don't get the error message. Looking forward to your kind reply. Fernando
Combine data from 2 columns into 1 column
I want to do this, but with 2 columns of data. We have a sheet with area codes in one field and phone numbers in another. I need the 2 pieces of data in one field for a list of 500 phone numbers. Do I have to do them one at a time???? Combine data with the Ampersand symbol (&) Select the cell where you want to put the combined data. Type = and select the first cell you want to combine. Type & and use quotation marks with a space enclosed. Select the next cell you want to combine and press enter. An example formula might be =A2&" "&B2.How to purge OneDrive from the default user folders
Hi. I got this PC a while ago and OneDrive just kinda set itself up based on my Microsoft account. It was decently useful having access to my OneDrive files as a folder on my PC but I do NOT want it backing up my files automatically, partly because I want those to be offline and because I really don't need constant popups telling me I named my file wrong or that I ran out of space. So, I disabled synchronisation for those folders - I'm talking about the default documents, images, etc. folders. Yet there was then two seperate folders called Images (or whatever that folder is called in English Windows), one with the path C:\Users\cherr\Pictures, and one with the path C:\Users\cherr\OneDrive\Pictures. Explorer sees the top one as the default, and displays the shortcut to that in the bar on the left, while other programs such as my very old Canon document scanner's user interface sees it as the bottom one. I tried everything I could think of, including cutting the OneDrive folder and putting it in a different location in order to not lose any of the files), then renaming it. Yet somehow the scanner software and others, even if I manually select the correct folder, still default to the new path which is now C:\Users\cherr\piss off onedrive\anything but OneDrive\Pictures. I have had to turn off the OneDrive app altogether, which is problematic as I am also logged into a school account on that (which has caused zero problems) to which I need regular access for the files on it. Yet even this does not fix it. Please help me out with this, as I now have two seperate folders called "Pictures", which are defaulted to depending on which app I am using.
Broken Account Recovery (discontinued product)
Hello everyone, We have the MSFT Office Family plan which has the now discontinued custom domain support that used to be an option as a "Premium" feature. Back in August we upgraded the phone of one of the account members on the family plan and lost connection to their MS Office account with the only device that was accessing to the account (the phone with access was reset as part of the upgrade/trade in process). I have tried the account recovery form and it simply doesn't work. I have tried to explain to MSFT support that the tool is broken but can't get anywhere. For the account in question we have an Outlook email client (with non working password) that has a cache of all of the email until loss of access occurred. So when I do the account recovery form, I have name, DOB, region, past passwords and data for all fields including sent email Id's and send subjects, But every time the MSFT recovery mechanism says "Unfortunately, we have determined that the information provided was not sufficient...". WTF. Every time I contact MSFT support I get the same answer, an explanation of the point system used to reset the the account. Same steps to recover....based on this, the recovery should work...yet it doesn't. I have tried somewhere 50+ attempts now over the last 9 months. I even have a contact who is VP level at MSFT who sponsored a support ticket internally but that just ended up with the support person sending me a link to the account recovery form and closed the ticket without looking in the details of the ticket. I can't modify / add a new account as MSFT has as a discontinued product no longer allow members to add/change id's. So I'm locked at the current user set. I have created another email address by saving the cached data to OLM file and importing via the Outlook client but that doesn't restore use of the @mydomain.com for that person. I even retained a lawyer who send a demand to MSFT legal...but the email address didn't go anywhere so at the point of needing to do this on headed paper/send via snail mail. Does anyone have any idea how to get through to MSFT explain the recovery tool is broken? I assume there are so few accounts using custom domains pin family plans that they simply don't test this recovery path. At this point without some internal guidance is a) lawyer and force a demand for password reset b) give up, ditch all of the users using the custom domain, configure an alias for all of the accounts and then change my MX record to a company doing email forwarding and then forward to the new/old legacy accounts (i.e. the ones with the mailto:email address removed for privacy reasons).
Adding Error Bars to a Graph
I created a bar chart and it wonʻt give me any option to add error bars. This is my first time using this new excel format, and I donʻt know where to go for the error bars. I have tried to google it and watch videos but all the instructions and tutorials are for different excel versions.Running performance reviews without leaving Microsoft 365?
We're a mid-size company (~300 people) and currently doing performance reviews in a standalone HR platform. The problem is nobody opens it. Adoption is terrible because people live in Teams and Outlook all day and having to log into a separate system for reviews just doesnt happen. Has anyone managed to run their full review cycle (self-assessments, manager reviews, calibration) inside M365 or Teams without needing a completely separate tool? Trying to avoid another "tool nobody uses" situation.
Events
Agent 365--generally available May 1, 2026--is a control plane that empowers IT admins, Security Operations analysts, Identity and Network Security admins, and Data Security & Compliance admins to ob...
Online
Recent Blogs
- Join us for a joint webinar with Orchestry on May 7 to learn more about file-level archiving and using it at scale.Apr 23, 2026
- Use watermarks to indicate when content has been generated or altered using AI, and support responsible sharing and clearer communication.Apr 22, 2026
