copilot in excel
187 TopicsAgent Mode in Copilot for Excel
Will someone please help me on this. I had access to Agent Mode in Excel, through the frontier add-in for Excel Labs and now I can no longer access it on desktop app or web. I have a 365 personal plan and it includes Copilot. Not sure if it matters, I have Copilot and Microsoft 365 Copilot apps installed. Everything I have found online doesn't work. The Excel Labs shows Agent Mode is no longer available through the Frontier add-in. It is not showing in Tools from the Copilot Chat either. I updated the app, opted in for Beta Testing and nothing. If giving any steps to try please list each step. Please help. ThanksSolved121Views0likes2CommentsAllow 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.310Views5likes3CommentsCopilot, Excel and photos
We have a number of networking devices, all the same type, that we are deploying within an office. To speed up asset management, engineers are putting a label on the back under the MAC and serial numbers then taking a photo so it can be documented later by admin staff. Through Excel I've tried with a single photo and multiple photos to extract the MAC details successfully and put them in to cells at the same time. However, this doesn't tell us which device it is as it doesn't process the photos in any order. Therefore my next step is to be able to capture the label info we have put on and tie this info together with the serial number each time so its all from the same equipment. Is it possible to do this either one photo at a time or across multiple photos? TIA34Views0likes0CommentsApp Skills is evolving with Copilot in Excel
We are continuing to streamline the ways people engage with Copilot in Excel, and we've heard your feedback that working across multiple Copilot entry points can feel fragmented. To address this, Copilot in Excel is transitioning toward a more unified experience so users can easily choose between conversational assistance and direct editing capabilities. As part of this effort, the editing capabilities that App Skills provided will be integrated into Copilot Chat and Agent Mode in Excel, which became generally available earlier this year. This update is part of our broader work to simplify the Copilot entry points and make it clearer how to interact with Copilot depending on the task. We know that when you find a workflow that works, change can feel disruptive. That's why we want to give you a clear picture of what's evolving in how you use Copilot in Excel and how these changes provide an even better experience. Why this change matters We've heard your feedback about wanting a more capable experience when working with Copilot inside the spreadsheet. The enhanced editing experience that Agent Mode introduced was built specifically to address this. It's designed to handle more complex requests, work across multiple steps, and give you greater control over how Copilot edits your workbooks. Rather than maintaining separate experiences that can feel fragmented, we're bringing everything together so you have: More power: Copilot with Agent Mode can now handle complex, multi-step reasoning tasks that go beyond what App Skills could do. Better clarity: You'll know exactly where to go depending on what you need—direct editing happens with Agent Mode; quick answers and simple actions work best in Copilot Chat. Continued innovation: By focusing on improvements toward a unified experience, we can deliver new capabilities faster. As part of this, we also plan to better integrate Agent Mode’s editing capabilities into the Copilot Chat experience in the coming months. What’s changing? App Skills entry points in Excel are going away. You will no longer find an App Skills button in the ribbon or be able to use App Skills from the context menu. Existing skills are consolidating into Copilot Chat and Agent Mode. When you want Copilot to make changes directly in your workbook, Agent Mode is designed to support many core editing tasks, such as creating or updating tables, applying formatting, or generating charts and PivotTables. Copilot Chat remains available for tasks that don’t require modifying content, such as interpretation or exploration of your data and using agents like Analyst. If you can open the App Skills chat pane and submit a prompt, you may receive an error message instead of a response. During this transition, some users may still see App Skills entry points for a short time. In some cases, opening the App Skills pane may result in an error message indicating that App Skills is no longer available. If this happens, you can continue your workflow using Agent Mode or Copilot Chat based on the type of assistance you need. When is it happening? This update is rolling out now. Depending on your Excel version, you may see the App Skills entry point up until the end of February. App Skill scenarios not yet available Certain scenarios that previously used App Skills—specifically the Advanced Analysis mode that used Python in Excel and advanced text analysis capabilities—are not yet available within Copilot Chat or Agent Mode. We are continuing to expand support for these capabilities in Copilot Chat and Agent Mode—watch for updates as these become available over time. Note: this was originally communicated to commercial customers via the M365 Message Center (MC1184407) on November 10, 2025.2.3KViews0likes0CommentsVariance Analysis shows “Coming soon” in Excel Finance add‑in
I have installed the Finance add‑in in Excel and can see other features such as reconciliation working correctly. However, the Variance analysis option is still greyed out and shows “Coming soon”. Has anyone been able to access Variance analysis yet? If so, is availability dependent on tenant region, licence type, preview enrolment, or admin configuration? Any insight on expected rollout timing or prerequisites would be appreciated.60Views0likes0CommentsCopilot not loading in desktop Mac Excel
When trying to load the Copilot sidebar in the Mac desktop version of Microsoft Excel Version 16.91 (24111020), all I get is a loading animation (see screenshot). I've got a Microsoft 365 Subscription, and Copilot for Microsoft 365 license. Copilot works fine in Word. The document I'm working with is saved in a SharePoint team through my OneDrive app, and is formatted as a table.916Views3likes8CommentsHelp needed with IF and COUNTIFS Formulas
Is anyone able to advise the following formula: =COUNTIFS($B$5:$B$15,$R$4,$C5:$C15,"<=" & V3,$D5:$D15, ">" & V3)-COUNTIFS($B$5:$B$15,"="&$R$4,$G5:$G15,"<=" & V3,$H5:$H15, ">" & V3)-COUNTIFS($B$5:$B$15,"="&$R$4,$K5:$K15,"<=" & V3,$L5:$L15, ">" & V3)-COUNTIFS($B$5:$B$15,"="&$R$4,$O5:$O15,"<=" & V3,$P5:$P15, ">" & V3) Is there a way to simplify this? Is there a way to make this more accurate? Cells in column G & H, I & J, O & P are using the following format: =IF(C6="","",C6+E6) Cells in U4:CC4 are using the following format: =COUNTIFS($B$5:$B$15,$R$4,$C5:$C15,"<=" & U3,$D5:$D15, ">" & U3)-COUNTIFS($B$5:$B$15,"="&$R$4,$G5:$G15,"<=" & U3,$H5:$H15, ">" & U3)-COUNTIFS($B$5:$B$15,"="&$R$4,$K5:$K15,"<=" & U3,$L5:$L15, ">" & U3)-COUNTIFS($B$5:$B$15,"="&$R$4,$O5:$O15,"<=" & U3,$P5:$P15, ">" & U3) Cells in U5:CC15 are using the following format: =IF(U$4>=$T5,1,"") My issue is is when I put in the three break times, the mid break comes out at a shorter time. My other issue is is that when I put in the times in row 5,6and 11, the data is coming up as a combined data in rows 5, 6 and seven on the page two. Just for reference, "page two" is the same spreadsheet. What I need to happen is that I enter in the shift start time and finish time. This then populates through to Break 1, 2 and 3. The Time entry is the time the break starts. ie: 1 hour after start of shift, 1 hour after coming back from break, etc. The break entry is the duration of the break taken. ie: 30 minutes. Once all the info is put in, the relevant "Time Block" on "Page 2" shows a 1. What is happening at the moment is that when I enter all the time data, the time blocks are not populating correctly in accordance to the entry. Basically, If I have numerous people on shiftI need the time blocks to show where I have shortfalls in shift cover and not having too many people on break at the same time. IE: Link to Live Copy: https://www.dropbox.com/scl/fi/eur1j526htu1j8a4d4290/Staff-Breaks.xlsx?rlkey=r4tm9xts4tonofpa2th2cusfw&st=nueyk0d7&dl=0 Any ideas would be greatly appreciated.207Views0likes4CommentsCopilot in MS365 not available with one account on one Mac
I am stumped as to why my wife cannot see Copilot in the menu bar of any MS 365 app on her laptop. She is part of the family plan, and I have confirmed that her subscription credentials allow her to use Copilot. The MS apps are at the latest version, along with macOS. Scenario 1: When my wife uses her MS credentials to log in to any MS 365 app on her laptop, Copilot does not appear in the menu bar. When I log her out of MS 365 and log in with my credentials on her laptop, the Copilot appears on the menu bar. She can run the standalone Copilot app on her laptop using her credentials. Scenario 2: When my wife uses her MS credentials to log in to any MS 365 app on my laptop, Copilot appears in the menu bar. I can't tell what is preventing Copilot from appearing in MS 365 on my wife's laptop when she is using her credentials.159Views0likes1CommentCopilot missing in Word, Excel and PowerPoint desktop apps of some users
Hi Everyone, At my company we're setting up copilot. After allowing access through the Admin Centers we've encountered various oddities. Some users can use the sharepoint/onedrive search functionality. But most can't. Some users have the Copilot button in some of their apps. There is no consistency in which app they get it. Some have it in word, others in excel, some in multiple, some in none. A handful of users have Copilot in all apps. Things like transcribe work fine everywhere. We switched intune to push Office apps with Current Channel instead of Semi-Annual, to no avail. We use M365 Business premium with the Teams phone standard addon.334Views0likes1Comment