Sorting data on multiple sheets
Hi, I'm using Excel to track data from my team for analysis. I have 5 sheets in my workbook one for each week and a monthly overview. each week totals all data and totals are added to overview using SUM function, however when i sort a column, let's say i sort column a (Name) A-Z, all the data for each person on the monthly report changes. the same happens on the weekly sheets if i change the order of a column everything get mixed up so that each persons stats change. is there a way to stop this from happening? I want to be able to arrange it so that all the data in a row stays the same on each sheetIn Case You Missed It: Frontier Transformation and Wave 3 of Microsoft 365 Copilot Announcements
March brought a major set of Frontier Transformation and wave 3 of Microsoft 365 Copilot announcements across Microsoft 365 Copilot, Copilot Chat, and agents—all focused on helping people move faster from intent to action and helping organizations scale AI responsibly. If you missed any of the updates, here’s a quick recap of what’s new and why it matters. Copilot Transforms Knowledge Work These updates deepen how Copilot shows up inside the flow of work—grounded in your content, context, and tools. Word, Excel, and PowerPoint Agents From Copilot Chat, users can ask Word, Excel, or PowerPoint agents to create content, take next steps, or execute tasks, helping them move from intent to action without copying and pasting or switching contexts. 👉 Learn more Edit with Copilot in Word, Excel, and PowerPoint Copilot now creates, edits, and refines content directly inside Word, Excel, and PowerPoint, grounded in the context of a user’s work through Work IQ, so people can iterate and improve content without leaving the app they’re working in. 👉 Learn more Sequences shortened for demonstration purposes. Copilot Chat in Outlook Copilot Chat in Outlook enables users to draft and refine emails, manage calendars and RSVPs, and use the Outlook email widget to take action directly from chat, streamlining everyday communication and scheduling tasks. 👉 Learn more Outlook customer calendar instructions & proactive RSVPs Copilot finds available meeting times, sends invites, and keeps calendars up to date based on custom instructions, notifying users of changes directly in chat to reduce manual coordination. 👉 Learn more Copilot Cowork Built with Anthropic, Copilot Cowork brings a multimodel approach to Microsoft 365 Copilot—so your work isn’t tied to a single model. Cowork moves Copilot beyond prompts into long‑running, multi‑step work. With full awareness of your work context through Work IQ, it lets you delegate meaningful work and stay informed as it progresses. 👉 Learn more Claude Sonnet available in Copilot Chat Users can select Claude models directly in Copilot Chat, alongside next‑generation OpenAI models, bringing leading models from multiple providers into a single Copilot experience. 👉 Learn more Dataverse in Work IQ Work IQ connects signals from Microsoft 365—including documents, meetings, email, and chat—and will soon access operational data in Dataverse through Copilot in Dynamics 365 and Power Apps, bringing work context and business data closer together. 👉 Learn more Work IQ Memory (Chat History) Work IQ Memory enables more relevant, personalized Copilot responses shaped by a user’s work and Copilot chat history over time. 👉 Learn more Extensibility: Work IQ API / MCP Work IQ APIs provide access to production‑ready AI capabilities that work directly with enterprise work context, enabling extensibility through APIs and MCP. 👉 Learn more Launch Demo Copilot in Dynamics 365 & Power Apps Microsoft 365 Copilot is accessible directly within Dynamics 365 Sales, Customer Service, and Power Apps, extending Copilot experiences into business applications where operational work happens. 👉 Learn more Agents That Help Run the Business These announcements focus on building, deploying, and scaling agents across the enterprise. Apps SDK The Apps SDK provides tools to build ChatGPT apps based on the MCP Apps standard, with additional ChatGPT functionality to support agent and Copilot experiences. 👉 Learn more Model Context Protocol (MCP) Apps MCP Apps turn Copilot from a text interface into a governed, interactive execution layer by surfacing interactive app experiences directly in Copilot Chat. 👉 Learn more Apps in Agents: Outlook, Dynamics 365, and Power Apps Agents can bring Outlook, Dynamics 365, and Power Apps directly into chat, allowing users to review information and take action without leaving the conversation. 👉 Learn more Agent Recommendations in Microsoft 365 Copilot When users prompt Microsoft 365 Copilot, the system analyzes intent and recommends an installed, IT‑approved agent directly in the flow of work, making agents easier to discover and use at scale. 👉 Learn more Evaluate agents in Copilot Studio Copilot Studio provides structured, repeatable testing to help catch issues early, reduce the risk of bad answers, and maintain agent quality as agents evolve. 👉 Learn more Visibility, Governance, and Control at Scale As agent usage grows, these updates help organizations move from experimentation to enterprise readiness. Agent 365 Agent 365 serves as the control plane for agents, helping organizations move from experimentation to enterprise‑scale operations by enabling them to observe, govern, and secure agents. 👉 Learn more Microsoft 365 E7: The Frontier Suite Microsoft 365 E7 unifies Microsoft 365 E5, Microsoft 365 Copilot and Agent 365 into a single solution powered by Work IQ and integrated with the productivity apps and security stack customers already rely on. It includes Microsoft Entra Suite and advanced Defender, Intune and Purview security capabilities, delivering comprehensive protection across agents and employees. 👉 Learn more To explore what’s available now—and what’s coming next—visit the Microsoft 365 roadmap and related announcement blogs. 👉 Explore the roadmap
LABS.GENERATIVEAI() Not working (03/2026)
I am trying to utilize the ai function in a project at work but something isn't working. I have both a user and admin key from OpenAI that both start with the "sk-" syntax. I have 365 Premium (personal not business) When I do a simple function like "=LABS.GENERATIVEAI("Hello World")" it just returns with #N/A! error. I'm using the gpt-5 model for Excel Labs I'm at a loss as to why this isn't working... I have credits in the "vault" of OpenAI and have double checked what seems like every parameter for this to work. I'm also on the beta stream of Excel Labs to access the latest updates and Excel is fully updated, computer has rebooted, and it is still not working. Any ideas or are others having issues with this working too?Use Copilot in Excel to build your brackets
The matchups are finally set, and the annual question is back: how do you pick a bracket that’s fun and gives you a real shot at predicting the winner—whether you’re following the men’s tournament, the women’s tournament, or both? This year, you can use Copilot in Excel as your bracket sidekick—turning past tournament patterns into quick “what-if” scenarios, stress-testing upset paths, and sanity-checking your picks against historic data. Instead of manually building an analysis, copy/pasting data, and building multiple versions, you can ask in natural language and let Copilot build the analysis for you right inside an Excel workbook. Below are a few fast, practical ways to use Copilot in Excel to build a bracket workbook, explore upside picks (hello, Cinderella runs), and model “if this happens, then what?” outcomes so you can fill your bracket with more confidence than the rest of the group. 1) Set up a bracket workbook Open a new workbook, then open Copilot in Excel. Make sure “Edit with Copilot” is turned on. Start by asking Copilot to create a bracket template: “Create a 2026 [men’s or women’s] college basketball bracket including all the latest teams and seeds. Build dropdowns for each round so I can choose the winner of each matchup all the way to a champion, formatted like a standard bracket. For each dropdown, show only the 2 teams in the matchup based on the winners chose in previous rounds using helper columns." With that foundation in place, you’ve got a clean structure for picks and scenario assumptions. From here, you can make your picks and Copilot can help you add calculations, create “what-if” views, and summarize the implications of different upset paths. Bonus: Want to theme your brackets around your favorite team? First have Copilot generate a simple skills sheet and ask it to follow the instructions when creating brackets. “Create a skills sheet for my favorite team, [Team]. Include the official team colors (with hex codes), mascot/nickname, text colors, and conditional formatting rules for winners/losers.” 2) Stress-test your bracket with real-world scenarios Now for the part that can actually give you an edge: use Copilot to spin up scenario tabs and see how your bracket performs under outcomes that happen all the time in March—Cinderella runs, unexpected seed collapses, and “hot team” momentum that goes against conventional logic. Try some follow-up Copilot prompts like: Cinderella path: “Pick a 10–13 seed to reach the Sweet 16 based on past tournament frequency. Create a version to reflect that upset path, and show which higher-seeded teams I’m fading.” All the 1-seeds don’t make it: “Create a version of my bracket where at least two 1-seeds lose before the Elite Eight. Identify the earliest-round upsets needed and how my champion pick changes.” Favorite team: “Assume my favorite team is [Team]. Build two paths: (1) optimistic (reach the Final Four) and (2) realistic (based on projected path). For each path, show who they’d likely face by seed line and which matchup round matters most for them.” Momentum model: “Calculate a “momentum multiplier” using the conference tournament games and recent performance for each team and use that to fill out a version of my bracket weighted by momentum.” 3) Compare bracket variants and choose your entry Once you’ve built a few scenario versions, Copilot can help you compare them—so you’re not guessing which bracket is better, you’re choosing the one whose risk/reward matches your needs. Use a prompt like: “Create a comparison analysis for all my bracket scenarios in this workbook including charts. Include number of upset picks by round, and my top 5 most ‘contrarian’ picks across all my brackets. Give a recommendation for which to submit if I’m trying to win my bracket challenge or simply play it safe.” Copilot can generate the comparison table, highlight the key differences, and summarize the tradeoffs in plain language—so you can decide whether you want a safer entry, a balanced upset strategy, or a bold bracket designed to win big. Your turn: build your bracket with Copilot Ready to try it? Open Excel, start a new workbook, and use Edit with Copilot to create your brackets. Once you’ve got a bracket you like, share it with your league, your family, or your coworkers.Sheet View Issues with Excel Web Browser
Hi, I have created a Excel document for my department to use, I tried Excel App but due to the size of the Spreadsheet it kept freezing, as a result I switched it to use Excel through Web Browser. The sheet no longer freezes which is good. I do have another issue though.....I wanted multiple users to be able to access, edit the sheet at the same time so I did some research and Sheet View seemed to be the way forward. I created a Sheet view for each employee to use so when you go to View, Sheet View and click on the relevant person their work is updated, saved etc and this shouldn't affect others view. This is working in terms of people editing. The main issue now though is that despite following advice sometimes when someone changes a filter on their own sheet view it seems to change others view. My understanding was you can hide, filter etc within your own Sheet view but this doesn't seem to be the case.......PLEASE HELP!!!! My excel and computer Skills aren't excellent to please any simple advise would be great.
Allow removal of "Copilot Suggestions" from right-click menu
I have been using Excel for decades and CONSTANTLY use the right-click menu for quick access to basic functions (e.g., "Insert"). Ever since "Copilot Suggestions" was added to the drop-down list, it always throws me off due to its placement. I have Microsoft 365 on Windows 11 Pro. I have searched for ways to remove this from appearing there and the result said "go to File > Options > Copilot and uncheck the 'Enable Copilot' box". However, when I attempt to do that, there is NO "Copilot" option available! PLEASE allow removal of "Copilot Suggestions" from the right-click menu OR at least the option to move it to the bottom (so it isn't in the way of things used ALL the time). I realize that Copilot is a great resource for many users, but I am confident in my Excel skills and in my ability to research/learn new skills the "old school" way, so I have little use for this feature now and would prefer to hide it.
