Excel for web
1967 TopicsInconsistent “Wrap Text” Behavior Between Excel Desktop and Excel Web
We’ve observed inconsistent behavior with the “Wrap Text” format across different Excel environments (Windows Desktop vs. Web). Steps to Reproduce: Create or open an Excel file. Enter multi-line text in several cells and enable Wrap Text. Save the file locally. Upload it to OneDrive or open it in Excel for Web. Observe the displayed cell content without resizing the columns or reapplying formatting. Observed Behavior: On Excel for Windows (Desktop) → Wrapped text displays correctly. On Excel for Mac (Desktop) → Wrapped text displays correctly. On Excel for Web → Text may not wrap properly by default, requiring manual reapplication of “Wrap Text.” Expected Behavior: Cell content formatted with Wrap Text should display consistently across all Excel platforms (Windows, Mac, and Web) without requiring manual adjustment or reapplication. Excel Mac Desktop: OneDrive:97Views0likes3CommentsExcel Filter Formula Help
MS Support Community, I have a search field that looks for specific data in a large amount of data. I have the users only able to view the columns that they need by using the CHOOSECOLS function. The formula has multiple search options and if nothing matches it is supposed to put "No Vessel Found" in the field, but it is just giving me a "VALUE! error in the field. The formula is below and I have been kicking myself trying to figure this out...any help would be appreciated. =CHOOSECOLS(FILTER(Vessel_List,ISNUMBER(SEARCH(C5,Vessel_List[IMO Number]))+ISNUMBER(SEARCH(C5,Vessel_List[Vessel Name]))+ISNUMBER(SEARCH(C5,Vessel_List[Linked to (if known)])),"No Vessel Found"),3,4,8,9). Thank you in advance for your assistance! Shawn57Views0likes1CommentAgent Mode continuously loading
Hi all, I installed Excel Labs today and have tried to use https://www.microsoft.com/en-us/microsoft-365/blog/2025/09/29/vibe-working-introducing-agent-mode-and-office-agent-in-microsoft-365-copilot/ for Excel in the web. However, no matter which prompt I use, it just loads continuously, even when left for hours. Has anyone got this working? Or know how to resolve this? I appreciate it's a Preview feature, so happy to wait if it's a temporary glitch, but thought it'd be worth checking.81Views1like4CommentsRemove sub-folder urls if the parent folder url exists
I have an excel sheet with one column which contain urls from sharepoint, the urls looks as follow:- /sites/Marketing/Budget /sites/Marketing/Budget/2015 /sites/Marketing/Budget/206 /sites/maps /sites/Expesnes /sites/Expenses/2020 now i want to delete all the sub-folders if their parent folder exists? so for example the above rows should be as follow:- /sites/Marketing/Budget /sites/maps /sites/Expesnes is there any script i can run to do this cleanup? Thanks81Views0likes2CommentsAutocompletar em vez de trazer dados acima da célula, traz os que estão abaixo.
Olá Tenho especificamente uma planilha que no Excel web (Microsoft 365) em que o autocompletar não está funcionando da forma normal, isto é, trazendo os dados que estão na mesma coluna, acima da célula. Em vez disso, traz os dados que estão abaixo. Exemplo: Ao digitar "b" em A5, em vez de o autocompletar sugerir "beta", traz "ball". Alguém tem esse problema? Conseguiu corrigir? Como?93Views0likes3CommentsConditional formatting across sheets
I have a sheet which manages the works of multiple budgets. One sheet provides an overview of the budget and the next show the various schemes attributed to the numerous budget codes. Currently I have to flip back and forth to see whether the budgets have available monies before progressing a scheme but with a high number of jobs each day this can be quite time consuming. I would like a formula to format the budget name cell in the second sheet (B:B) when the value in the available budget column (J:J) relative to the specific budget name (B:B) both in the first sheet, is showing as a negative figure.Solved88Views1like2CommentsAdditional help needed with existing formula using LAMDA- Excel 365
Good day! I received assistance here with this formula. It's supposed to use the scores of various evaluation categories displayed in E5:E12 to only display for printing the records for the ones on which the goal is either "Not Met" or "Exceed". The review categories that are blank (no items reviewed) and/or those indicated as "Met", should not be spilled. Currently, the formula included below only excludes the category and records of the one where there are no values (no items reviewed). So, I'm trying to figure out how to adjust the formula to also exclude the records of the review categories marked as "Met" in the range E5:E12 on the spilled report tab. =LET(filterBy, RESULTS!A2:C2, resultTable, RESULTS!A5:E12, columnCounts, {5,6,5,5,5,7,6,7}, report, LAMBDA(result_filter,result_row,table_all, LET(table_data, DROP(table_all,1), table_matches, (CHOOSECOLS(table_data,3)=INDEX(result_filter,1))* (CHOOSECOLS(table_data,2)>=INDEX(result_filter,2))* (CHOOSECOLS(table_data,2)<=INDEX(result_filter,3)), IF(N(INDEX(result_row,2)), VSTACK("*** "&INDEX(result_row,1)&" ***", TAKE(table_all,1), FILTER(table_data, table_matches, "")), ""))), total, REDUCE("",SEQUENCE(ROWS(resultTable)),LAMBDA(p,q,VSTACK(p, LET(tbl, INDIRECT("tbl"&TEXTJOIN(,,TEXTSPLIT(INDEX(resultTable,q,1),{" ","-"}))&"[#ALL]"), report(filterBy, CHOOSEROWS(resultTable,q), CHOOSECOLS(tbl,SEQUENCE(,INDEX(columnCounts,q)),SEQUENCE(,2,COLUMNS(tbl)-1)))) ))), IFNA(IF(total=0, "", total),"")) Any assistance with this is greatly appreciated!Solved631Views0likes20CommentsWorking with workbooks shared via Teams/Sharepoint
Hello Excellers, I need some insight on an issue that I am not sure what the source is... A) We sometimes share workbooks via Teams. You know when you are in a particular chat and next to the name of the chat at the top of the screen you see Shared and then you see Files button a bit below the Shared menu and when you click on that Files button you will see a list of what workbooks are shared. B) So I wrote some VBA code to download a copy to the Downloads folder like that: Dim RetVal As Long Dim SharePointFileURL As String Dim LocalDownloadPath As String Dim FileName As String RetVal = URLDownloadToFile(0, SharePointFileURL, LocalDownloadPath & FileName, 0, 0) If RetVal = 0 Then MsgBox "File successfully downloaded to: " & LocalDownloadPath & FileName, vbInformation This will message be replaced by the code we need to run... but for now I needed an indicator that it finished downloading. Else MsgBox "Failed to download the file. Please check the URL or your network connection.", vbExclamation End If So RetVal is = 0, and I do see the workbook in the \Downloads folder and it has a size of 4KB and the correct Date Modified time stamp, BUT When I try to open the workbook via the Excel desktop application I get the message: Excel cannot open the file "File name here" because the file format or file extension is not valid. Verify that the file is not corrupted and that the file extension matches the format of the file. The workbook should be 34KB in size and that 4KB file is not what I need??? Any ideas how to manage this, saving a workbook from a SharePoint / Teams file location to the computer so that we can run VBA code on it. GiGi152Views0likes4Comments