BYROW/BYCOL/MAP Variants for Nested Arrays + BENCHMARK
Hey everyone! I made some simple BYROW, BYCOL, and MAP variants that can return nested arrays, and I also made a BENCHMARK function for performance testing. Here's some code for testing: BYROW⊟ = LAMBDA(array, function, [orient], LET( me, LAMBDA(me, seg, LET( n, ROWS(seg), IF( n = 1, function(seg), IF( orient, HSTACK( me(me, TAKE(seg, INT(n / 2))), me(me, DROP(seg, INT(n / 2))) ), VSTACK( me(me, TAKE(seg, INT(n / 2))), me(me, DROP(seg, INT(n / 2))) ) ) ) ) ), IFNA(me(me, array), "") ) ); I didn’t put a huge amount of effort into polishing this but In my tests on my device, these performed a lot better than using REDUCE + VSTACK for the same kind of thing, so maybe it’ll be useful to someone. Really curious to see how people use it, and if something looks like it should be optimized or changed, say so. I'll update them regularly, fix bugs whenever I can. You can find the rest of them on my Gist pages: https://gist.github.com/Medohh2120/f565516bc636700adf5ba27fd8f0d19e, https://gist.github.com/Medohh2120/d9d04f56d93694aed9d0c49d516f0fbf.
Conditional formatting cannot be displayed when pasting using the camera method.
When I paste the table into a different area (using the camera method), the formatting for some cells is not properly displayed. These cells have “Conditional Formatting” applied, and their colors change based on their content. When I make changes to the original table, I can see that there is no issue and the colors update correctly. This problem also occurred when I used the table as a “linked image.” Visual Explanation; (The original table is on the left; on the right is the same table pasted using the camera method. Both are in the same file and tab.) When I copy and paste the hidden rows separately (using the camera method again), the conditional formatting appears. In other words, there is no specific issue with the rows where the “formatting styles” cannot be displayed properly: Unfortunately, I didn’t get any results when I tried the “shake” method. When I tried it on a new worksheet, the result remained the same. I also tried the “Repair Office” option, but the problem persists. Could there be a row height limit when copying this type of table using the “camera tool” (when capturing screenshots of conditional formatting) When the total row height in the tables exceeds a certain value, the “conditional formatting” properties of the table I move to another location using the “camera tool” do not display. When I copy 26 rows to another location with each row set to 32.75 units in height, all properties are displayed; however, when I change it to 33 units in height, the formatting starts to break. And this total value (26 × 32.75 = 851) isn’t consistent either. When I try to set individual height values for the cells to reach a total height of 851, the issue isn’t resolved. Sometimes I get proper display when the total height is 777, and sometimes when it’s 661. What do you think is the root cause of this problem I’m facing? How can I solve it? Office Version Information: Ref: https://learn.microsoft.com/tr-tr/answers/questions/5861040/excelde-tabloyu-ba-l-resim-olarak-yap-t-ramama-sor
Embedded Excel sheet in Word Doc not showing all rows
I have a Word Doc with an embedded Excel sheet. After I add rows to the sheet, the Word Doc cuts off the new rows. I tried stretching it in the Word Doc, but that doesn't work, the Excel sheet just gets stretched. I've changed the print area and cleared the print area in the Excel file. I unhid all the rows as well. I've searched Google and here and I couldn't find an answer. Is the Word Doc or Excel sheet I'm working on corrupted? I've attached some screenshots.
Alternative to Pivot Table in Dashboard for better UI Experience
Hi, currently I am using Excel to build a dashboard for asset management, in particular it is used to track how many items remain after someone borrow it for a particular date range. The data comes from MS Form and has been populated into Excel. I have cleaned up and transform the original data using Power Query and the final form of my data to build the dashboard look something like this. I wish the dashboard to be able to show the following part bracket in red, which represent the details of items being borrowed. Currently I am using pivot table as my solution, as you can observe above. Is there any idea or solution to enhance the overall look of the dashboard? Basically, what I want is instead of directly on the Excel grid, can this be turned into draggable table pane?Importing CSV file properly
Hey, I'm having issues importing a CSV file properly. There are three columns of data, two columns as dates and one as a measurement. I have done all the steps to import the CSV data. I've saved the data as a CSV file, then gone to Data > From Text/CSV > Chosen the CSV file > Put the delimiter as "comma" as the data is separated by commas, and it all still appears in one column. So then, I tried a different way. I tried Highlighting the data > Text to columns > Put the delimiter as "comma." Now, this worked to put the data in to columns, but then I needed to change the date format. The data originally displays the dates as YYYYMMDD, with no forward slashes or points between the dates. I tried to change the date via the "Number" function in the "Home" tab, but it won't change the dates and they all appear as hashtags. I tried to get help from a Uni adviser, but they were unable to give me a solution. I'm really stuck now as I have looked on forums, microsoft pages, YT videos, everything. I have the most recent version of Excel, have checked my settings, everything. I would really appreciate any help.
Excel App Builder: Should Excel Support Turning Workbooks into Standalone Low-Code Applications?
Excel has been much more than a spreadsheet application for a long time. In many organizations, Excel is already used as an informal low-code development platform. Advanced workbooks often contain not only data and formulas, but complete domain-specific logic: calculation models, planning tools, dashboards, input forms, reports, simulations, administrative workflows, and sometimes even small internal business applications. This is one of Excel’s greatest strengths. It allows domain experts, power users, analysts, engineers, teachers, consultants, and small businesses to build working tools without becoming full-time software developers. However, there is a structural limitation: the final product usually remains an Excel workbook. That creates several problems: the user needs a compatible Excel installation, macro security and Trust Center settings can block functionality, formulas and business logic are difficult to protect properly, distribution and updates are not as clean as with real applications, workbook-based tools often look less professional than standalone software, user interface, data, and logic are often mixed together in the same file. I believe Microsoft could turn this existing reality into a major strategic opportunity. Core proposal: Excel App Builder / Excel Runtime My suggestion is an official Excel App Builder or Excel Runtime. The idea would be to allow selected Excel workbooks to be packaged as protected standalone applications. Excel would continue to serve as the calculation, data, and automation engine in the background. The end user would not necessarily see the workbook itself. Instead, they would interact with a clean application interface: input forms, buttons, dashboards, charts, reports, controlled tables, and export options. Possible output formats could include: Windows apps, web apps, Teams apps, SharePoint apps, mobile-friendly internal tools, protected specialist applications. This would not replace Power Apps. In my view, it could complement Power Apps very well. Excel could remain the place where fast domain logic, calculations, prototypes, and models are created. Power Apps, Dataverse, Azure, and the wider Microsoft ecosystem could then support larger, scalable, enterprise-level workflows. In other words: Excel could become the natural entry point into Microsoft’s low-code ecosystem. Why this could matter strategically Excel already has an enormous “hidden developer base”: people who are not traditional programmers, but who build useful tools with formulas, tables, Power Query, Power Pivot, VBA, Office Scripts, and now AI assistance. This is a unique market position. Many of these users would not start with C#, JavaScript, Python, or a full application framework. But they already start with Excel. They already build the logic there. The missing step is a professional way to package, protect, distribute, and update those solutions. An official App Builder could: strengthen Excel’s long-term relevance, differentiate Excel from simpler spreadsheet competitors, create a stronger bridge between Excel and Power Platform, give power users a professional deployment path, create new commercial licensing opportunities, reduce the need for fragile VBA/UI workarounds, make Excel-based tools more secure and maintainable. Example use cases A small engineering office creates a technical calculation workbook and exports it as a protected customer tool. A school or university builds a grading, diagnostic, or planning tool with Excel logic but provides staff with a clean app interface. A small business turns an Excel-based quotation calculator into an internal sales app. A finance department packages a planning model as a controlled scenario tool for managers. A consultant builds specialized calculation tools and distributes them professionally without exposing the workbook structure. These are not exotic scenarios. Many people already build this kind of logic in Excel today. The difference would be that Microsoft could provide an official, safe, and professional deployment path. Supporting features that would make this stronger 1. Modern UI layer for Excel-based apps Excel-based applications would need a modern interface layer: forms, dialogs, navigation pages, buttons, card layouts, dashboards, responsive views, mobile-friendly layouts, role-based views, binding to cells, tables, named ranges, and data models. This would create a clearer separation between data, logic, and user interface. 2. Protected workbook logic A professional app export would require strong protection options: hidden formulas, protected named ranges, protected scripts or macro logic, defined input areas, digital signing, controlled editing, update mechanisms, possible licensing controls for commercial distribution. 3. Formula cells with controlled manual override One frequent Excel problem is that users overwrite formulas. A useful new cell mode could be: default formula + optional manual override The cell would keep the original formula internally but allow a controlled manual exception value. Excel could show whether the formula is active or manually overridden. This would remove many helper-column and VBA workarounds in planning, pricing, grading, budgeting, and technical models. 4. Native database layer inside Excel Excel is widely used as a database, even when that becomes fragile. A native database layer could support: primary keys, relationships between tables, required fields, validation rules, change history, duplicate detection, form views, simple queries, optional cloud synchronization. This should feel like a natural extension of Excel tables, not like a separate database product. 5. Multidimensional workbook models Many workbooks use separate sheets for months, locations, versions, departments, or scenarios. This often creates duplication and maintenance problems. Excel could support native dimensions for tables and models, for example: time period, location, scenario, version, department. Formulas, charts, dashboards, and PivotTables could become dimension-aware. This would be especially useful for financial planning, controlling, simulations, scientific models, and project planning. Why now? AI is changing how people build with Excel. Copilot and other AI tools make it easier for non-programmers to generate formulas, scripts, models, and structured workflows. That means more users will be able to build complex Excel-based solutions. But if AI helps users create more advanced workbooks, the next logical question is: How can these workbooks be safely packaged, shared, protected, and used as real tools? An Excel App Builder could be the answer. Possible first step This does not need to start as a massive platform. A realistic first version could be experimental: selected workbook ranges, simple input forms, protected formulas, dashboard view, Windows or web runtime, export as an internal app, optional Teams or SharePoint integration. It could even begin as an Excel Labs / Microsoft Garage style experiment to test demand and gather feedback from power users, developers, and organizations. Core question for the community Excel is already used as a hidden development platform. Should Microsoft make this official? Would an Excel App Builder / Excel Runtime be useful for your organization, clients, or internal tools? Which feature would matter most in a first version? protected workbook runtime, modern UI layer, formula override cells, native database layer, multidimensional models, Power Platform integration, commercial app distribution? I would be very interested to hear how other Excel users, developers, MVPs, and Microsoft product people see this idea. In short: Excel already allows millions of people to build domain-specific logic. Microsoft could turn that strength into an official, secure, and economically attractive low-code application platform.
PivotTable Date Slicer Not Visible in Excel for the Web (Works in Desktop)
Hi everyone, I'm experiencing an issue with Excel for the web and was hoping to get some help. I have an Excel workbook that is linked to a 'Microsoft Forms' form. The form responses automatically populate the main sheet, and from that data I've created several PivotTables. In one of the PivotTables, I added a date slicer to filter the data. Everything was working fine at first, but recently the slicer is no longer visible in Excel for the web. However, when I open the same workbook in Excel Desktop, the slicer is visible and it works as expected. What I have tried so far: Recreating the PivotTable and adding a new slicer Creating a completely new PivotTable and slicer Checked if the slicer is hidden by adjusting the zoom Unfortunately, the issue persists in Excel for the web. Has anyone experienced this before and found a workaround? Any help would be appreciated. Thanks in advance.
Calculating and adding time
I am trying to figure out how to automatically calculate time differences for a delayed racing start time. I have: a rating which provides a handicap correction factor: PHRF Tod A Sec/ Mile correction number A Total correction in Seconds (based on a distance) This I figured out. I have a set start time for the first entry at 11:00:00 I need to figure out the Start time for the delayed boats as shown in the diagram, but I don't know what formulas will do this. This diagram is taken from a pdf document.From access to adoption: Unlock the power of Microsoft 365
Change is the only constant, but adapting to change isn't always easy. If we consider the celestial speed at which technology is evolving, keeping up with every trending tool can be daunting. An ecosystem like Microsoft 365 designed to simplify work by bringing many tools into one connected workspace can also feel overwhelming. That is why you are invited to join us at the Microsoft 365 Community Conference, where you can connect with Microsoft leaders, product experts, and peers to drive adoption forward and deliver business results. Rolling out Microsoft 365 is only the beginning. Real success happens when people understand the value, adopt new ways of working, and feel confident using the tools every day. That’s why Adoption and Change Management sessions are a cornerstone of the Microsoft 365 Community Conference. These sessions focus on the human side of transformation—helping organizations move from deployment to sustained impact through practical strategies, real-world lessons, and community tested approaches. Whether you’re leading adoption for Microsoft 365 Copilot, driving collaboration change with Teams and SharePoint, or building Champions across your organization, these sessions are designed to meet you where you are. We know from our research that organizations who have a strong Champions program and invest in peer learning have accelerated business results. At the Microsoft 365 Community Conference, adoption sessions go beyond theory. They’re built around: What actually works in the real world Lessons learned from failed or stalled rollouts How to scale change across large, distributed organizations How community-led approaches drive long-term success You’ll hear directly from practitioners, Microsoft experts, and community leaders who have led adoption efforts inside enterprises, public sector organizations, and fast-moving teams. Check out these can't miss adoption and change management sessions Adoption power skills – Building a Champion Program with Karuana Gatimu, Director, Customer Advocacy - AI & Collaboration and Tiffany Lee, Customer Experience Product Manager, Microsoft Collaboration 2026 – The next generation of Teams experiences with Nicole Enders, Microsoft 365 MVP, Managing Consultant - Microsoft Solutions, CONET Solutions GmbH Community in the age of AI – Humans at the center of Copilot adoption with Allison Michels, Sr. Program Manager, Viva Engage, Microsoft, Sarah Lundy, Sr. Customer Experience Program Manager, Viva Engage, Microsoft, and Alex Snyder, Product Manager, Copilot Adoption, Footlocker Demystifying Copilot and AI experiences on Windows with Anupam Pattnaik, Microsoft How Microsoft does IT: Driving adoption of M365 Copilot and agents across Microsoft with Cadie Kneip, Senior Business Program Director and Copilot Champ Community Lead, Microsoft and Stephan Kerametlian, Senior Director, Microsoft Digital, Microsoft From pilot to copilot: Building a scalable AI adoption framework with Tiffany Songvilay, AI Workforce Lead, Avanade Leading workforce transformation: The art and science of skilling your people with Karuana Gatimu, Director, Customer Advocacy - AI & Collaboration and Jessie Hwang, Customer Experience PM, Microsoft 365 Customer Advocacy Group, AI & Collaboration, Microsoft OneDrive, SharePoint, Viva Engage, and Teams… Oh my! Understanding the many collaboration solutions with David Drever, Microsoft 365 MVP - Compliance, Data Protection, and M365 Specialist, Protiviti Start your adoption journey with adoption.microsoft.com with Jessie Hwang, Customer Experience PM, Microsoft 365 Customer Advocacy Group, AI & Collaboration, Microsoft Tools and best practices for accelerating Copilot & agent adoption with Jojo Wright, AI Business Solutions Architect, Microsoft and Karuana Gatimu, Director, Customer Advocacy - AI & Collaboration Be sure to check the Whova app for other meetups and experiences around Adoption and Microsoft 365 Champions. Master the art of adoption at the Microsoft 365 Community Conference Boost your adoption strategy by joining subject matter experts in Orlando, FL, for the Microsoft 365 Community Conference on April 21–23, 2026. Discover how Microsoft is shaping the future of work by empowering teams to achieve more than ever. When the world is moving quickly, with the right technology, we want you to lead the way!AI is a Team Sport – Announcing our first wave of Guest Speakers at M365 Community Conference 2026
What do championship athletes, enterprise innovators, and community leaders all have in common? They know that transformation does not happen in isolation. It happens when teams come together with a shared goal, the right strategy, and the courage to try something new. That is why at the Microsoft 365 Community Conference in Orlando, Florida from April 21 to 23, 2026, we are bringing the spirit of collaboration to life in a whole new way by welcoming a dynamic lineup of guest voices from the worlds of professional sports, innovation strategy, and real-world AI adoption at scale. This year, we are proud to host legendary athletes Chasity Melvin and Kia Vaughn, alongside innovation thought leaders Dan Toma, Manjunatha Sivanna, Christopher Blakeley and Jon Wear as they join Microsoft leaders on stage to explore how teamwork, leadership, experimentation, and trust are shaping the future of AI powered organizations. Chasity Melvin is a former WNBA All-Star and coach, with over two decades of experience in professional basketball. As a first-round draft pick, she played 12 seasons in the WNBA and spent over a decade winning championships internationally. She is a multifaceted coach with experience at the collegiate and professional levels including a stint with Charlotte Hornets as the first female coach to coach men. Her accolades include being an author, motivational speaker, and co-host of the Washington Mystics pre- and postgame show, where she shares her informed perspective as both a player and a coach. She is passionate about the business of sports and technology and is intentional about lending her voice in conversations that drive impact and inspire change. At the conference, she will join Corporate Vice President and Chief Scientist Jaime Teevan in a fireside chat to share insights on AI and its collaborative future in changing roles, leadership, and transformation. This fireside chat will be hosted by the Director of Customer Advocacy for AI & Collaboration, Karuana Gatimu. Kia Vaughn is an international champion known across WNBA in the United States and worldwide. Immersed in basketball from an early age, she honed her craft at Rutgers, delivering standout performances on the championship stage. Throughout her 14-year career on several WNBA teams, including the New York Liberty, Washington Mystics, Phoenix Mercury, and Atlanta Dream, she developed a reputation as a consummate professional. Known for her preparation and reliability, she is geared up to bring an impact-driven global perspective to our Women in Technology Lunch in a conversation with Karuana Gatimu, Director of Customer Advocacy for AI & Collaboration. Don’t miss her insights as she navigates the challenges of an ever-changing league. Dan Toma is the CEO and Partner at Outcomes Consulting, where he helps global organizations in enhancing their approach to technology. He is an acclaimed author with a key focus on leadership, technology strategy, and delivering business outcomes. As co-author of the recent text, “Innovation Accounting”, he offers practical, detailed, and focused guidance on fostering a culture of experimentation and innovation, essential for organizations adopting generative AI. We’re excited to have him join the Director of Customer Advocacy for AI & Collaboration, Karuana Gatimu, in a fireside chat on real world adoption best practices at scale. And because AI is only as powerful as the impact it drives in the real world, we are also excited to spotlight customer voices leading enterprise transformation today. Real world customer stories Across our product keynotes, Microsoft customers will bring AI transformation to life by sharing how they are moving from experimentation to impact inside their own organizations. These global brands offer a real-world look at how teams are adopting AI, modernizing operations, and building for the future with greater confidence, creativity, and scale. Their stories ground our keynotes in practical insight and show what it really takes to turn innovation into meaningful business outcomes. Featured in our day one keynote Building for the Future: Microsoft 365, Agents and AI, What's New and What's Next with Jeff Teper, Executive Vice President, Collaborative Apps and Platforms: Jon Wear, Director of Transformation and Innovation at British Airways, is focused on the airline’s largest‑ever transformation program, an investment of over £7BN, the biggest in BA’s history. This program is modernizing the airline for long‑term growth and is already delivering measurable results, including improved on‑time and financial performance as well as higher customer satisfaction (NPS). As part of this agenda, Jon is co‑leading British Airways’ AI transformation. This has included successfully rolling out Microsoft Copilot to 40,000 employees, deploying AI agents to automate key processes, and building the organizational capabilities required to scale AI responsibly and deliver real‑world impact. Jon has nearly 20 years of professional experience across leadership, strategy, and large‑scale transformation, including service as a military officer as well as senior roles in industry and McKinsey & Company. Featured in our day one keynote Business Apps & Agents with Ryan Cunningham, Corporate Vice President: Christopher Blakeley, Principal Program Manager and AI & Agentic Automation Enablement at NASA. In this role, Chris leads the Agency’s Intelligent Automation strategy and drives the expansion of NASA’s Microsoft Power Platform ecosystem that supports more than 50,000 employees across all Centers. He oversees secure and scalable platform adoption, enabling mission and administrative teams to rapidly build automation solutions that streamline operations and advance NASA’s digital transformation goals. brings a unique perspective on applying advanced technologies in mission critical environments. Chris leads the Federal wide Power Platform Focus Group, collaborating with government agencies to coordinate best practices, governance approaches, and enterprise adoption strategies. With more than 20 years of service at NASA, including roles at Johnson Space Center, Kennedy Space Center, and Marshall Space Flight Center, Chris contributes to government‑wide modernization by championing responsible automation and empowering the federal workforce with ai-enabled digital tools. In our day two keynote Securing AI: Building Trust in the Era of AI with Vasu Jakkal, Corporate Vice President, Microsoft Security will be joined by: Manjunatha Sivanna, Principal Platform Manager at Cummins Inc., will provide a look into how enterprise organizations are integrating AI into core business functions to improve decision making, streamline workflows, and empower teams to innovate faster in a rapidly changing technology landscape. In his current role, he is responsible for enterprise-wide adoption of Microsoft 365 Copilot and Enterprise AI, establishing information governance and compliance foundations using Microsoft Purview, and enabling low-code innovation through the Power Platform. He works closely with legal, compliance, security, and business teams to ensure AI is deployed in a way that is secure, compliant, and pragmatically useful for employees. He has been a key driver behind large-scale Copilot rollouts, enterprise AI governance models, and ECM modernization initiatives, helping organizations move from experimentation to real-world, production-ready AI outcomes. He is passionate about bridging the gap between technology capability and business value, and about shaping practical patterns for Responsible and Agentic AI in the enterprise. Together, these voices reflect the very best of our community: diverse perspectives, shared challenges, and a willingness to learn from one another as we shape what comes next. Because in the era of AI, progress is not built alone. It is built together, with trust, curiosity, and teamwork at the center. Because when it comes to AI, success is a team sport.
