Recent Discussions
Power Query - How Do I Count a Number of Entries Based on Another Column?
Hello! The title might be a little confusing. Here's the situation. I manage uniforms for my team. I am making a SharePoint list and form that an employee will use to request the uniforms. Then, to give me a digestible table that shows me exactly what I need, I have an Excel Power Query pulling the list in. On the form, instead of having a different entry for each polo in each color, each size, and each cut, I have it separated so that you pick cut, sizing, and color separately. Is there a way to have Power Query pull it to show me, for the screenshot example: Female L Red Polo: 2 Female L Blue Polo: 2 Male M Red Polo: 3 Male M Blue Polo: 1 Male M Tan Polo: 2 So on, and so forth. Is this possible? Thank you!
Formula help
Hi all, I have a spreadsheet with four sheets of data (different suppliers, then organised by catalogue/non-catalogue products), and I want the product name to pull through to a fifth summary sheet if the number of items required is >0. So; I want the highlighted info from sheets 1-4 to pull through to sheet 5 (product name and number required) if the number required is >0 Hopefully that makes sense - can anyone tell me how to do this?Chart from dynamic array challenge
Hi (Excel 365 v2601 b19628.20132 Current Channel / Windows 11 25H2) Initial post edited (& cross posted here on Jan 29, 2026) after further investigations In B6 below an array that dynamically resizes according to the 'START Year' & 'TOPN Cat' variables. The Chart is setup as follow: Select an empty cell > Insert 2-D Line chart Right-click > Select Data… > Chart data range > Select the Serie names & Values (C6:G12) Click Edit under Horizontal (Category) Axis Labels > Select the range with the Years (B7:B12) Check of the Chart data range: Changing 'START Year' works no problem: the Chart data range & Horizonal Axis Label range are properly updated Changing 'TOPN Cat' (the array resizes horizontally) screws up the chart: The Chart data range is properly updated but the Series & Axis Label ranges don't update accordingly Q: Am I doing something wrong, facing a limitation or is this something else? Tried to attach the sample file 3 times... it's available at: Dynamic_Chart_Challenge.xlsx Thanks & any question let me know Lz.
Office OneNote Location
Office prof plus 2024. If i look in Options of OneNotes > save and backup i see the next location: C:\users\username\downloads\documents\OneNote-notepads\my notepads\loose Is it possible to change the root to > C:\users\username\documents\OneNote-notepads\my notepads\loose As you see without \downloads\ Thanks for your help in advance. Regards,Andre
Microsoft Access and Outlook
Hi there, I have just updated my laptop (with a view for a faster laptop!) However, Access was working fine and now i can't send emails from access through outlook like before. I get a message to say a program is trying to send an email message on your behalf. I'm not sure how to get rid of this warning! Please help.... Thank you in advance
Stacked Excel Formula
Hello everyone. I've spent the past 2-3 hours trying to figure this out on my own without luck. What I'm needing is a formula that will check D11 (highlighted) to make sure that it's within the parameters listed below it (<17), then I need it to do the same for H11 and I11 (highlighted) and enter the number (1-3) that are not "equal to or greater/less than" into K11. K11 reflects how many samples in Row 11 that are outside of those parameters. I'm trying to make this worksheet more automated and this is the one thing that I cant figure out. Example 1: (all numbers are within parameters, so a 0 is entered into column K) Example 2: (column G is not within the parameters, therefor there is 1 entry in column K)
Excel AND Formula displaying FALSE when it should be TRUE
I'm doing the CENGAGE Excel Assignment 2. I'm supposed to use the AND Formula like this: AND([Project Type]="Drama",[Approved?]="No" in the newly created "Delay?" column. But all the results are FALSE even when both conditions are met. Can someone explain to me why the logic is not adding up?Network connectivity test TCP Connection results unreliable
My team has spent the last 2 business days trying to get the https://connectivity.office.com/ TCP connection test to complete successfully to appease the Microsoft Unified Support Team. They don't want to take our MS Teams crash diags until they see SSL Interception Detection and TCP connection tests passing successfully. We can't get TCP connection tests to pass, we get one of the following: Success Attempt #1 Success, Attempt #2 Failure Any number of errors to unblock URLs such as (but not limited to) ocsp.digicert.com,ocspx.digicert.com,ocsp.omniroot.com,su.symcb.com,sr.symcb.com,sd.symcb.com,s1.symcb.com,sa.symcb.com We figured it was something with the corporate network but that's not the case. Last night we had about 50 employees try this test from their home (personal) computers that have no connection to our corporation. The TCP Connection test fails on home (consumer) PCs. What's the story with this TCP Connection check?WrapRows2Dλ / WrapCols2Dλ: Fast, efficient 2D wrapping without flattening
Background One of Excel's biggest weaknesses is in working with 2D arrays as objects that can be re-shaped. WRAPROWS/WRAPCOLS do not accept 2D arrays (#VALUE!) and are strictly for shaping 1D arrays. The usual workarounds involve flattening with TOROW/TOCOL then re-shaping with WRAPROWS/WRAPCOLS, REDUCE used as an iterator to stack (do-able but slow), and even MAKEARRAY (do-able, but not instinctive and slow). The Goal Fast, efficient 2D wrapping without flattening. The Approach Pure deferred i/j indexing with modular math and sequencing. The function and sample workbook is provided below. I welcome any and all feedback: suggestions for improvement, your approach to 2D shaping, etc. // Fast, efficient 2D wrapping without flattening //----------------------------------------------------------------------------------- //---WrapCols2Dλ--- //----------------------------------------------------------------------------------- //Author: Patrick H. //Date: 1/28/2026 //Version: 1.0 // //Description: //Wrap a 2D array into column blocks of a specified width while preserving row height. //The wrapped blocks are stacked vertically in the output. //Jagged or uneven final blocks are padded with NA() by default, unless a fill value //is supplied via the optional pad_with parameter. // //----------------------------------------------------------------------------------- //Parameter Description //array - 2D array to be wrapped (1D arrays not supported) //new_width - Number of columns in each wrapped block // //Optional Description //pad_with - Fill value used to pad incomplete blocks. If omitted, NA() is used. // //Lambda called: Echoλ WrapCols2Dλ= LAMBDA( array, new_width, [pad_with], //Check inputs LET( //Shape h, ROWS(array), w, COLUMNS(array), blocks, CEILING(w/new_width,1), //Optional pad_with, IF(ISOMITTED(pad_with),NA(),pad_with), //Total rows when wrapped r, blocks * h, //Scenarios Is1D?, OR(h = 1,w = 1), IsScalar?, AND(h = 1, w = 1), InvalidDim?,new_width >= w, SpillRisk?, r > 1048576, //Logic gate IF(IsScalar?,#VALUE!, IF(Is1D?,#VALUE!, IF(InvalidDim?,"#WIDTH!", IF(SpillRisk?,#NUM!, //Proceed LET( //Indices - deferred modulo, LAMBDA(MOD(SEQUENCE(r),h)), i, LAMBDA(IF(modulo() = 0, h, modulo()) * SEQUENCE(,new_width,1,0)), j, LAMBDA(Echoλ(SEQUENCE(r / h,,1,new_width),h) + SEQUENCE(,new_width,0,1)), //Wrapped array result, IFERROR(INDEX(array,i(),j()),pad_with), result ))))))); //----------------------------------------------------------------------------------- //---WrapRows2Dλ--- //----------------------------------------------------------------------------------- //Author: Patrick H. //Date: 1/28/2026 //Version: 1.0 // //Description: //Wrap a 2D array into row blocks of a specified height while preserving column width. //The wrapped blocks are stacked horizontally in the output. //Jagged or uneven final blocks are padded with NA() by default, unless a fill value //is supplied via the optional pad_with parameter. // //----------------------------------------------------------------------------------- //Parameter Description //array - 2D array to be wrapped (1D arrays not supported) //new_height - Number of rows in each wrapped block // //Optional Description //pad_with - Fill value used to pad incomplete blocks. If omitted, NA() is used. // //Lambda called: Echoλ WrapRows2Dλ= LAMBDA( array, new_height, [pad_with], //Check inputs LET( //Shape h, ROWS(array), w, COLUMNS(array), blocks, CEILING(h/new_height,1), //Optional pad_with, IF(ISOMITTED(pad_with),NA(),pad_with), //Total columns when unwrapped c, blocks * w, //Scenarios Is1D?, OR(h = 1,w = 1), IsScalar?, AND(h = 1, w = 1), InvalidDim?,new_height >= h, SpillRisk?, c > 16384, //Logic gate IF(IsScalar?,#VALUE!, IF(Is1D?,#VALUE!, IF(InvalidDim?,"#HEIGHT!", IF(SpillRisk?,#NUM!, //Proceed LET( //Indices - deferred i, LAMBDA(TOROW(Echoλ(SEQUENCE(,blocks,1,new_height),w)) + SEQUENCE(new_height,,0,1)), modulo, LAMBDA(MOD(SEQUENCE(,w * blocks),w)), j, LAMBDA(IF(modulo()=0,w,modulo()) * SEQUENCE(new_height,,1,0)), //Wrapped array result, IFERROR(INDEX(array,i(),j()),pad_with), result ))))))); //----------------------------------------------------------------------------------- //Echoλ //----------------------------------------------------------------------------------- //Author: Patrick H. //Date: 11/7/2025 //Version: 1.0 //Description: //Repeat each element in a supplied 1D array by specifying the repeat counts. //Arrays and scalars are supported. //----------------------------------------------------------------------------------- //vector - 1D array or scalar to be echoed //repeat - 1D array of repeat counts (must be numeric and ≥1) Echoλ = LAMBDA( vector, repeat, //Check inputs IF(OR(ISTEXT(repeat),repeat<=0),#VALUE!, LET( //Flatten inputs vector, TOCOL(vector), repeat, TOCOL(repeat), //Dimensions and row indexing V↕, ROWS(vector), R↕,ROWS(repeat), r, IF(V↕<>R↕,EXPAND(repeat,V↕,,@TAKE(repeat,-1)), repeat), i, SEQUENCE(ROWS(r)), m, MAX(r), idx, LAMBDA(TOCOL(IF(SIGN(r-SEQUENCE(,m,0,))=1,i,NA()),2)), //Unwrap idx but defer delivery until function invocation deliver, LAMBDA(INDEX(vector,idx())), deliver ))()); Workbook attached and linked in case this forum gobbles it up! Patrick2788/Excel-Lambda: Excel Lambda modules Excel-Lambda/Wrap2D Demo.xlsx at main · Patrick2788/Excel-Lambda Excel Lambda modules. Contribute to Patrick2788/Excel-Lambda development by creating an account on GitHub. github.com
How do I auto-populate information from one tab to another in sheets?
I have an excel sheet with several tabs. The first tab is the Master tab used to track all tabs. I would like all new tabs to auto-populate information into columns on the master tab. For example, I have multiple fields in my form I would like information from these fields to auto-populate into the master spreadsheet. I would like all new forms/tabs to automatically update the master spreadsheet. I am currently entering everything manually.Optimizing Microsoft 365 Licenses Using Behavior Data (E3/E1/F3)
Hi everyone, We are currently working on a Microsoft 365 license optimization initiative and would appreciate insights from the community and Microsoft experts. Our approach focuses on two main areas: (1) Revoking licenses for inactive users, and (2) Reviewing active users to ensure their assigned license (E3, E1, or F3) aligns with actual usage and collaboration needs. From a data perspective, we are leveraging Microsoft 365 usage signals such as Teams activity, Outlook email interactions, meetings, and SharePoint/OneDrive collaboration. While usage reports provide raw metrics, we are looking for guidance on how these signals should be interpreted and combined in a meaningful and fair way. Specifically, we would like to understand: (1) Which usage metrics best represent user collaboration behavior? (2) Are there any recommended thresholds or patterns that help distinguish light, standard, and heavy collaboration users to map E3, E1, or F3? Any best practices, references, or real-world experiences would be greatly appreciated. I'm sorry if this is the wrong forums to ask for. Thanks in advance for sharing your insights.Trying to fill a field in excel with 3 different wordfs based on another field result
I am trying to fill a field in excel with 3 different words based on another fiels results. Result field will have a percentage based on a calculation which is already set to show 3 differnt colors based on the reults. ie: 0-32% is red, 33-74% is Yelow and 75-10% is Green, ths field is G7 I want to have the result of G7 to fill G8 with the the following statement, and include the color fill above. If G7 is 0-32% then "Bad Deal", if G7 is 33-74% then "Fair Deal", if G7 is 75-100% then "Good Deal" Looking to the Deal words placed in the field based on the result of G7Using Copilot and other Addins in "Edge Apps"
Hi everyone, i want to use Copilot in my PWA - this is not possible? Why is there such a restriction? It makes no sense? I created a feedback - please vote Allow Copilot and other addins in PWA · Community You’re running into a known limitation of Microsoft Edge “Apps” (site-as-app / PWA mode): 👉 Copilot Chat, M365 add-ins, extensions, and the sidebar are not available inside Edge apps. Here’s what’s going on — and what you can do. ✅ Why Copilot & Add-ins don’t show in Edge App mode When you install a website as an app in Edge (PWA mode), the resulting window runs in a minimal UI container. This mode intentionally removes browser features — including: Edge sidebar (where Copilot lives) Browser extensions Add-ins Many productivity/AI integrations This is confirmed by Microsoft’s PWA documentation: PWAs run like standalone apps and don’t expose the full browser interface or settings. [learn.microsoft.com] So your ITSM tool as an Edge App simply cannot load Copilot or add-ins – by design. ✅ How to enable Copilot & Add-ins when using your ITSM tool Option 1 — Open the ITSM tool in a normal Edge tab This is the easiest fix: Open Microsoft Edge normally (not the app window). Navigate to your ITSM tool’s URL. Use Copilot Chat (sidebar) and any extensions/add-ins normally. This gives you full Copilot capabilities, including Copilot Mode options from Edge settings. [pureinfotech.com] Option 2 — Pin the site instead of installing it as an app If you still want fast access: Right‑click the tab → Pin tab, or Add it to Favorites, or Add it to the Edge sidebar This preserves full browser functionality including Copilot. Option 3 — If you must use app mode There’s unfortunately no supported way today to enable: Copilot sidebar M365 add-ins Extensions …in a PWA window. Edge currently isolates PWAs from browser-level AI features (no Microsoft documentation or Edge settings allow re-enabling them). 🧩 Optional: Enable Copilot Mode in full Edge (not PWA) If you want the richer Copilot experience in normal Edge, ensure Copilot Mode is enabled: Go to: edge://settings/ai Turn on Copilot Mode. (Available on Edge v141+.) [pureinfotech.com] This gives you: Copilot button in the toolbar AI-powered new tab experience Better in‑context Copilot support But again: This does not apply to PWAs. 🎯 Summary Environment Copilot Sidebar Extensions/Add-ins Recommended? Edge normal window ✅ Yes ✅ Yes ✔️ Best choice Edge App (PWA) ❌ No ❌ No ❌ Not for Copilot BR Stephan
Quotation Marks - Losing my mind over Excel error
Hello everyone, As per title: trying to follow basic instructions (=C4," ",B4) and so on. Excel keeps returning an error message. I am aware of the difference between straight quotation marks and curly, dialogue ones, but still. As soon as I enter those, error keeps popping up. Please see below. My Excel is set in Italian, is that a location thing? Thank you.The Copilot Agent Mode icon in Excel, which I was using until a few days ago, is no longer visible.
I am a user of Microsoft 365 Premium on the Beta Channel. I was able to use it until a few days ago, but the Agent Mode that was visible until recently (as shown in the snapshot) is no longer visible. Why is this happening?Stop scrolling across slides
Currently if you slowly scroll to the edge of a slide (to examine/edit the details there), all of a sudden you land in the adjacent slide, defeating the purpose of scrolling. My humble ask: please make mouse scrolling only move inside the same slide. NEVER jump to another slide. If near the edge, show a margin of the next slide but don't jump to it unless the mouse clicks on that margin. Page Up/Down keys should be used to jump between slides, AND jump to the exact same location of that slide -- very useful for quickly going through slides and see if elements stay in the consistent spot (elements could be different and can't be placed using the slide master). Ctrl + mouse drag = pan (feature request) Ctrl + mouse wheel = zoom (existing feature) Mouse drag alone = select (existing feature) Mouse wheel alone = scroll (existing feature -- but don't go across slides!) Page Up/Down = fly through slides (always land in the same location) Left/Right/Up/Down arrows = slow move inside slide (when no element is selected) Now imagine the productivity/experience enabled by this solution...Indenting in numbered list has gone haywire
My office uses custom Word templates that are updated to a legal software site, populated with an intake form through the same site, and then downloaded to our individual computers to edit as needed. The templates mostly use legal numbering under the Normal style. On Tuesday February 3, everything was working fine when I put my laptop to sleep. The next morning, I opened a Word document that I had downloaded from the legal software site and edited a week or two previously, and the formatting and indentation of the numbered lists was suddenly completely wonky. I had not changed any settings from the end of one day to the beginning of the next to cause this issue. In addition, I am the only one in the office of five people to be experiencing the problem. I contacted tech support, and the support person walked me through fixing the styles settings, and when that did not work, they uninstalled and reinstalled the entire Office suite. That also did not solve the problem. I'm completely stumped here; why would this issue suddenly arise with no input from me and also only affect my version of Word? And why didn't reinstalling the application fix it?? Details of the formatting issue: Normally, the numbering should look like this FIRST 1.1 The text goes to the right margin of the page and then wraps so that the second line is indented by the same amount. 1.1.1 The first sub-paragraph begins at the indentation of the text in the first paragraph 1.1.1.1 The second sub-paragraph starts the same way, etc. Now it looks like this: FIRST 1.1 The text begins closer to the number and goes to the right margin, then the second line is not indented to begin at the same point as the first line. When I click on the leading number (e.g. 1.1), some of the text jumps over to the right slightly. When I try to use the markers on the ruler to adjust the indentation, the text doesn't move at all. In addition, I can open a document, not mess with the wonky formatting but change something else, for example remove a watermark, then save and close the document, and one of my colleagues can open the same document and not have the formatting be messed up. Please help!Microsoft Feedback Portal account issue
I changed my Microsoft email a year ago, and it updated everywhere other than the Feedback Portal. As a result, I get an error when I try to login, or do anything on the page. Microsoft account support's suggestion was to login to the Feedback Portal which is insane given I'm having issues accessing it. How can I get this issue resolved? I've got three separate support tickets now and they keep asking me to wait 24 hours to get the issue resolved. Can someone from the Feedback Portal team please contact me to resolve this? This is what Microsoft Support have said: "understand your frustration, and yes—this is an account‑related issue because the Feedback Portal is still tied to your old alias, which causes login conflicts and forces you out. Your Microsoft account itself signs in correctly, but the Feedback Portal is pulling outdated identity data that you cannot update on your own. Since you cannot access the Portal to submit feedback, directing you back there is not a workable solution. What you need is for Support to escalate this to the internal Identity/Feedback Platform engineering team so they can manually correct the outdated alias mapping on the backend. In this situation, the Feedback Portal and Tech Community teams are the ones who manage and maintain that specific platform. Because the issue appears on the Feedback Portal side—even though your Microsoft account is working normally—only their dedicated team can make the necessary corrections on their end. That’s why we are guiding you to connect with them through the links provided: https://techcommunity.microsoft.com/ or https://feedbackportal.microsoft.com/feedback. They will be able to review the portal‑specific account data and assist you further. I understand why this is frustrating. Since you’re unable to stay signed in to the Feedback Portal, I completely see why posting there isn’t possible for you. However, I do need to be transparent: I’m not able to escalate this issue directly to the Feedback Portal team, as they don’t provide internal escalation channels for us and only accept requests through their own platform."
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
- No more skipped content or missed information - Take advantage of this new setting to naviagte through your content more intuitively.Feb 05, 2026
- Plan smarter with Microsoft 365 Copilot to make every day count in February.Feb 03, 2026
