Recent Discussions
My Percentage of total sales is not 100 - Why?
I have 20 categories of Sales Revenue in Column A, the total revenue for each category is in column B, the % of a category, as it relates to the total categories is in column C but the Total Percentage is over 100% when I total all the percentages, what am I missing? Amount % of Sales Backup & Recover-Desktop Suppor 70,808.50 2.2% Barracuda Back Up - Cloud to Cloud 11,220.00 0.35% Barracuda ESS - Security Edition $51,508.57 1.62% Barracuda Sentinel 20,093.52 0.63% Carrier Management / NOC Support Services $239,618.99 7.54% Cust Support Srvs/Provisioning/vCIO Svcs $98,514.00 3.10% Field Services Support-Single $1,447,941.00 45.56% FTE Tech 159,227.50 5.01% Hardware Lease Revenue 11,114.22 0.35% Help Desk Services 1,604,649.85 50.49% IH-New User_Laptop Setup $230,523.19 7.25% IH-Remote Work Support Services 60,172.85 1.89% MRR - Data Services/Ticket Overage $40,057.00 1.26% Network & Security Hardware $985,825.90 31.02% Network Monitoring Service-Devices 153,696.60 4.84% NRR - Carrier Management / NOC Services 11,245.00 0.35% NRR - ESS Email Security Services 28,865.00 0.91% NRR - Help Desk 46,500.00 1.46% NRR - Migration Implementation 98,595.00 3.10% NRR - Monitoring Services 15,000.00 0.47% Remote Server Monitoring 102,455.03 3.22% Remote Work/Sharepoint Migration $84,026.55 2.64% Shipping & Delivery Fee 49,970.63 1.57% Software/Licenses 491,422.97 15.46% TOTAL $3,178,015.20 192.35%
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.
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.
Collegamento
Salve, quando vado a selezionare un nuovo collegamento (generalmente pdf) per una cella Excell mi viene cambiato il layout della cella stessa. Viene modificato il "colore riempimento", il "colore del testo" e l'allineamento. Fino a qualche giorno fa non avevo questo problema, è un bug di qualche aggiornamento o è risolvibile in qualche modo? Grazie per l'aiuto
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.M365 automatically reverts back to an older version
I'm migrating to Monthly Enterprise Channel using the M365 servicing plan which seems to work fine, except for a handful of computers. Their channel changes, but their office version will not stay current. After the version would not change from 2007 to 2211, I uninstalled Microsoft 365 Apps for enterprise and installed 2211. The next morning, I checked, and it reverted back to 2007. I've used this same process on several other laptops, and all has worked well. Any ideas why this is occurring?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.
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.
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.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.Automating Microsoft 365 with PowerShell Second Edition
The Office 365 for IT Pros team are thrilled to announce the availability of Automating Microsoft 365 with PowerShell (2nd edition). This completely revised 350-page book delivers the most comprehensive coverage of how to use Microsoft Graph APIs and the Microsoft Graph PowerShell SDK with Microsoft 365 workloads (Entra ID, Exchange Online, SharePoint Online, Teams, Planner, and more). Existing subscribers can download the second edition now free of charge. https://office365itpros.com/2025/06/30/automating-microsoft-365-with-powershell2/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/
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
