Recent Discussions
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?Using the Microsoft 365 Connector for Claude
The Microsoft 365 Connector for Claude allows Claude to access SharePoint and OneDrive files, emails, and Teams chats and meetings. The connector is now available to all users, including the free tier for Claude. Installing the connector creates two Entra ID enterprise apps (MCP server and client) and channels Graph requests to Microsoft 365 to fetch information for processing by Claude. Is that a good thing? https://office365itpros.com/2026/04/08/microsoft-365-connector-for-claude/Office Script - Bug in .map()?
Hi, I'm pretty sure this is a bug, but maybe I'm doing something silly when constructing the formula? I'm trying to set formulas down a column in a table, from an array called test1. The test1 array is created using .map() from an original array (file_names) that uses .getTexts from another column in the same table. The dimensions of target_range (another column in the same table) match those of test1 array. The test1 array is appropriately 2D (i.e. [[formula1],[formula2]...[formulaN]]. The test1 array is correct when inspected in console.log() (in all cases, including when an equals sign is used.....explained more below). The problem is that trying to use .setFormulas, is only using the first value from test1 for every cell in target_range, not each respective element from test1. After a massively frustrating amount of time, I've traced the problem solely to this (as far as I can tell): The presence of an equals sign in the .map() when using string interpolation to create the formula. This code correctly writes the text of the formula into each cell of target_range, using each respective value from write_array with appropriate interpolation: let file_names: string[][] = rng_file_names.getTexts(); let test1: string[][] = file_names.map( row => [`\"${row}\"&\"TestString\"`] ); target_range.setFormulas(test1); If you try to do exactly the same, but try turning it into a formula by including the equals sign at the start of the interpolated string inside the array returned by the .map(), it will only write the first value of test1 into all cells of target_range: let file_names: string[][] = rng_file_names.getTexts(); let test1: string[][] = file_names.map( row => [`=\"${row}\"&\"TestString\"`] ); target_range.setFormulas(test1); I'm pretty sure this is a bug, but if someone can point if I'm doing something stupid, it would be appreciated!PCLaw Cloud Hosting: Secure and Flexible Legal Practice Management in the Cloud
Cloud hosting for PCLaw is transforming how law firms handle billing, accounting, and case management by moving traditional server-based systems into a secure, accessible cloud environment. Instead of relying on in-house servers, firms can run PCLaw on remote infrastructure and access it anytime, from anywhere. Traditionally, PCLaw operates as a desktop-based application that requires dedicated servers and ongoing IT maintenance. With cloud hosting, the same software is delivered through a virtual desktop or private cloud, eliminating the need for hardware management while preserving full functionality. This allows legal professionals to work seamlessly across devices, whether in the office, at home, or on the go. One of the biggest advantages of PCLaw cloud hosting is improved accessibility and mobility. Attorneys and staff can securely access client data, billing systems, and case files without relying on complex VPN setups. Cloud environments also enhance collaboration, enabling multiple users to work on the same data in real time. Security is another major benefit. Cloud-hosted PCLaw environments use encrypted connections, secure data centers, and automated backups to protect sensitive legal information. This reduces the risk of data loss due to hardware failure or cyber threats while ensuring compliance with industry standards. Additionally, cloud hosting reduces IT burden and costs. Service providers handle updates, maintenance, and support, allowing law firms to focus on client services instead of infrastructure management. It also offers predictable monthly pricing, making budgeting easier. Scalability further enhances its appeal, as firms can easily add users or resources as they grow without investing in new hardware. For law firms seeking a modern, reliable solution, Apps4Rent offers secure PCLaw cloud hosting with expert support, high performance, and flexible plans designed to meet the evolving needs of legal professionals.
2 spacing after every full stop of a sentence
Hi, I believe the old norm is to have two spacing after the end of a sentence before starting a new sentence. But nowadays many people are using only one spacing. I need to try to make it a consistent way to follow. Is there an easy way to scan through all the document and make sure changes are applied to follow at least one norm.
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
- 6 MIN READThe Microsoft 365 Community Conference is back in Orlando, April 21–23, 2026, and it’s once again the place to learn, connect, and go deep on what’s next for Microsoft 365. Earlier this month, we c...Apr 08, 2026
- AI-powered community agents help communities speed up answers and reduce repetitive work for admins.Apr 07, 2026
