Excel Nested Arrays: Find the Nesting Depth of Uniform and Ragged Arrays ARRDEPTH() & ISRAGGED()
Hey everyone! I’ve been diving deep into Excel’s new nested arrays features lately, and I absolutely love the flexibility they bring to data structuring. However, managing them can get a bit tricky, so I figured I’d build some specialized tools to handle them seamlessly. Public Interfaces & Arguments =ISRAGGED(array) Argument Description Default Behavior array Target nested structure to validate. Required =ARRDEPTH(array, [is_ragged]) Argument Description Default Behavior array Target nested structure to measure. Required [is_ragged] TRUE: Scans all branches for the deepest path. FALSE: Speed test on the first path only. FALSE (Omitted) TL;DR (What makes it tick): Function Name Type What It Does ARRDEPTH Public UI Returns nesting depth. Supports deep checking or fast linear testing. ISRAGGED Public UI Structural validator. Returns TRUE if array branches have uneven nesting. ANALYZE_NESTING Hidden Core Engine Multi-process recursive parser that tracks tree structure geometries. LINEARDEPTH Hidden Utility High-speed depth checker that evaluates the first element path exclusively. You can get both functions from my GitHub Gist: https://gist.github.com/Medohh2120/9cdf939036942c9672c57ccd6de696d3
Power BI and Fabric team ownership in extended engineering models
When an internal BI team already owns Power BI and additional engineers support Fabric development, how do you divide responsibilities? For example, should the extended team own data pipelines and notebooks while the internal team owns semantic models and reports, or is it cleaner to assign ownership by project? We have encountered this at Datatobiz when implementation work moves into ongoing development and support. Thoughts?
Is using Planner for tracking OKRs a good idea?
So our team has been trying to use Planner to track OKRs. We set up buckets for each objective and tasks for key results. It kinda works for a small team but now that leadership wants to roll it out company wide, its getting messy. Theres no way to show progress rollups from team-level OKRs to company-level ones, no percentage tracking on key results, and managers cant see a consolidated view across teams. Has anyone found a decent way to make Planner work for OKR tracking at scale?Excel - single window, more files
How difficult it is to convince Microsoft team to fix major problems? I've recently switched to new Excel and I'm ...amazed. We used to be able to open multiple files, sheets in the same window. Opening multiple windows was possible as well. Now everything, even the same sheet is in new window. Every new window has it's own tool ribbon. Which is taking space. Ribbons do not synchronize - also slowing down the work. I get that there is and idea behind it. Probably more stable, easier to code or something entirely different that I do not know. But this is so annoying to work with. Is it possible to convince Microsoft that they should find a solution to problem they created?Ability to send an email to Planner and create a Task
Is this on the roadmap? Our organization is starting to lose the battle of using Planner instead of Trello, pretty much because of the sole feature that Trello allows you to send an email to a specific email address and it will automatically create a Task. It is quite a simple model: Email Subject = Task Title Email Body = Task Description Email Attachments = Task Attachments This would be a massive win for adoption. Looks like this is the entry with the most votes, but there are about 100 of them that individually are asking for the same/similar functionality: https://planner.uservoice.com/forums/330525-microsoft-planner-feedback-forum/suggestions/13076007-ability-to-add-email-as-planner-task
I designed an OS-tan mascot for Microsoft PC Manager! (PC Manager-tan)
Hello! I’m a huge fan of Windows 11 and a daily user of Microsoft PC Manager. Since the app is so incredibly light and useful, I thought it would be fun to give it a face. So, I designed an "OS-tan" style mascot character for it: "PC Manager-tan"! I wanted to share my concept art and ideas with the community. Here are some of her design details: [Design Inspiration & Colors]--------------------------------------------------------------------------------------------------------------- Signature Colors: The green and blue color scheme is heavily inspired by the official Microsoft PC Manager logo. Hair Details: She has a blue 'ahoge' (cowlick) and a blue heart hairpin to represent the distinct dots in the app's logo. Outfit: A Full-Body Style energetic cleaning assistant wearing a cozy cable-knit sweater, a green plaid skirt, and round glasses. Slogan: "We'll clean up your PC for you" [Her Equipment & Skills]-------------------------------------------------------------------------------------------------------------------- Digital Broom (Boost): Her main tool. With one click, she aggressively sweeps away unnecessary RAM usage and temporary files. Sandbox Claw Glove (Security): A mechanical claw she uses to safely catch malware and inspect system health. AI Utility Bag: A handy bag filled with all the convenient AI tools she needs to assist the user. I had a lot of fun making this, and I hope you guys like her! What do you think? It would be amazing if the MS dev team actually saw this! 😂How we’re using Microsoft 365 to reduce merchant QBR prep from hours to minutes
Hi Champions, I wanted to share a practical adoption pattern we have been working on for account teams that prepare recurring customer or merchant business reviews. One workflow we kept seeing was quarterly business review prep: an account manager starts with a CSV or TSV export, then manually rebuilds similar scorecards, summaries, PowerPoint slides, and follow-up notes for many accounts. It is important work, but a lot of the prep is repetitive. We built https://marketplace.microsoft.com/en-us/product/WA200010195as a Microsoft 365 agent to explore how much of that workflow can stay inside the tools business users already use. The current workflow is: - Start from a merchant performance export in CSV or TSV format, either from OneDrive or pasted directly in chat. - Generate executive QBR scorecards for one merchant or multiple merchant accounts in a batch. - Include payments-oriented metrics such as transaction volume, authorization rate, top decline reason, chargeback rate, interchange downgrade, and loyalty spend lift. - Create a PowerPoint scorecard for each account. - Organize the run in OneDrive with an index, per-account status, and an optional ZIP bundle. - Draft a follow-up email that the user can review and send from Outlook. The adoption lesson for us has been that Copilot and agents land best when the workflow is narrow, familiar, and already painful. “Prepare this quarter’s account reviews from the export I already have” is much easier for business users to understand than a broad AI promise. I would be interested to hear how other Champions are approaching similar recurring review workflows. Are your teams using Microsoft 365 Copilot or agents for business-review prep, customer success workflows, sales/account planning, or operational reporting? For anyone curious, the app is listed on Microsoft Marketplace here: https://marketplace.microsoft.com/en-us/product/WA200010195.Copilot Chat Adoption Feedback : Model Selection Governance and Prompt Library Reusability ?
Hello, As part of several Microsoft Copilot adoption projects that I am currently leading across different organizations, two questions frequently come up from both users and administrators. The first concerns the ability to lock or enforce a specific model in Copilot Chat for certain use cases. Several customers would like to guide users toward a particular model when working on specific scenarios (Opus for example) that require a certain level of reasoning, behavior, or response quality. To date, I have not found any official documentation or roadmap information indicating whether this capability is planned. The second concerns the Prompt Gallery / Prompt Library. Saved prompts are very useful for starting a conversation, but they do not appear to be reusable directly within an ongoing conversation. In several business scenarios, users would like to chain multiple approved prompts within the same conversation in order to preserve context while applying different working methods, analysis steps, or processes. Are there any planned developments regarding these two topics? The ability to lock or enforce a specific model in Copilot Chat. The ability to use prompts from the Prompt Gallery / Prompt Library during an already active conversation. I have not found any official information on these topics in Microsoft Learn documentation or in the Microsoft 365 roadmap. However, these capabilities seem likely to facilitate user adoption and help standardize usage patterns across organizations.GLSU Excel add-in fails to load after Office update from Version 2607 to 2608
Our Excel add-in, Process Runner GLSU , fails to load after Microsoft Office updates from Version 2607 to Version 2608. This started August 17, 2026 and is actively growing in scope. Error messages: Excel: Cannot run the macro 'onLoad' VBA: System Error &H80004005 (-2147467259). Unspecified error VBA: Compile error in hidden module: ThisWorkbook Has anyone encountered similar issue with their own custom add-on. If yes, any pointers to fix it. We are seeking help on priority. Thanks, Vrushali Pawale, Sr. Manager, Insightsoftware.
