Recent Discussions
Table Styles and the Ribbon Table Design>Table Option Checkboxes
I have been dabbling in Word VBA for almost three decades but have a fairly limited practical use for Word so I rarely find myself dealing with Tables. However, the other day I got interested in Charles Kenyon's post on creating a table style with VBA and that led to my discovery of some very odd behavior with both the Table Option Checkboxes on the Ribbon and table style visibility. Specifically a) What triggers which of those six buttons is checked when a table style is applied, b) Why can't one or more of the plethora of "Table Styles" be removed from the Table Style Gallery on the Table Design Ribbon and c) Why can't the table style visibility be modified in the Style Manager "Recommended Dialong ("Show, Hide, Hide Until Used" is dimmed). First, I took Charles' recorded macro and modified it to focused on only two conditional formatting object “Header Row” and “Total Row” Option Explicit Sub TableStyleCreate() Dim oStyle As Style Dim oTS As TableStyle On Error Resume Next If ActiveDocument.Tables.Count = 1 Then ActiveDocument.Tables(1).Delete 'For testing. DoEvents Set oStyle = ActiveDocument.Styles.Add("Table with Just One Condtional Style Element", wdStyleTypeTable) If Err.Number <> 0 Then 'The named style already exists. Delete it. ActiveDocument.Styles("Table with Just One Condtional Style Element").Delete DoEvents Set oStyle = ActiveDocument.Styles.Add("Table with Just One Condtional Style Element", wdStyleTypeTable) End If oStyle.BaseStyle = "Table Grid" On Error GoTo 0 Set oTS = oStyle.Table With oTS.Condition(wdFirstRow) 'Associated with Header Row Checkbox .Shading.BackgroundPatternColor = wdColorLightTurquoise DefineBorder .Borders(wdBorderLeft), wdLineStyleSingle, wdLineWidth150pt, wdColor:=wdColorBlue DefineBorder .Borders(wdBorderRight), wdLineStyleSingle, wdLineWidth150pt, wdColorBlue DefineBorder .Borders(wdBorderTop), wdLineStyleSingle, wdLineWidth150pt, wdColorBlue DefineBorder .Borders(wdBorderBottom), wdLineStyleSingle, wdLineWidth150pt, wdColorBlue DefineBorder .Borders(wdBorderVertical), wdLineStyleSingle, wdLineWidth150pt, wdColorBlue End With With oTS.Condition(wdLastRow) 'Associated with Total Row Checkbox .Shading.BackgroundPatternColor = wdColorRose DefineBorder .Borders(wdBorderLeft), wdLineStyleSingle, wdLineWidth150pt, wdColorRed DefineBorder .Borders(wdBorderRight), wdLineStyleSingle, wdLineWidth150pt, wdColorRed DefineBorder .Borders(wdBorderTop), wdLineStyleSingle, wdLineWidth150pt, wdColorRed DefineBorder .Borders(wdBorderBottom), wdLineStyleSingle, wdLineWidth150pt, wdColorRed DefineBorder .Borders(wdBorderVertical), wdLineStyleSingle, wdLineWidth150pt, wdColorRed End With ActiveDocument.Tables.Add Selection.Range, 5, 7 Selection.Tables(1).Style = "Table with Just One Condtional Style Element" lbl_Exit: Exit Sub End Sub Sub DefineBorder(oBorder As Object, Optional LineStyle As WdLineStyle = wdLineStyleSingle, Optional LineWidth As WdLineWidth, _ Optional wdColor As wdColor = wdColorAutomatic) On Error Resume Next With oBorder .LineStyle = LineStyle .LineWidth = LineWidth .Color = wdColor End With On Error GoTo 0 lbl_Exit: Exit Sub End Sub TABLE STYLE OPTION CHECKBOXES After the macro runs, there is a five row, seven column table inserted into the document with conditional formatting displayed only on the “Header Row.” The reason for this is because when the table is inserted the Table Style Options on the Table Design tab are configured with “Header Row, Last Column, and Banded Rows” checked with “Total Row, Last Column and Banded Columns” unchecked. When I then checked “Total Row,” my style defined last row formatting was displayed. My style is formatted with only “Header Row and Total Row” formatting. Why was “First Column and Banded Rows” checked and “Total Row” not? I mean, if I go to the trouble of creating a style with conditional formatting, it seems to reason that I would want to see that formatting applied when I apply that style to a table. Why would I need to take the extra steps of selecting the table, clicking Table Design tab, and checking unchecked boxes? While investigating, I read that: "Set as Default" Function: If you modify a table (e.g., check "Total Row") and right-click to select "Set as Default," those specific check marks will appear on all future tables. So, I selected the table, and checked “Header Row and Total” and unchecked the other four boxes, then selected the style in the Table Styles Gallery, right clicked and applied "Set as Default." I inserted another table, applied the style but still, the formatting was incorrect for the second table. I had to again, select it, select Table Design and check the unchecked box for Total Row. I also read that the default configuration of the Table Style Option buttons is set as Header Row, First Column and Banded Rows checked whenever a new table is inserted in a document. That seems a bit illogical as I believe the default table style when a new table is inserted using Insert>Tables>Table is "Table Grid". The built-in Table Grid style doesn't have conditional formatting applied to either the Header Row, First Column or Banded Rows. One may wonder why are the boxes checked in that case? But they are. However, that theory is debunked because if you insert a table using a simple VBA procedure: Sub InsertSimpleTable() Dim oTbl As Table Set oTbl = ActiveDocument.Tables.Add(Selection.Range, 8, 6) MsgBox oTbl.Style.NameLocal End Sub ... which again has no conditional formatting applied, the Table Style Option boxes checked are "Banded Rows" and "Banded Columns" (the Header Row and First Column boxes are unchecked). Where is the logic in that? What triggered this change? It seems to me that the logical behavior would be that whenever a Conditional Formatting is defined in the table style that the associated Table Style Option button would be checked and the others unchecked when the table is inserted and that style applied. If a user then wants to then turn off the display of one or more conditions, then they uncheck it. Scenario: I need to create a document with 100 tables with conditional formatting applied to the Header Row and Total row. First table contains 3 rows, the second 4 four rows, third 5 row … the one hundredth 102 rows. I create a style with conditional Header and Total row formatting. I insert the first table apply the style, select the table, click Table Design Tab, check Total Row in table design options. I shouldn’t have to repeat those ridiculous steps for each of the next 99 tables. Madness!! TABLE STYLES IN GENERAL Next is table styles in general. The Table Design>Table Gallery has a plethora (a hundred or more) table styles displayed. Shauna Kelly discusses this absurdity in her page on tables styles (can't seem to post link) and how to remove some or all of them. She is right. Despite the artificial idiot solution to the prompt Word Table Design>Table Style Gallery remove a displayed style: To remove a displayed table style from the gallery in Word, right-click the specific style in the Table Design tab's gallery and select Remove form Style Gallery. This instantly removes the style from view in the current document, although it remains available in the full style list. There is no "Remove from Style Gallery" and as she states, there is no apparent way in the user interface to remove these built-in table table styles. Unfortunately, her suggested VBA method for doing so (in which I think there are typos): Sub HideATableStyleButMakeItVisibleWhenUsed() With ActiveDocument.Styles(Word.wdStyleTableLightShading) .Visibility = True 'Yes, True. .UnhideWhenUsed = True End With End Sub nor my altered version makes any difference. Sub MyAlteredVersion() With ActiveDocument.Styles(Word.wdStyleTableLightGrid) .Visibility = False .UnhideWhenUsed = False .Hidden = True End With lbl_Exit: Exit Sub End Sub At other places on the web, I have read that you can perhaps "hide" these styles with the Manage Styles "Restrict" dialog or Manage Styles "Recommended" Dialog. I applied restriction to all List Tables styles and still all 49 List Table type styles doggedly persist in the Table Style gallery. Attempts to hide using the visibility settings with the Style Manager Recommended Tab also fails: You can select Table Styles that are visible in the Table Style Pane and try to make them hidden but the associated visibility buttons are dimmed. All of my testing has been done with Word 2019. Does anyone have any evidence that any of these oddities/anomalies are resolved in new versions? Thank you.
Help Clean Up This Formula
Hello, I am looking for a way to compact this formula more. I have about 20 rows I need to do. =C25-IF(OR(COUNTIF(D3,{"A","B","C"})),C3,0)-IF(OR(COUNTIF(D4,{"A","B","C"})),C4,0)-IF(OR(COUNTIF(D5,{"A","B","C"})),C5,0) I am trying to minus the amounts in column C# if Column D# = conditions A, B or C from C25. The math is all happening in one cell. Both columns are 3 through 24. I am hoping there is a way or am I SOL and have to do each row by hand? Thank you, Casey
Unable to remove Office Store applicaitons in admin center:
Hi! Yesterday I changed the settings in the screenshot below and it worked. It showed that IT blocked access when clicking on the Add-Ins button in Word and Excel. Today it shows the list off add ins and nothing was changed in the settings. Users can install add ins again: Google shows results of an Org setting in M365 admin panel that doesn't exist anymore. Any help would be appreciated.
filter and find
hi I am using filter and find function but the function is returning wrong results. cell R27 should return value from column G for No. '5' (B column) but instead its returning value for No. '95'. how do i fix this. on a side note while posting queries how do i remove this ribbon; its a bit annoyingHow do you run engagement surveys with Forms, effectively?
We run quarterly engagement surveys through Forms and the response rate is decent. But the problem is what happens after. The results go into a PowerPoint, leadership discusses it once, and then nothing changes until next quarter when we ask the same questions again. My boss asked me to find a way to make survey results more actionable - like automatically flagging teams with low scores, triggering follow-up 1:1s, or at least giving managers a dashboard they'll actually look at. Is anyone doing engagement surveys inside Teams in a way that connects to real follow-up actions?Leverage User and Group Assignments to Limit User Access to Apps
User and Group assignments can be added to Entra ID applications. Once assignments exist for an application, only assigned users can access that application. This method is a good way to secure access to applications that have consent to use high-profile permissions like Sites.FullControl.All or Mail.Read. Microsoft 365 tenants should consider how to use assignments to control user access to applications. https://office365itpros.com/2026/04/10/user-and-group-assignments/
OneNote breaks if I move it onto an external display
Hi guys I use OneNote extensively for work as my virtual notepad. At most of my working locations, I use my laptop - Dell Latitude 7440 - connected to either a Dell Docking station + 2 monitors, or a pair of samsung monitors which have an inbuilt hub, connect via USB-C and are daisychained together. I've never had any issues with OneNote in the past, but recently have found that if I try and move my OneNote window onto either external monitor, it seems to break OneNote - the whole window becomes just the index list which is normally a column on the left (where it shows all your notebooks and pages) and it won't actually display any of the content from the notebooks/pages. If I try minimizing that column, it has a complete breakdown as if its unable to properly load the actual page content. The only way to fix this is to drag the window back to my laptop screen and then close it and reopen. Has anyone else experienced this? It's really frustrating and affecting my productivity as I often need it side-by-side with other screens.Excel Pivot Table shows all records but one row is displaying blanks for some columns
Hello, My Excel pivot table returns all rows that should be returned according to filters applied directly to column filters in the pivot table itself, or via some Slicers that I've created off of this pivot table. For 2 particular Business Units, there is one row (again, that is properly returned as a row in the filtered pivot table - i.e., no 'missing' records) that shows values in the first 4 columns of the pivot table, but does not display the values in the subsequent 9 columns, despite the fact that the data is fully populated in the Source data. The one source field I've added to the 'Values' section of the pivot table (Report Count) does display values as expected. Troubleshooting tried so far: I've ensured that my Named Range data source is properly capturing the entire source dataset - i.e., no dataset rows or columns left off I've refreshed my pivot table numerous times after changing filters directly in the pivot table itself, as well as changing the filters in Slicers built off of that pivot table. In the Pivot Table Options, on the 'Data' tab: the 'Number of items to retain per field' is set to 'None'. And the 'Save source data with file' check box is not checked off. I've deleted/re-added the source data for the problematic, 'invisible' pivot table columns (not showing the data as expected) and refreshed the pivot table, but that did not correct the issue. I inserted a blank row adjacent to 1 of the 2 problematic records in the source data and copied the data from the problematic record into it, and deleted the original record and refreshed my pivot table, which also did not remediate the problem. I've also built another pivot table in the same workbook on a different Excel worksheet (using the same Named Range data source) and added all the same fields for one of the problematic records and they are all displaying normally. The only error message of any kind that is generated is when I go to one of the problematic records in the pivot table itself, select one of the cells in that row that is displaying a blank and then try to click on the Formula bar - the error message is, 'We can't change this part of the pivot table'. But, I believe this is a normal message if Excel senses that you're trying to update data in a pivot table. There are no error other messages or difficulty refreshing to report. Other relevant points: All told, I have 239 total rows in my source data, and all rows appear normally in the pivot table with the exception of these 2 problem records. There have been no other performance/display issues of concern outside of this one. This Excel workbook is mainly utilized on SharePoint by multiple Users, but for more complex updates/troubleshooting, I am easily able to bring it down to work in Excel Desktop as needed - and this problematic display with these 2 records is present regardless of whether I'm working with the file on SharePoint or with Desktop Excel. I can't think of what else to try at the moment - I've never seen anything like this in my 25+ years of working with Excel. I hope I'm missing something simple - any troubleshooting suggestions are greatly appreciated!
I am Facing Microsoft form related issue
I am Facing Microsoft form related issue, I can see when I am downloading a Excel copy some columns are blank. This is my survey form, and I cannot add manually however this will reflect manipulation in data, as this is technical glitch need assistant from your side on urgent basisI want to record a VBA macro. The Record Macro button only records OfficeScript. How?
I saw another post drawing the disctinction between the Automate toolbar tab and the Developer tab, but that distinction doesn't seem to work anymore. The Record Macro button only produces script. Is there another way to get VBA recording?MISSING FUNCTIONS THAT I PREVIOUSLY HAD ACCESS TO
I just switched macbooks and opened my excel to discover I had a few missing functions: MAXIFS, SEQUENCE. This is not a problem regarding the software as mine is MICROSOFT365 and I used the same account previously. Is there any way I can gain these functions back! Thank you!Getting started in Excel Labs Custom Modules (missing "publish" step)
First-time poster — please be gentle! Context Excel for Mac I have a large library of LAMBDA formulas and wanted to manage them using Excel Labs In particular, I wanted to organise formulas into custom Modules Issue How to actually activate functions defined in custom Modules in Excel Labs I recently discovered Excel Labs and was very excited to use it to manage and structure a large library of LAMBDA formulas. My goal was straightforward: create custom Modules to organise formulas by purpose, and then use those formulas in the workbook. However, it took several hours of experimentation and debugging — even to get a trivial example like: ABC() = 12 to work when defined in a custom Module. The missing piece (which Copilot, Google searches, and the README all missed) is this: Functions defined in custom Excel Labs Modules are inert until the module is imported into the special Workbook module. Until that import step occurs, functions in custom Modules: do not appear in Excel Labs → Names do not appear in Formulas → Name Manager are not callable from the grid According to Copilot this behaviour is not currently documented, and the UI strongly suggests that custom Modules are “active” by default — which they are not. Working workflow (for others who hit the same issue) This is the workflow that finally made things work for me (possibly sub‑optimal, but reliable): Create and maintain functions in custom modules (e.g. Transformations) Explicitly import the required functions into the Workbook module, e.g.: TransformAtoB = Transformations.TransformAtoB Workbook module now publishes to: Excel Labs → Names Formulas → Name Manager This makes conceptual sense — maintain a large structured library of formulas (or import libraries from GitHub), only activate the formulas required by a particular workbook. But without documentation, it’s very easy to assume custom Modules are active by default. Why I’m posting this When I finally asked Copilot “Why didn’t you say this up front?”, the answer was essentially: This publish step is not documented in the README or the UI, and users are easily led to assume Modules are active by default. So I’m posting here to save others from repeating the same debugging journey. Documentation request It would help enormously if the documentation (README / FAQ) stated explicitly that: Custom Modules are source-only Importing into the Workbook module is the publish step Only the Workbook module is wired to Name Manager and the Excel grid Even a short note would remove a major stumbling block for new users. I’m not a GitHub user, otherwise I would also raise this there — if someone from the community is able to mirror this feedback on GitHub, that would be much appreciated.Can Agent 365–registered 3rd-party agents be invoked outside MS 365 clients and still track usage?
Hello, The documentation describes how to register a third-party agent with the Microsoft Agent 365 platform (for example an agent hosted on Google Cloud Run) in order to benefit from capabilities such as observability, governance, security, and centralized management. Does this mean that users must access these agents through Microsoft 365 entry points (such as Copilot Chat, Teams, or other Microsoft clients) in order for those capabilities to apply? Or can the same registered agent also be invoked and interacted with from third-party clients or external services (for example applications running in GCP) while still benefiting from Agent 365 features like observability, governance and/or security? What if third party agent is registered to Agent 365, but it doesn't use EntraID? It's what observability, governance and/or security will be available then? Thank you.
Formula for Complex Matrices
Hi Microsoft Community Hub, I am excited to share a new method I have developed for solving matrices with complex numbers. As many of you know, handling complex matrix operations in environments like Excel or during manual computation often requires separating real and imaginary parts, which increases complexity and the margin for error. I have conceptualized the formula which streamlines this process by providing a more direct approach. This is a dynamic formula and this formula works for any dimension of matrix (see the screenshot below). =IFERROR( BYROW(TRANSPOSE(WRAPROWS(LET( mat, A2:J11, coef, L2:L11, re, MAP(mat, LAMBDA(a, IMREAL(a))), im, MAP(mat, LAMBDA(a, IMAGINARY(a))), MMULT(MINVERSE(HSTACK(VSTACK(re, im), VSTACK(-im, re))), VSTACK(MAP(coef, LAMBDA(a, IMREAL(a))), MAP(coef, LAMBDA(a, IMAGINARY(a)))))), ROWS(A2:J11))), LAMBDA(a, COMPLEX(TAKE(a,, 1), TAKE(a,, -1)))), "Singular Matrix") Linkedin GitHub I hope this solution helps someone. Best regards, IlirUOBO Agents vs. Execute-as-User Agents: What Will Agent 365 provide?
It was mentioned during the AMA session that agents from the Microsoft ecosystem (Copilot Studio, Foundry, SharePoint) will be automatically onboarded into Agent 365. However, today many of these agents execute as users, and some may continue to operate this way indefinitely. In other words, they may never receive their own Entra ID agent identity and may never run using an On-Behalf-Of (OBO) model. This raises an important question around observability, governance, and security. If these agents do not have their own identity and continue to execute under user credentials, what capabilities will Agent 365 provide for them in terms of monitoring, governance, and security controls? TL;DR: It is still unclear what observability and governance features will be available for non-OBO agents - both within Agent 365 itself and through standard platform administration tools. A clear comparison between OBO agents and non-OBO agents in terms of visibility, governance, and security capabilities would be extremely helpful. Thank youCreating weekly calendar template that has overlapping positions
Hi, I have a software for individuals to sign up for shifts, but it is visually hard to see where there are open areas that need to be filled. I need help creating a calendar from this software download that I can update each week. It would have to be much like an hourly scheduler view to easily see when someone is coming on and off shift. But also laid out from Sun-Saturday. There is 3-4 "slots" for each day. It would be great if they could be color coded as well. Slot 1 needs to be anyone that is "AEMT" in the position column, Slot 2 can be anyone listed as "EMT" or "EMR" (caveat to this would be that slot 2 could also be AEMT if there is already an AEMT in slot 1 for the same time slot. Slot 3 is for driver or ride along (or the other 3 positions if there is one listed in the other slots), and possibly 4th slot would just be overflow in case there were 4 people signed up which does not happen very often. Is there anyone who can help me with designing this? Below is what the software generates when converting to excel
Could Agent 365 end up being just central observability platform without needing per user licenses?
Since Agent 365 allows bringing in both first-party and third-party agents, I’m curious about the identity and licensing model. If an agent is not using an Entra Agent Identity, will it still appear in Agent 365 observability or governance? In other words, could organizations use Agent 365 mainly for central visibility, monitoring, and governance of agents, even if those agents don’t have their own identities? And if that’s the case, does it mean companies could avoid needing a per-user Agent 365 license for every employee interacting with the agent? In summary if a company doesn't need OBO features, just central visibility, can they still benefit from Agent 365?Agent 365 - can it be used just as a Governance platform for non-OBO agents?
It was mentioned that Agent 365 will allow to combine first-party, partner and third-party agents. Does this mean organizations could use the platform mainly for central visibility and governance of agents, but not necessarily for agent identities, effectively avoiding the need to pay a per-user license for everyone interacting with the agent?
Events
You’re passionate about what you do, and we’re passionate about empowering your potential. Microsoft 365 Community Conference - is your chance to keep up with AI, build game-changing skills, and take...
In-Person
Recent Blogs
- 2 MIN READOne of the best ways to get value from the Microsoft 365 Community Conference isn’t just attending sessions, it’s helping shape what gets built next. The Research sessions at Microsoft 365 Communit...Apr 10, 2026
- Inspired by real work, this video series will show you how Copilot can help you with everyday tasks.Apr 10, 2026
