Recent Discussions
In "Per-user multifactor authentication" I disabled MFA for one user; All got disabled
Hi, I'm the 365 admin for our org. Today I had a user that got a new phone and became stuck in a MS Authenticator app loop. (The app required MFA to login to the app, but they can't login to the app because they aren't logged into the app. This happened once before, and is a ridiculous Kafkaesque situation; but I digress.) To solve it, I went to disable MFA on their account, allowing them to login to the app. Then MFA could be re-enabled. Problem solved. And indeed that did work. However, on the admin side (per the screenshot) I checked off their user account (the user starting with the letter "B") and hit the "Disable MFA" link. A confirmation appeared asking me if I wanted to disable MFA for all selected users. Because I'm the careful sort, I could still see that only that one user was checked off as the popover div didn't cover that much of the screen. Hence I confirmed that I wanted to disable MFA for the selected users (i.e. that one user). I then refreshed the page, and all users are now shown as having MFA disabled. I'm 100% sure only that one user was selected, not everyone in my org. That would've been foolish. Trying to figure out what's wrong with this portion of the admin site.
Graph http 449 throttled
We are experiencing a lot of Microsoft Graph trolling errors from some of our applications that are hosted in Azure Web App Services and other third party such as Front App to name one. I am trying to find an approach or strategy to figure out and narrow down what may be causing so many of these events. Whether I can narrow down by application or process, I am not sure yet. We enforce MFA on all our users, but of course, on Azure Enterprise Applications, we don't, which are used extensively in our ecosystem of apps. Any help is much appreciated here.Excel Tools for Network & Windows
Excel Tools for Network & Windows Some time ago I already shared an earlier version of this project. Since then, I have added several new features. These tools are based on functionalities that already exist in Windows and its associated software. I have consolidated them into a single Excel-based interface, allowing all tools to be executed directly from Excel. The files are free for private use. For business or enterprise environments, a more comprehensive toolbox can be developed, enabling direct support, repair, management, monitoring, and control of users and systems. Everything can be customized according to specific requirements — the scope depends solely on the desired functionality, time investment, and budget. I appreciate any positive feedback, suggestions, or constructive tips. If this project is not of interest to you, please feel free to ignore it. Thank you, and I wish everyone happy holidays.How to Manage Teams Permissions and Privacy Settings
Managing Teams permissions and privacy settings is not just an IT task—it’s a critical part of maintaining productivity, security, and trust within your organization. In this blog, we’ll explore how Teams permissions work, why privacy settings matter, and practical steps you can take to manage them effectively. https://dellenny.com/how-to-manage-teams-permissions-and-privacy-settings/How To Use Sensitivity Labels in Microsoft Teams (Step-by-Step Guide)
Sensitivity labels help organizations protect data by controlling how information is accessed, shared, and stored. If you’re using Microsoft Teams and want to keep confidential conversations, files, and meetings secure, learning how to use sensitivity labels is essential. In this blog , we’ll walk through what sensitivity labels are, why they matter, and how to use sensitivity labels in Teams step by step, even if you’re not a technical expert. https://dellenny.com/how-to-use-sensitivity-labels-in-microsoft-teams-step-by-step-guide/Integrating Copilot in Microsoft Teams Channels and Projects: A Step-by-Step Guide
In this blog, we’ll explore what Copilot is, why integrating it into Teams channels and projects matters, and most importantly, step-by-step instructions on how to integrate and use Copilot effectively. Whether you manage projects, lead teams, or simply want to boost productivity, this guide will help you unlock Copilot’s full potential. https://dellenny.com/integrating-copilot-in-microsoft-teams-channels-and-projects-a-step-by-step-guide/
Opening Form through a non compliant browser looses full URL
When opening a Form on a non compliant browser - access is blocked and an option to Launch in Edge is suggested. Once Launch in Edge is selected a full URL to exact Form is lost and general page opens: https://www.microsoft.com/en-gb/microsoft-365/online-surveys-polls-quizzes Other resources such as specific files on sharepoint - onedrive opens fine. This is especially painful when Forms are being opened via QR. QR Code > Camera > Default Browser > Block > Managed Browser > General Forms Page. Does this sound like a design choice for Forms ?
Formula/method to link the data/responses I get from my forms into a different table.
Hi everyone! I need help with a project that I'm creating. Im making use of Microsoft Forms in order to input certain information. I made use of branching since some answers depend on the previous choice. So moving on to my problem, I want my table2 to get the responses/data from the data table created by the forms. Table 2 Table of responses For reference for the spill error, here is the formula that I used. Any insights will help a lot. Thank you have a great day everyone.
Cell Color Change
Hello, Sorry if this has been answered or is super easy but I couldn't find how to do this so I figured I would ask here. Is there a way for me to have a cell be blue normally, but turn green when clicked, and then back to blue when clicked again? I am using a sheet to track weekly check-ins and want to have an easy at a glance way to tell if I did them by color, and set it with a single click. Any help would be appreciated. Thanks
name manager rejecting lambdas
I tried pasting a lambda in name manager but excel refused. I belive that it's because either it is too long (which it isnt) or it has too many optional parameters (8). Anyone knows why name manager will reject to paste my lambda? These are the parameters: =LAMBDA(array,slice1,[index1],[return_index_slice2],[index2],[return_index],[if_not_found],[logic],[headers],[function],LET(...))
Native FIFO Inventory Costing Function for Excel (Proof of Concept with LAMBDA)
Excel currently lacks a native function to calculate FIFO (First-In, First-Out) inventory costs when products are purchased at different unit prices and later issued in partial quantities. FIFO costing is a standard accounting requirement under IFRS and is widely used in inventory management, retail, manufacturing, and financial reporting. Today, Excel users must rely on VBA, Power Query, or complex multi-step formulas, which are error-prone and difficult to maintain. As a proof of concept, I created a native Excel implementation using modern functions such as LAMBDA, LET, SCAN, MAP, and dynamic arrays. The function calculates the FIFO unit cost of the latest outgoing inventory movement, given: an array of incoming quantities • an array of unit costs for each incoming batch • an array of outgoing quantities While this demonstrates that FIFO costing is feasible using native Excel functionality, the level of complexity required highlights a clear feature gap. A built-in FIFO inventory costing function would significantly improve usability, readability, performance, and accessibility for non-technical users. I believe a native function such as FIFO.COST() or INVENTORY.FIFO() would be a valuable addition to Excel, alongside potential support for LIFO and weighted average costing methods. I’m sharing this example to illustrate both the feasibility and the need for native inventory costing functions in Excel. =LAMBDA( InQty, UnitCost, OutQty, LET( PrevOutQty, TAKE(OutQty, ROWS(OutQty)-1), LastOutQty, INDEX(OutQty, SEQUENCE(1,1,ROWS(OutQty))), OutIndex, ROWS(OutQty), RemainingFromPrevious, LET( InMatrix, InQty, OutMatrix, PrevOutQty, ApplyFIFO, LAMBDA(InMatrix, OutMatrix, LET( n, ROWS(OutMatrix), RecursiveFIFO, LAMBDA(self, Remaining, i, IF( i > n, Remaining, self( self, LET( OutAmount, INDEX(OutMatrix, i), CurrentStock, Remaining, Consumed, VSTACK( OutAmount, TAKE( SCAN( OutAmount, CurrentStock, LAMBDA(acc, qty, IF(qty > acc, 0, acc - qty) ) ), ROWS(CurrentStock)-1 ) ), IF(CurrentStock > Consumed, CurrentStock - Consumed, 0) ), i + 1 ) ) ), RecursiveFIFO(RecursiveFIFO, InMatrix, 1) ) ), ApplyFIFO(InMatrix, OutMatrix) ), FirstRemaining, SCAN( LastOutQty, IF(OutIndex = 1, InQty, RemainingFromPrevious), LAMBDA(stock, qty, IF(qty >= stock, 0, stock - qty) ) ), SecondRemaining, VSTACK( LastOutQty, TAKE(FirstRemaining, ROWS(FirstRemaining)-1) ), FIFOQuantities, MAP( IF(OutIndex = 1, InQty, RemainingFromPrevious), SecondRemaining, LAMBDA(stock, qty, MIN(stock, qty)) ), FIFOUnitCost, SUMPRODUCT(FIFOQuantities, UnitCost) / LastOutQty, IF(ROWS(InQty) = 1, UnitCost, FIFOUnitCost) ) ) Have a nice day. Juan Miguel Arraztoa
Microsoft 365 admin center support
I am extremely disappointed with the customer support experience associated with Microsoft 365 Business. As a business customer, I expected a reliable support system. Unfortunately, the reality has been the opposite, and I feel compelled to caution others to carefully consider their options before committing their hard-earned money to a Microsoft 365 business subscription. After purchasing Microsoft Business licenses and transitioning my services from GoDaddy to Microsoft, I lost access to my global admin credentials. This should be a straightforward issue for support to resolve, yet it has turned into a prolonged and frustrating ordeal. For the past two weeks, I have been trying to obtain assistance without success. I contacted Microsoft support over ten days ago and received a ticket, with the assurance that someone would contact me within 24 hours. No one has reached out to me—not in 24 hours, and not in the ten days since. I attempted to escalate the issue, but even then, no meaningful support was provided. This level of customer service is unacceptable for any business solution, especially one that organizations rely on for critical operations. It is unreasonable to expect customers to run their businesses effectively without access to timely and competent support. At this point, I am requesting a refund for the service that has not been delivered, and I strongly urge Microsoft to address the shortcomings in its support system. The support I received from GoDaddy in the past was significantly better. I hope no other business has to experience this level of frustration, and I sincerely urge Microsoft to acknowledge and fix these issues.Can't print this document! Print preview not matching Page Layout or Page Break Preview
I'm trying to "print" this to PDF, but can't get all my tables and graphs to fit nicely when printing This is my view in Page Break Preview This is my view in Page Layout This is the Print Preview screen, I think when it's scaling the rows to fit on one page, it's not scaling the graphs as well so they keep moving around. How do I make this look nice when I print? I have 16 tables with graphs plus a footer, so they aren't going to fit all on one page, that's why I set it to print over 4 pages.Using a combination of IF Statement and LET function
Hello, I am trying to do the following from the attached link: If the Fiscal period date in Col B (of the SORTED_INV_CN worksheet) is greater than/equal to Dec 2025 or less than April 2025 then type in "Ignore" Else, use the LET function to lookup by Invoice# in the LookUp-Comment worksheet However, the function in Cell D2 of the SORTED_INV_CN worksheet is returning "Ignore" for all the rows in Column D. At the end of the day, I am required to evaluate the xlookup function for date range less than Dec 2025 and April 2025. I am partial to the LET function as it reduces the need to add a 2nd xlookup formula. The LET function works without the parent IF function but is returning erroneous data as soon as I incorporate the IF(OR( function. Here is the link to the file: https://docs.google.com/spreadsheets/d/1oiWWXXOSorZuB5Q4vzgdHO_kyRkvGE3L/edit?usp=drive_link&ouid=103354753371375324640&rtpof=true&sd=true I think the problem lies in the way the date format is being interpreted between the evaluation cells. Hope you can point me in the right direction. Thank you. Regards, Shams.Find average with checkboxes
Hello, I’m not fluent in Excel but I do alright. Currently I am having a real hard time figuring this out. I’m trying to pull averages from different cells to one cell but based on if a box is checked. Backstory: I track times in a task and get the averages for each person but also the store average. As some people are no longer in those roles or now doing part time, I want the store average to only show the data from the people I choose. Ex: cell I3 is the store average. I only want it to account for the data in cell C11 if the checkbox in D10 is checked. I only want it to account for the data in cell G11 if the checkbox in cell H10 is checked. And so on and so forth. I have tried: =IF(D10,C11,IF(H10,G11)) =AVERAGEIF(D10,”TRUE”,C11(H10,”TRUE”,G11)) =AVERAGEIF(D10,”TRUE”’C11)&AVERAGEIF(H10’TRUE”,G11) but none of those have worked.
How to change primary user
I'm helping someone whose husband died. They have a "Microsoft 365 Family" plan. He was the primary person and she was a secondary user. I suspect for consistency of her information she should not make a new account in her name and abandon this previous account. Rather if possible she should keep the current account but make herself the primary account holder and make his email a secondary. She would keep his address active just for a while until everything to do with him is wound down. But how does she change the account so she becomes the primary? Thanks.Excel links are downloading files instead of just opening them
I have links to other workbooks in an excel document that on sharepoint. When I open it on the web, the links download the document instead of just opening it in a separate tab like it used to. When I open in on the desktop version, the links open the web version. I've tried adding ?=web1, I've checked all the setting that every other forum says to check but its still downloading them instead of just opening them. This is the 4th feature this month I've been using that Microsoft has made worse for no reason.
Recent Blogs
- Rich alt text is automatically generated when you insert an image, making your content more accessible from the get-go.Dec 22, 2025
- Powered by Microsoft 365 Copilot, Explainer offers instant summaries and explanations of text.Dec 19, 2025
