excel
44488 TopicsAgent Mode in Excel is now generally available on Excel for Web
We’re excited to announce that Agent Mode in Excel is now generally available on Excel for Web, rolling out to users with a commercial Microsoft 365 Copilot license or a Microsoft 365 Premium subscription. This launch marks a major shift in how you work with Copilot in Excel—moving from basic assistance to an agentic experience with capabilities to build multi-step workflows directly in your workbook. Agent Mode delivers: Multi-step workflows: Move beyond single-turn commands. Ask, refine, and build iteratively with Copilot. Direct workbook manipulation: Copilot applies changes directly inside your workbook, no clicks or copy/paste needed. Transparency and reasoning: See how Copilot interprets your request, the steps it takes along the way, and explanations of each output along with verification. Hear from Carlos Otero, a member of the Excel team, who recently chatted with Excel MVP Kevin Stratvert on why Agent Mode is a game-changer for Copilot users: What’s possible with Agent Mode Agent Mode unlocks scenarios that go far beyond traditional chatbots. Some examples now possible include: Create workbooks: Generate new content directly in Excel, grounded in both existing workbook data and web search results to bring in relevant context. Scenario modeling: Run what-if analyses for revenue, budgets, or forecasts and model advanced scenarios with adjustable assumptions. Data analysis: Generate analyses of large datasets, highlight anomalies, and surface trends with formula-driven analysis. Formula generation: Fix broken formulas or and generate dynamic formulas that connect across your workbook data, including explanations for complex calculations. Data visualization: Create pivot tables, charts, and dashboards—all through natural conversation. Generate native Excel artifacts that recalculate and update based on changes to the underlying data. What’s generally available in Agent Mode today Platform: Excel for Web. Coming in January to Excel for Windows and Mac. Language support: English (US), Spanish (Spain, Mexico, Japanese, French (France, Canada), German, Portuguese (Brazil), Italian and Chinese (Simplified).; additional languages to follow. Web search: Outputs are grounded in web data when needed. File grounding and Work IQ support are planned for early 2026 to enable richer work context. Licenses: Available for commercial Microsoft 365 Copilot licensed users and Microsoft 365 Premium subscribers. Coming in January to Microsoft 365 Personal and Family subscribers. Ready to experience the future of Excel? Open Excel on the web with an eligible license and start using Agent Mode from the Tools menu. Learn more here.54Views0likes0CommentsFormula help
I have the following formula that partially works. It processes this formula and returns the 1st match based on the formula criteria. =IFERROR( LET( KeyTypes,FILTER('Key Log'!$F$4:$F$309,(TRIM('Key Log'!$A$4:$A$309)=TRIM($D$6))*(TRIM('Key Log'!$C$4:$C$309)=TRIM($K$15))), KeyNums,FILTER('Key Log'!$K$4:$K$309,(TRIM('Key Log'!$A$4:$A$309)=TRIM($D$6))*(TRIM('Key Log'!$C$4:$C$309)=TRIM($K$15))), IF(INDEX(KeyTypes,ROW(A1))="Hard Key","V"&INDEX(KeyNums,ROW(A1)),INDEX(KeyNums,ROW(A1))) ),"") This formula resides in cells A8:A18 which is designed to return a key number, whether the key be a swipe key or a hard key. Cells B8:B18 are for descriptions of the key identified in cells A8:A18. This formula is supposed to find the 1st match on the key log and then find any other matches and place them in cells A8:A18. There is another formula for defining the description based on criteria. I need this formula to search out all transactions on the key log that match the ID number on the Key Issue Form in cell D6 with the cells in column A on the ID number and to also match the room number from K15 on the Key Issue Form with the room number in column C on the key log. There is something missing from this formula that is not allowing the other transactions to be found and listed on the Key Issue Form. Can anyone help me complete this formula? This is the formula for B8:B18 =IF(A8="","", LET( FilteredRows,FILTER(SEQUENCE(ROWS('Key Log'!$A$4:$A$309)),('Key Log'!$A$4:$A$309=$D$6)*('Key Log'!$C$4:$C$309=$K$15)), RowNum,INDEX(FilteredRows,ROW(A1)), Room,INDEX('Key Log'!$C$4:$C$309,RowNum), Status,INDEX('Key Log'!$E$4:$E$309,RowNum), Type,INDEX('Key Log'!$F$4:$F$309,RowNum), DateVal,INDEX('Key Log'!$D$4:$D$309,RowNum), IsAB,OR(RIGHT(Room,1)="A",RIGHT(Room,1)="B"), DoorDesc,IF(IsAB,"Combined Main & Room Door","Main Door"), KeyDesc,IF(Type="Swipe Key","Swipe Key","Hard Key"), DoorDesc & " " Can someone help me figure this out? Carl136Views0likes5CommentsDependent calculations in tables
Hi all, I'm using a formula to calculate amounts into a master column in budget sheets depending on the currency. I'm pulling currency rates with the stock function into a separate sheet with named cells for each rate that I'm using. My budget table has a "Total" column where I put in the amount, a "Cur" column where I select the currency, and then the master column where it's converted into the currency that I'm working with for each budget. The formula I'm currently using is this: =IFS([@Cur]="EUR";[@TOTAL];[@Cur]="NOK";nokeur*[@TOTAL];[@Cur]="SEK";sekeur*[@TOTAL];[@Cur]="GBP";gbpeur*[@TOTAL];[@Cur]="";) nokeur, sekeur, gbpeur are named cells containing the currency rates. The last argument is only to not get a REF error on empty rows. (Semicolons instead of commas due to my language settings) This has gone through a bunch of revisions over the years and I'm constantly trying to shorten the formula as much as possible. This is the shortest I've managed to get it though. I wanted to check if anyone has any advise on how to make it more elegant. the formula does exactly what I want so it's not a problem per se, it's more out of interest. Also a related topic: sometimes when others are using my sheets, they will mistakenly put values in the Master column, overwriting the formula. This is hard to spot, and ideally I'd like to lock those cells/that column so you can't replace what's there. Locking the workbook can of course achieve this but it also prevents the user from adding additional lines in the table. Is there any smart way to get around this? I've also tried with conditional formatting to clearly highlight the cells if they don't contain a formula but I haven't managed to make it work properly.36Views0likes2CommentsNeed help with conditional fomatting formula based in text on cells
Hi everyone, I have a list of owners' names in column C. C2 contains 1+1 CAR CORPORATION C3 contains 8-J ENTERPRISES, LLC C4 contains LOYD RENTALS LLC C5 contains SMITH PAUL & PAULA C6 contains DOE JHON & JANE C7 contains MENENDEZ JAMES C8 contains BROWN INVESTMENTS, INC. And so on I'd like to highlight the whole row for the cells that have CORPORATION, LLC, INC, ENTERPRISES in their names. Hope this makes sense and someone can help me. Thank you.71Views0likes4CommentsHow to make excel add or remove rows to fit data and prevent spill error?
Hello! My question is: When using the =FILTER formula to copy cell data from one sheet to another, how can I make excel add or remove rows as needed to prevent a spill error? I am using the =FILTER formula to copy cell data from one sheet to another if a checkbox is checked. My formula uses the cells containing the checkbox (column A) as the reference for columns B, C, D, etc. to the right. I did this by selecting the cell that has the formula on the destination sheet, highlighting this cell and those to the right I wanted to transfer, and then control + r. My formula is: =FILTER('Source Sheet'!B5:B13,'Source Sheet'!$A5:$A13=TRUE) (If there is a way to copy an entire row from the source sheet instead of having to control+r to apply the original formula across select cells please also let me know, thank you!). However, I want the sheet to be able to automatically add rows to fit the data if the selected number of rows is greater than what I have left available on the sheet. Currently, if I leave 3 rows for data to fill and I select three checkboxes, this will fill the space with no problem. However, if I select 4+, I get a spill error (as there are not enough empty rows to put the data). Is there any easy way to have excel add rows as needed? Similarly, is there a way for excel to remove rows as needed? I am going to use this sheet to detail all medications being taken by family members (with medication name, concentration, dose, time to take each in their own column as column B, column C, column D, column E). The names will be listed in column A with ~3 rows below each name which will fill when the checkbox on the source sheet is clicked. I want to ideally fit this on one page when printing without major "fit to page" problems that come up during printing. The layout of the sheet will ideally look like this: The goal for the 'destination sheet' is to pull only the selected data I want to use from my master list on the 'source' sheet.' I want to avoid having a big empty space under each family member where they don't take many medications, and to also not have to manually add rows for family members that take a greater number of medications. Please let me know and thank you!214Views0likes5CommentsControlling Formula Output in Excel Based on Cell Entry
Scenario Description In this scenario, cell B1 in Excel contains a value of 50. Cell B2 uses the formula =B1+25-A2 to calculate its value. When the number 25 is entered into cell A2, the result in B2 is 50. Desired Outcome The objective is to ensure that cell B2 remains empty until a value is entered into cell A2. Currently, B2 will display a result regardless of whether A2 has an entry. The goal is to prevent B2 from showing any value or calculation until A2 contains data. Question How can this behaviour be achieved in Excel so that B2 only displays a result after an entry is made in A2?54Views0likes2CommentsTrying to insert Pivot Table
I recorded a new macro, using the tab View Macros-Record Macro, which resulted in the following VBA code: Sub CreatePivotTable() Sheets("Year Data").Select Range("A3:F24").Select ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "Year Data!R3C1:R24C6", Version:=xlPivotTableVersion14).CreatePivotTable _ TableDestination:="Yearly Summary!R3C1", TableName:="PivotTable3", _ DefaultVersion:=xlPivotTableVersion14 Sheets("Yearly Summary").Select Cells(3, 1).Select End Sub The recording did exactly as I wanted, taking the data from the "Year Data" WS and adding the new pivot table to the "Yearly Summary" WS. As a test of the macro, I deleted the initial pivot table that was created on the "Yearly Summary" WS. The problem I have now, when I attempt to run this macro again it constantly fails on the 4th line of the macro with Run-time error '5': Invalid procedure call or argument. ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "Year Data!R3C1:R24C6", Version:=xlPivotTableVersion14).CreatePivotTable _ TableDestination:="Yearly Summary!R3C1", TableName:="PivotTable3", _ DefaultVersion:=xlPivotTableVersion14 I cannot figure out why it works when I am recording the macro but fails when I try to run it alone. Help is greatly appreciated.Solved78Views0likes2Comments"all the merged cells need to be the same size" during a Custom Sort
On ASUS StudioBook x64 PC, Windows 10 Pro for Workstations, ver. 20H2 (OS Build 19042.1288)Microsoft 365, EXCEL ver. 2109 (Build 1443020306) ... While attempting to do a custom sort of an EXCEL table of 96,600 + records, I received an error stating "all the merged cells need to be the same size during this operation" Following online help directions for finding merged cells, none were found! (I didn't knowingly create merged cells, but when clicking Options > Format > Alignment, under Text Control, both "Wrap text" and "Merge cells" have their squares filled in with black fill.) The same error occurs when I attempt to sort the field 'editinitl' (A to Z) in the table. The field holds 3-character-long abbreviations of persons name in capital. Why is this message occurring when the suggested find procedure finds no merged cells? Here's the procedure I tried to find the merged cells. Find merged cells You may encounter an Excel worksheets that has https://support.office.com/en-us/f1/topic/merge-and-unmerge-cells-5cbd15d5-9375-4540-907f-c673a93fcedf?NS=EXCEL&Version=90 that you don’t know about. This can be frustrating because Excel doesn't sort data in a column that contains merged cells. Following the steps below, you can find all the merged cells in your worksheet and then https://support.office.com/en-us/f1/topic/merge-and-unmerge-cells-5cbd15d5-9375-4540-907f-c673a93fcedf?NS=EXCEL&Version=90. Click Home > Find & Select > Find. Click Options > Format. Click Alignment > Merge cells > OK. Click Find All to see a list of all merged cells in your worksheet. When you click an item in the list, Excel selects the merged cell in your worksheet. You can now https://support.office.com/en-us/f1/topic/merge-and-unmerge-cells-5cbd15d5-9375-4540-907f-c673a93fcedf?NS=EXCEL&Version=90. Need more help? You can always ask an expert in the Excel Tech Community or get support in the https://go.microsoft.com/fwlink/?linkid=827514.775KViews1like12CommentsLinking a cell from a OneDrive excel sheet to another OneDrive excel sheet in different workbooks
Hi, I'm trying to make a cell in sheet A of workbook 1 display the cell from sheet X in workbook 2. Both workbooks are in the same parent folder with different sub folders. I want all this to be done with OneDrive apps, not desktop app. Any help would be greatly appreciated! Thanks9.5KViews0likes3Comments