Recent Discussions
How to return counts of text cells across multiple worksheets in same workbook?
I'm working in Excel 365. Windows environment. Working in the Excel app but will be posting to a shared drive for multi-user data entry. 38 worksheets, one for each office. What I need is to be able to return the total # of records in the data set that are marked as 'Complete', 'Pending' and 'Urgent' (from a drop-down is one cell of each record), by office and the Rep's name that made the entry (also from drop-down). I would also like to be able to return the total entries across all worksheets by Rep Name, so I can see which offices/Reps are making the most/least entries. I'm not very savvy with using Power Query. I've tried to do it, but I think it requires that there are no blank cells in the records. It keeps making tables in the query that don't actually exist. Tried it using 6 worksheets, just to test it, and the appended data set contains way more tables that I added. I'm not bad with pivot tables. If anyone has an idea of how I could accomplish this, I sure would appreciate it! Thanks in advance for any assistance. :)
MS Word Spanish word Bug
Microsoft Office 2013 all the way to 2021 LTSC has a bug in the spanish language grammar and orthographic checker. The grammar and orthographic checker does not detect and mark the following words: doscientes trescientes cuatrocientes quinientes seiscientes Setecientes Ochocientes Novecientes Correct words would be with "a" or "o" as the last vocals: doscientos trescientos cuatrocientos quinientos seiscientos Setecientos Ochocientos Novecientos All of the former are the spanish names for numbers representing hundreds.
Power Pivot Tables not Refreshing
I have a problem with Power Pivot in Excel. When I try to refresh the table it hangs and never completes. It was working fine yesterday. I have tried the following: 1. Check for Data Source Issues Ensure that the source data is accessible and hasn't changed (e.g., moved, renamed, or permissions altered). 2. Check for Large Data Volume or Memory Limit Try refreshing a smaller dataset first (e.g., filter down data in the source before loading). 3. Restart Excel & Try Again Close Excel completely (including any background processes in Task Manager) and reopen it.
Excel Formula Help - Text & Numbers
I would like to have a formula that will automatically change this sequence but can't figure it out, would greatly appreciate the solution as I cant find it searching either. The sequence is TP0285 / 02 / 25 the sequence to change is the 1st the number 285 to 286 and so on, the 02 would change as per the month, March is 03, April 04 and so on and the last digits would change annually. Thanks in advance.
Concatenate or vlookup or something else?
Hello! My first post and I'm not even really sure what formula I am looking for, but I'll try to explain what I need... Along the top of my spreadsheet are the dates of the month. The first column is a list of driver violations. I'm using TRANSPOSE and XLOOKUP to grab the dates of each violation, however, some violations happen on several consecutive days. Instead of lising several consecutive dates in a column, is there a way to return the date of the first violation in a column and the last consecutive date in another column, or return for example October 1 - October 5 in one column? Thank you for any help you can offer! Dawn-Marie
Development Partner for Microsoft Mesh?
Hello, we are a creative technology studio based in Singapore (website), specializing in crafting immersive 3D virtual worlds and interactive experiences for clients across various industries. As pioneers in virtual engagement, we are particularly excited about the potential of Microsoft Mesh and its capabilities. We would love to explore the opportunity to become a development partner for Microsoft Mesh, allowing us to offer enhanced solutions to our clients. We are not sure whom we can contact about this at Microsoft, so any insights are much appreciated. Thank you in advance.Dealing with VSTACK with empty arrays
Hi all Question - do you know how to still display data when there is an empty array within VSTACK? Currently my formula works but displays CALC when an array is empty. I have two tables, both with data filtered based on a particular month. The spreadsheet example works but needs maybe LET & ISERROR to ensure one empty array of results still displays the remainder. Can anyone advise please? =IFERROR(SORT(VSTACK(FILTER(FILTER(A3:E6,(D3:D6<=C9)*(E3:E6>=C9)),{1,1,0,1,0}),FILTER(FILTER(H3:L6,(K3:K6<=C9)*(L3:L6>=C9)),{1,1,0,1,0})),3,1,FALSE),"ERROR") Thank you
Auto-Populating Data From One Sheet To The Other
My structure is 2 separate tabs in the excel sheet. In one sheet, my "Devops Tasks" sheet, I have a status of "COMPLETE", and currently, everything besides 2 are set to "INCOMPLETE". When I set the status to "COMPLETE" my formula populates this data over here to my other sheet which is labeled as "Handover Report" within my "Completed DevOps Tasks This Shift": Right now though, it only populates as #NAME? - What exactly am I doing wrong here in this formula? =@IF(COUNTIF('DevOps Tasks'!C[6],"COMPLETE")>=4,INDEX('DevOps Tasks'!C[2],@AGGREGATE(15,6,@ROW('DevOps Tasks'!C[6])/(@'DevOps Tasks'!C[6]="COMPLETE"),4)),"") As a side note, but maybe not entirely relevant - one way I'm auto-populating is through what I do within JS: const completedTasksTable = handoverSheet.addTable({ name: 'CompletedTasks', ref: 'A' + (handoverSheet.rowCount + 1), columns: [ { name: 'ID', filterButton: true, width: 15 }, { name: 'Title', filterButton: false, width: 50 }, { name: 'Completed By', filterButton: true, width: 25 }, { name: 'Sprint', filterButton: true, width: 20 } ], rows: Array(10).fill().map((_, index) => [ { formula: `=IF(COUNTIF('DevOps Tasks'!H:H,"COMPLETE")>=${index + 1},INDEX('DevOps Tasks'!C:C,AGGREGATE(15,6,ROW('DevOps Tasks'!H:H)/('DevOps Tasks'!H:H="COMPLETE"),${index + 1})),"")` }, { formula: `=IF(COUNTIF('DevOps Tasks'!H:H,"COMPLETE")>=${index + 1},INDEX('DevOps Tasks'!D:D,AGGREGATE(15,6,ROW('DevOps Tasks'!H:H)/('DevOps Tasks'!H:H="COMPLETE"),${index + 1})),"")` }, { formula: `=IF(COUNTIF('DevOps Tasks'!H:H,"COMPLETE")>=${index + 1},INDEX('DevOps Tasks'!B:B,AGGREGATE(15,6,ROW('DevOps Tasks'!H:H)/('DevOps Tasks'!H:H="COMPLETE"),${index + 1})),"")` }, { formula: `=IF(COUNTIF('DevOps Tasks'!H:H,"COMPLETE")>=${index + 1},INDEX('DevOps Tasks'!A:A,AGGREGATE(15,6,ROW('DevOps Tasks'!H:H)/('DevOps Tasks'!H:H="COMPLETE"),${index + 1})),"")` } ]) }); const completedTasksHeaderRow = handoverSheet.getRow(completedTasksTable.headerRow?.firstRow || +1); if (completedTasksHeaderRow) { completedTasksHeaderRow.font = { bold: true }; completedTasksHeaderRow.fill = { type: 'pattern', pattern: 'solid', fgColor: { argb: 'FFF0F5FF' } }; } completedTasksRow.fill = { type: 'pattern', pattern: 'solid', fgColor: { argb: 'FF1E4D8C' } }; completedTasksRow.font = { color: { argb: 'FFFFFFFF' }, bold: true };Access Issues with Windows 11 24H2
I am starting to experience issues with using Access (Microsoft® Access® for Microsoft 365 MSO (Version 2501 Build 16.0.18429.20132) 64-bit), that I have never encountered before. My windows version is Windows 11 24H2. I created a brand new database (to see if my problems occurred on a brand new database and not my existing databases) with two tables, each with 3 records - so a very useful database to have, but anyway... I tried to create a query to join the two tables and saw that: Large areas of the query editor was unavailable for me to drop a table onto - a red circle with a line through it came up Once I dropped the table to an acceptable area (middle of screen), I couldn't create the join by dragging from field to field. I could only create the join by going into SQL mode and writing the join myself I couldn't drag a column to the selection pane to the position i want. I had to double click to put at end of select, then physically move the field to position i wanted. This is definitely not how it should work I have worked with access on and off for 30 years, and haven't come across this. I had totally uninstalled office 365 and reinstalled from the microsoft website. I came across this on reddit but nothing else. Does anyone have any idea on what could be causing this? Many thanks Les
Multi Tenant Organization - one shared user not showing up in Global Address List
I set up a multitenant organization with two tenants. Overall it seems right, users can find each other and chat fairly seamlessly on teams, and shared users appear on the opposite global address list. However, one user is an exception. They appear on their home tenant's Global Address list, but not on the other tenant's (all other shared users appear to). They are members on the other tenant (as are the rest of the shared users), and are not set as hidden on a global address list anywhere I can see. I can't see anything different about them in any way. They were neither the first nor the last to be shared, and I have tried unsharing then sharing them again. They can however be found on teams by typing their name. Probably not related, but I will point out that the one other thing I have not managed to get working is a "chat" link on people's outlook directory listings. None of the shared users have one, despite being chatable with on teams. Any idea where I might look for the culprit?
Security Admin Center Tenant Allow/Block List Not Able to Block IPv4?
While using the Security Admin Center Tenant Allow/Block List we have been able to block specific email addresses and IPv6 IP addresses but are unable to block IPv4 IP addresses. We have tried both using the console and the CLI but have turned up unsuccessful both times when it comes to IPv4. A large majority of the phishing attempts that we encounter come from IPv4 addresses but we have been unable to block any of these. Will there ever be functionality for IPv4 within the Tenant Allow/Block list or is the only option to use conditional access policies? Also why is this enterprise tool only functional with IPv6 and without documentation stating that it does not work for IPv4?"Sorry , something went wrong"
Can anyone help me with this error? In one of the Excel online workbook, which has a lot of rows and links. since around 2 weeks ago, everytime anyone double clicks any cells with hyperlink, it will show this error message afterwards and if you press OK the workbook will reload. Thank you.Group Owned Forms - Restricting Access
Hello, all. I have a group owned form. Lets call this "Training Log Form". The group lets call it "R&D". This is a well established MS Group with members, and owners. So each member can view this form, its outputs in excel are already linked to the SharePoint site that we use daily. This is all great, only one issue. Anyone that is a member of this group can edit the main contents of this form (questions, sections, answers, title, etc.). We have a collection of different document controlled forms (typically in excel format, setup as templates) and they are document controlled through our SharePoint system. How can I restrict access of who is able to edit these forms internal to this "R&D" Group? Any help would be great, thanks!
Table: Formula to return a value from the table if other cells contain certain values
Hi everyone! I have a table (like in the screenshot below) that contains certain values in column D/E/F/G. I want to create a formula in which you can enter in the below B2/B3/B4 values from columns D, E and F and depending on the row in the table where all 3 values are true, then B5 returns the corresponding value from column G in that row. Does anyone have any idea which formulas I could use for this? Thank you so much for your ideas! 🙂=_xlfn._xlws.SORT added to some PCs but not others
Hello, So we have an efficiency tracker spreadsheet and it contains a hidden sheet with a set of formulas that are contained here. For certain Windows 10 PCs, they are able to view this spreadsheet properly with the formulas. However, we still have Windows 7 PCs that cannot view the spreadsheet properly and the file prefix: "=_xlfn._xlws" is added to the formulas while on the PCs it is working on this field is not present. I do have a Windows 10 PC with a different Office 365 subscription than my colleagues and the spreadsheet shows these same problematic fields ("=_xlfn._xlws.SORT"). Could you help me out? Thank you, ChrisCreating Sankey Diagrams
Hi, Does anyone have any guides for creating Sankey Diagrams in Excel. I deal with the analysis of a reasonably long process which has various customer inputs and outcomes. I am looking for a visual way to show everyone who came into the process, and what happened to each person. Sankey Diagrams seem to fit that bill perfectly. Any help would be appreciated. Thanks TRelative cell reference in formula is not updating when dragging down rows
I have this formula: =SUM(COUNTIF(INDIRECT({"j16","n16","r16","v16","z16","ad16","ah16","al16","ap16","at16","ax16","bb16","bf16","bj16","bn16","br16","bv16","bz16","cd16","ch16","cl16","cp16","ct16","cx16","db16","df16","dj16","dn16","dr16","dv16","dz16","ed16","eh16","el16","ep16","et16","ex16"})|"=1")) When I drag down to populate more rows with the formula, the cell references are not updating. It just copies the same formula. Have other formulas that update the cell references fine in the same sheet. I have tried adding $ in front of each cell, in between the row & cell #, removing quotes (which breaks the formula) nothing works. Any help is much appreciated.
Events
You care about keeping up with the latest tech, building your skills, and helping your business succeed. And that’s why we’re here. This year, the Microsoft 365 Community Conference returns to Las Ve...
In-Person
Recent Blogs
- Empowering our users to tell stories worth sharing lies at the heart of what we do at Clipchamp, and in a world increasingly focused on enterprise narratives, it’s become clear that these stories are...Feb 10, 2025
- We are excited to announce a series of new features in Shared Device Mode that will significantly enhance the experienceFeb 10, 2025
