Recent Discussions
APP 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ß Peter
How to unlink cells in Format Control
I am developing a survey in excel (because the questions are complicated and long and do not format well in e.g. MS Forms) and using option buttons to choose responses. Each question has 6 potential responses. In developer I have inserted a group box, into which I placed 6 option buttons. After formatting the buttons so that they snap to the excel grid I then linked them to a cell to make calculating responses easier. On-line advice then suggested that I could copy and paste these to each new question. However, by doing this, I am only able to choose 1 option as they are ALL linked to the same cell. How do I unlink each group box of 6 option buttons so that I can link each group individually to a different cell for each question? Or - do I have to create a group box and option boxes from scratch for each question set? I have removed the questions for simplicity of view (note that there are 6 in Q1 and Q2 not visible) and highlighted the linked cell from Q1. As you can see - for Q5 this has given an answer of 26 (the 26th option button) rather than 2 (the 2nd button in Q5)
Excel XIRR fails in Desktop & Online — ATP not binding, cloud profile corruption
I need help from the Excel engineering team. My Microsoft 365 account appears to have a corrupted Analysis ToolPak (ATP) function binding for XIRR at the cloud profile level. Symptoms: - =XIRR({-100,110},{1,2}) returns a long fallback constant instead of 0.1 - GET.CELL reports XIRR as invalid - Excel Online produces the same incorrect fallback value - Desktop Excel produces the same incorrect fallback value - A brand-new Windows user profile produces the same result - A full uninstall/reinstall does not fix it - ATP is enabled and ANALYS32.XLL is present - No Name Manager overrides, no LAMBDA overrides, no VBA, no add-ins - Dates are valid Excel serial numbers - All local Office registry keys, Feature Store, and activation tokens were wiped and rebuilt - Excel is fully activated and licensed - The issue persists across all environments Because Excel Online returns the same fallback constant, this is clearly not a local machine issue. It appears to be a cloud-side Excel profile corruption, specifically the ATP function registry for my Microsoft 365 account. Request: Please escalate this to the Excel service engineering team to reset/rebuild my Excel Online profile and ATP function map for my account. Thank you. Bob
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 G7Word- insert picture from device not working
I have inserted pictures without problem for years. Now ‘insert picture from this device’ produces nothing. There are no error messages. I can copy and paste the same picture into the document no problem. Also it will insert pictures from the internet. I have followed many suggestions without result. I have repaired the prog and also reinstalled it.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.Using 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
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
