Recent Discussions
Equation Editor Wrong Highlight Color In Dark Mode
The highlight color in the Equation Editor is not correct when using dark mode in Word. The white text is unreadable. I’m seeing posts mentioning this issue from 4 years ago. How has this not been patched? How do I fix this myself if Microsoft won't?
outlook.office.com
I canno´t login in to outlook.office.com. Get the error message: UTC Date: 2026-04-05T10:38:19.885Z Client Id: C0B69CD1666C4BDCAD56171753860EF7 Session Id: e31a271e-c7b2-4f5f-abb5-854f463bfe2a Client Version: 20260320002.12 BootResult: configuration Back Filled Errors: Unhandled Rejection: Error: 500:undefined|undefined:undefined err: Microsoft.Exchange.Data.Storage.TenantAccessBlockedException esrc: StartupData et: ServerError estack: Error: 500 at Object.y [as createStatusErrorMessage] (https://res.public.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.mailindex.ad50be7b.js:2:299099) at https://res.public.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.mailindex.ad50be7b.js:2:23784 st: 500 ehk: X-OWA-Error efe: GV2PEPF0002396F ewsver: 15.20.9769.16 emsg: TenantAccessBlockedError And outlook on my devices don´t sync to exchange server Need some serious help/rzs43
A little help on text grouping delimited by nulls in a data set in power query
A have a column in power query: null line of text line of text line of text null The number of rows with lines of text can vary, but each "text block" is delimited by column entries at the top and bottom that contain 'null'. Ultimately, I would like to take each text block and populate a single cell with it. Probably in a new column in an excel table. Can I get a nudge in the right direction?
How to split Excel file into multiple files?
I’m facing an issue with a very large Excel workbook and need some help. The file contains thousands of rows of data, and now it has become extremely slow to open, edit, and share through email. Sometimes Excel even freezes while working on it. Because of this, I want to split the Excel file into multiple smaller files, but I’m not sure how to do it properly without losing formatting or data. I tried manually copying rows into separate files, but it is taking too much time and there are chances of missing important records. I also searched online for solutions, but most methods seem complicated or only work for small datasets. This Excel file is very important for my office work, and I need a reliable way to divide it into multiple files based on rows or column values. If anyone knows an easy method, VBA solution, or any trustworthy tool that can split Excel files automatically, please share the steps. Any help would be greatly appreciated!
Excel Functions
Find attached a matrix, and picture below I select Rare (0.5) in a cell and Modera (8) in another cell, i want function to return in a cell from matrix above. Like A (4) with green filled in. My inputs are Rare (0.5) and Moderate (8) and i want output cell to be Green filled in A (0.5) picked from matrix above. Like wise if the input cells are Possible (2) and Critical (50) then the output will be D (100) filled with light orange. I tried Index and Match function but failed. I can send the excel if you want. Please let me know what is the right function i have to use. Send the solution to mailto:email address removed for privacy reasons or email address removed for privacy reasons RegardsInherited group-based license service plan checkboxes are now editable but fail on save
Hello, We are observing a possible UI regression in the Microsoft 365 admin center related to group-based licensing. Environment / scenario: - Microsoft 365 admin center - User-level “Licenses and apps” screen - The user receives the Microsoft 365 license through group-based licensing - The source group is a Microsoft Entra dynamic security group - The license and service plan settings are intended to be controlled at the group-based license assignment level We understand that when a license is inherited from a group-based license assignment, the apps/services for that inherited license should not normally be changed directly at the individual user level. The service plan configuration should be managed at the group/license assignment level. However, the current UI behaviour is confusing. Observed behaviour: 1. Open a user in the Microsoft 365 admin center. 2. Go to the user’s “Licenses and apps” screen. 3. The user has a Microsoft 365 license inherited from a group-based license assignment. 4. Some app/service checkboxes appear to be enabled and editable. 5. An administrator can actually clear/uncheck those checkboxes. 6. However, when clicking OK/Save, the operation fails with an error. In other words, the UI allows an administrator to make a change that cannot actually be committed. The reason this looks like a regression is that the previous UI behaviour was different. Previously, when a user’s Microsoft 365 license was inherited from a group-based license assignment, the relevant app/service checkboxes on the user-level “Licenses and apps” screen were greyed out or effectively read-only. Administrators could visually understand that those service plan settings could not be changed directly at the individual user level. Recently, those same checkboxes appear to be active and editable. The administrator can uncheck them, but the change fails only after clicking OK/Save. From an administrator UX perspective, this is confusing because the UI appears to allow an unsupported operation and only rejects it at save time. Expected behaviour: If service plan settings for an inherited group-based license cannot be changed at the individual user level, we would expect one of the following behaviours: - The checkboxes should remain disabled/read-only from the beginning. - The UI should clearly state that these apps/services are inherited from a group-based license assignment. - The Save/OK button should be disabled for changes that cannot be applied. - The UI should provide a link or guidance to manage the setting at the group-based license assignment level. Questions: 1. Has anyone else observed this recent change in behaviour? 2. Was this UI change intentional? 3. Is this a known issue or known UX regression in the Microsoft 365 admin center? 4. Is there any scenario where these checkboxes are intentionally editable for a user who receives the license only through group-based licensing? 5. Does this behaviour differ depending on whether the source group is an assigned security group or a dynamic security group? 6. Is there any recommended administrator workflow when troubleshooting service plan settings for a user whose license is inherited from a group-based license assignment? To clarify, this is not a question about how group-based licensing works. The concern is specifically about the UI behaviour where inherited license service plan checkboxes were previously greyed out, but now appear editable even though the change fails on save. If this is not intentional, it would be helpful if the Microsoft 365 admin center could restore the previous read-only/greyed-out behaviour, or clearly explain in the UI why the change cannot be saved. Thank you.Calculating Employee Work Hours, Minus Lunch/Break Time
Hi All, I need help creating a formula and what cell to put the formula in. (See my image of sheet below) This is the formula I am using for the days of the week to calculate work hours: =(ABS(B3-B4 )* 24) I've tried =IF formula and it almost worked but ended up not being sufficient. If I need to redo the layout of the current sheet, I can. Thanks for any advice and solutions!Circular Reference Issues - A desperate woman needs help ASAP =(
I have an incredibly in-depth spreadsheet, with about 15 pages, and in-depth tables and calculations on most of those pages. Point being, I have a HUGE freaking file with tons of data collected over the years. Now, all of a sudden, I cannot input anything without the Microsoft Excel Warning popping up, stating: "There are one or more circular references where a formula refers to its own cell either directly or indirectly. This might cause them to calculate incorrectly. Try removing or changing these references, or moving the formulas to different cells." I understand what this pop up is saying, but my file is so huge, and there is so much information, I cannot find the error anywhere!!!!! And I don't have the option to search for it. So I cannot correct this error on my own, and I cannot input anything into the spreadsheet without having to exit out of that **bleep** pop up!!! I am defeated, INCREDIBLY FRUSTRATED, and I cannot see a clear path to recovery. I have been working on this document for years now, and I cannot start fresh. HELP, HELP, HELP!!!!!!!!!!!!! SOS!! Anyone! I am desperate and beyond frustrated =(Countif problem
Hi - could someone advise please? I have a workbook and am trying count the number of "Apples" in Col F, using $F$3:$F$81,"Apples" as the second criteria range and criteria. The first range and criteria is column B "Column1" is has mmm-yy and goes back a couple of years from Apr-24. I have tried COUNTIFS($B$3:$B$81,[@Column1],$f$3:$f$18,"Apples". Just doesnt seem to want to work. Any ideas? perhaps mmm-yy is an issue? thanks NoymanSharePoint 2013 Workflow Retirement: What It Means for Your Business
Microsoft has officially entered the final chapter of SharePoint 2013 workflows, and for many organizations, this update is more than just another lifecycle announcement — it’s a wake-up call. The retirement of SharePoint 2013 workflows in SharePoint Online marks a decisive shift away from legacy automation toward modern, cloud-first workflow platforms. For businesses that still rely on approval flows, notifications, and automated processes built years ago, the message is clear: those workflows will stop working, and planning can no longer be postponed. This updated news article explains what the retirement means, what changes technically after the deadline, and — most importantly — how organizations can migrate and modernize their workflows step by step. https://dellenny.com/sharepoint-2013-workflow-retirement-what-it-means-for-your-business/I am Facing Microsoft form related issue
I am Facing Microsoft form related issue, I can see when I am downloading a Excel copy some columns are blank. This is my survey form, and I cannot add manually however this will reflect manipulation in data, as this is technical glitch need assistant from your side on urgent basisMigrating G suite to Office 365
Dears, Good day, I working on a company which hosted their email on G suite, and I want to migrate all mailboxes, calendar, tasks, files, all things to Office 365. kindly let me know the steps for Migration, we have 69 users needed to be completely migrated. Kindly advisePlanner Synchronization of Microsoft 365 Message Center Notifications Improves
Microsoft published the very good news that the Planner synchronization with the Microsoft 365 message center will support HTML formatted text when it creates or updates tasks. This might seem like a small change, but if you use Planner to track the progress of anything, like we do for the Office 365 for IT Pros eBook, it’s sometimes the little changes that make the biggest impact. https://office365itpros.com/2026/05/15/planner-synchronization/How to unprotect Excel sheet if forgot the password
I recently encountered a problem and hope to get your help. I set a protection password for an Excel file before. Now I want to modify some data, but I found that I forgot Excel password. I wonder if there is any way to remove the protection or unprotect Excel sheet password? If anyone knows a related solution or has had a similar experience, please share it, thank you very much! This file is very important to me, and there is a lot of work data in it. I have tried some methods found on the Internet, but none of them worked. It would be great if someone could provide some specific steps or recommend some tools.
Cannot turn off Copilot in MS Word for Windows as "Enable Copilot" is missing...
This is ridiculous. I have spent over 2 hours trying to turn off Copilot in MS Word O365 version. I am running MS Word in I I Windows 11 (updated) and running what I believe is the most current version. I have been able to go into Excel => Options and uncheck the "Enable Copilot". I do not see such a box in Powerpoint (thank God - I don't see it in the app at all) and have been able to turn it off on my Mac Office Apps. I have an O365 account. When I open Word in Windows and then select the Options I get what is displayed below. Do not see the enable coPilot option, but CoPilot is on. This is ridiculous. I have cleaned the registry and I have seen hacks on how to turn off coPilot by butchering the registry, which I refuse to do. I even removed the coPolite App. MS, I DO NOT WANT TO USE AI TO WRITE. How do I get rid of this? I am EXTREMELY frustrated with this. Bryan
