Recent Discussions
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)
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!
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
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.comUsing 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
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?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!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.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 G7
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?Sync Issues with Tracking Meetings from Outlook to Dynamics 365
Hello, my work uses the Dynamic 365 App for Outlook to track meetings as appointments in Dynamics 365, but it has failed several times for several users (on both Mac and Windows, in Old and New Outlook and on web browsers); some meetings will fail to track immediately while in some cases, meetings that were successfully tracked will stopped working and are no longer tracked in Dynamics. In the spoiler below is a sanitized version of the diagnostic log for meetings that used to be tracked that stopped working: In the log, we have the following error message: "lastsyncerror": "ExchangeSyncGeneralCrmItemSyncError;Microsoft.Crm.Asynchronous.EmailConnector.ErrorSource.Crm:130;T:188\r\nActivityId: [Removed]\r\n>Exception : Microsoft.Crm.Asynchronous.EmailConnector.ExchangeSyncException: Failed to sync item to CRM server : System.ServiceModel.FaultException`1[Microsoft.Xrm.Sdk.OrganizationServiceFault]: There is no active transaction. This error is usually caused by custom plug-ins that ignore errors from service calls and continue processing. at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) +0x27 at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) +0x1ba at Microsoft.Xrm.Sdk.IOrganizationService.Execute(OrganizationRequest request) at Microsoft.Xrm.Sdk.WebServiceClient.WebProxyClient`1.ExecuteAction[TResult](Func`1 action) +0x15 at CrmSDKLib.OrganizationServiceWrapper.<>c__DisplayClass10_0.<Execute>b__0() in C:\\__w\\1\\s\\src\\lib\\CrmSDK\\OrganizationServiceWrapper.cs:line 13..." In Outlook, when I look at these meetings and check the app it gives the message: Recurring appointment occurrence cannot be tracked However, we have other series of recurring meetings that have been successfully tracked that does not run into the issue. Anyone has encountered this or similar issue? How do we resolve this so going forward the app can track all meetings without issue? Please let me know, thank you!
INDEX MATCH with VLOOKUP
This is my first time posting here, as I hit a roadblock that I'm sure is simple enough. I am using the following formula, but the source data ('FY26 Income Statement Data'!$A$4:$A$2158) has several rows with the same criteria on 'Cash Flow'!$A7. I think I need to include a VLOOKUP formula but I don't know how to do this. Any help will be appreciated. =INDEX('FY26 Income Statement Data'!$A$4:$AB$2158,MATCH('Cash Flow'!$A7,'FY26 Income Statement Data'!$A$4:$A$2158,0),MATCH('Cash Flow'!C$1,'FY26 Income Statement Data'!$A$4:$AB$4,0))
VBA Code "Next" button. Should be so simple...
I have the following codes in the click event for a "next" and "prev" buttons on my userform. The prev button works fine, the next button will not advance to the next record in my table, and instead gives me the "Last record" message box (regardless of the active row). If I remove the If...Then loop it works fine. WHY is it looping to the "last record" msgbox when it is clearly not on the last record?? Any ideas greatly appreciated Dim LastFind As Range Dim CurrentRow As Long Private Sub CommandButton6_Click() If CurrentRow < LastRow Then CurrentRow = CurrentRow + 1 LoadRecord CurrentRow Else MsgBox "This is the last record." End If End Sub Private Sub CommandButton7_Click() If CurrentRow > 5 Then CurrentRow = CurrentRow - 1 LoadRecord CurrentRow Else MsgBox "This is the first record." End If End SubAPP Android Excel 365
Hallo und guten Tag, wird möchten mehrere Android Tablets anschaffen um eine auf einem W11 Laptop (mit VBA und Macros) erstellte Excel 365 Anwendung zu nutzen. Hat jemand Erfahrung mit Excel 365 für Android. Insbesondere geht es mir um die herauszubekommen, inwieweit VBA und Macros auf dem Tablet ausführbar sind. Gruß PeterOptimizing 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.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."I can't access Microsoft Feedback Portal: account bug
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."Preparing Your SharePoint Content for Copilot: A Practical Guide
Microsoft Copilot for Microsoft 365 is changing how people search, analyze, and create content at work. Instead of manually digging through folders, users can now ask natural language questions like “Summarize all project risks from last quarter” or “Draft a proposal using our standard templates.” But here’s the reality many organizations are discovering the hard way: Copilot is only as good as the SharePoint content it can access. If your SharePoint environment is cluttered, poorly structured, or over-permissioned, Copilot won’t magically fix it. In fact, it may surface irrelevant information, miss critical documents, or confuse users with inconsistent results. This guide walks through practical, technical steps to prepare your SharePoint content so Copilot delivers accurate, secure, and valuable insights from day one. https://dellenny.com/preparing-your-sharepoint-content-for-copilot-a-practical-guide/PAYG Services Like Purview DSI Can Rack Up Large Charges
Microsoft offers several PAYG services to Microsoft 365 tenants. Data Security Investigations (DSI) is the newest. These services can rack up compute charges to perform processing (in the case of DSI, AI processing of items found in Microsoft 365 sources). If tenants don’t take care, they might end up with big Azure bills. Be aware, prepare, measure, and minimize processing to avoid large charges. https://office365itpros.com/2026/02/04/dsi-costs-compute/
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
