Recent Discussions
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 basis
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.Creating 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
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/
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.
Spellcheck Not Working for Some Words?
I have a workbook with misspelled names like Tangirs, Manilla, Aisa, Santigo. These are places. Spellcheck caught Tangiers but missed Manila, Asia, and Santiago. Any idea on what's going on and how I can prevent this? These words seem obvious. Full Name Region and Sub-Region Bonita Sykes North America - New York Cairo Pemberton Aisa - Manilla Chante Devlin Africa - Tangier Erica Prince Europe - Santigo Florrie Greenaway North America - Chicago Frederic Holman Europe - London
Excel Macros Spreadsheets Not Loading
I've spent some time with Microsoft Support (almost 3 hours, including uninstalling my MS 365 and reinstalling it), but I'm having an issue with my Excel Macro spreadsheets not loading at all. This is what I get each time. Also having an issue with non-Macro spreadsheets that I'm unable to use the Bold, Italic, and Underline functions (get the spinning wheel and then Excel Not Responding), as well as not able to use the Format function (get the same spinning wheel and then Excel Not Responding). I've been using these same Excel Macro Spreadsheets for over 15 years. Please help!
Losing borders in transition from Excel 97 to 2024 Pro Plus
I have a handy appointments calendar (.xls) that has used Excel 97 on a Windows 7 laptop for a long time. I want to run this on my latest laptop that has Excel 2024 Pro Plus on Windows 11. When I open this now, many of the cell borders, most of which are involved with conditional formatting, are either present when they should be absent or absent when they should be present. The calendar is useless as opened. I have worked to reformat the cells, but it has taken me hours to get from January to April and some aspects are still problematic, albeit acceptable. The conditional formatting process is very different between the two versions. Is there some trick to getting newer versions of Excel to properly recognize formatting from older versions? I created this calendar in Excel 97 very easily many years ago. I am not sure I could duplicate it, even from scratch, using Excel 2024.There seems to be a bug in the WORD Index.
Hello, I'm writing a document with an index. There are several Latin based names that require symbols, most notably a small e with an acute accent. The problem name is "Vélez." It will not index correctly putting a separate line for each entry. In troubleshooting the problem, I find that if I replace the symbol "é" with "e," it works okay. Interestingly, the name "Frémont" works okay too. Any ideas?How to Track Changes in Microsoft 365 Groups
An old PowerShell script tracked changes to Office 365 Groups. The techniques from 2016 wouldn’t be used today because features like the unified audit log didn’t exist then. We show what’s possible now by creating a new version of a Microsoft 365 Groups Change Report script to track additions, deletions, and changes for Microsoft 365 groups in a tenant. https://office365itpros.com/2026/04/06/microsoft-365-groups-change-report/A 40,000+ VBA line Block and Stack workplace planning tool made in Excel
Hi all, I’ve been an Excel user for a long time, but until the last 8 months I had never really explored the full power of Excel/VBA. With AI’s help, I’ve been building a workplace Block and Stack planning tool called Work Stack. It’s a niche use case, but a very real one in my industry, supporting corporate office planners, workplace teams, and anyone trying to move and reorganise teams within an office. When I first started, I thought an AI agent would simply be able to generate the answer for me. I quickly realised that wasn’t enough, especially when it came to reliably recreating the block and stack image and handling the planning logic behind it. That was when I decided to build it properly. I have zero coding background, but 15+ years of workplace experience, so the setup became: AI as the code developer, and me as the product owner, logic lead, tester, and relentless breaker of whatever had just been built. I moved very quickly at first and had a “working model” within about 6 weeks. The problem was that it produced all sorts of crazy results and was basically unusable, untestable, and unfixable. That was where I learned some hard lessons about relying too heavily on arrays and not being disciplined enough with separation of concerns. Version 1 was a false start, but a very useful one. I scrapped it and rebuilt the tool properly from scratch. The rebuild took 6+ months rather than 6 weeks, but Work Stack is now at beta stage and is being tested and demoed by industry peers. Attached are 3 images: Image 1 — Current Stack This is a standard desk-sharing workplace stack. It shows teams grouped into functions, some placed in neighbourhood zones, some co-located with other teams (shown with the two-headed arrow), and some “breached” teams shown with a red border where they are sharing desks more aggressively than the building guideline allows (80% in this example). There are also scattered spare desks shown in white blocks at the end of floors. As teams move, the team blocks, floors, and footer totals all recalculate automatically. Image 2 — AutoStack Output This is the result of running the most complex feature in the tool: AutoStack. It assesses the current stack and then restructures it based on the user’s instructions. In this example, I asked it to fix all breached teams, reunite teams with their function groups, dissolve neighbourhood zones and co-locations, and consolidate spare desks where possible. Something that would normally take a space planner weeks of effort can now be done by VBA in Excel in seconds. That part still blows me away. Image 3 — Stack Editor This is the main parent form, called Stack Editor. It acts as the control hub for creating, editing, and customising the stack. At the moment it has 37 features and counting. Under the hood, the rebuilt version is structured far more seriously than the original. It uses an object-oriented VBA model built around core class modules for the plan, floors, and teams, with supporting classes for things like zones, functions, financials, and rendering. In other words, the stack is modelled as real objects rather than just spreadsheet rows. I also rebuilt it with much stricter boundaries between logic, persistence, rendering, and UI. That discipline is what made the second version stable enough to keep growing, and it is a big part of why the codebase has now grown to 40,000+ lines without collapsing under its own weight. I mainly wanted to share this with people who might appreciate this very specific use case in VBA. At some point I may need to port it to Python or something similar, but for now I’m honestly amazed at how far this 30-year-old language can be pushed.Disabling Copilot in Forms not possible
Hi everyone, Not sure if this has been addressed before - I couldn’t find anything about it in this forum. Since Copilot is now integrated into Microsoft Forms, there doesn’t seem to be any option to disable it (like in Word, Excel, Powerpoint). What I find frustrating is that every time I open a previously saved form, Copilot automatically runs checks and generates recommendations—which, in my experience, aren’t particularly useful. More concerning is that this process does consume AI credits. I'm on a personal plan with 60 credits, I’d prefer to have control over how and when those are used, rather than having them spent automatically on features I didn’t explicitly choose to use. Microsoft support has confirmed that there’s currently no way to turn Copilot off in Forms. Is anyone else experiencing this, and isn't this something Microsoft should address? Thanks!Index not formatting correctly when using the Latin Symbol small letter "e" with acute
Hi, I'm writing a document with Latin based names that require symbols and creating an index. I am having trouble with the index in regards to the name "Vélez." It gives multiple entries instead of one entry with with all the page numbers and subentries. In troubleshooting the issue, I find that if I replace the "é" with "e" in the entry field, it works like it should, but then the name is incorrect in the index. Another name, using the Latin small letter "i" with acute (í) also works fine in the index. Seems to be a bug, but does anyone have any ideas?
outlook.office.com
I canno´t login in to outlook.office.com. Get the error message: UTC Date: 2026-04-05T10:38:19.885Z Client Id: C0B69CD1666C4BDCAD56171753860EF7 Session Id: e31a271e-c7b2-4f5f-abb5-854f463bfe2a Client Version: 20260320002.12 BootResult: configuration Back Filled Errors: Unhandled Rejection: Error: 500:undefined|undefined:undefined err: Microsoft.Exchange.Data.Storage.TenantAccessBlockedException esrc: StartupData et: ServerError estack: Error: 500 at Object.y [as createStatusErrorMessage] (https://res.public.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.mailindex.ad50be7b.js:2:299099) at https://res.public.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.mailindex.ad50be7b.js:2:23784 st: 500 ehk: X-OWA-Error efe: GV2PEPF0002396F ewsver: 15.20.9769.16 emsg: TenantAccessBlockedError And outlook on my devices don´t sync to exchange server Need some serious help/rzs43
Copy content of a locked file
I have a team of transcribers; I send them images, they send me back a locked WORD documents. I CAN unlock it, but prefer not to. But I need to COPY the content and past it into my own document. "Locking" should allow copying; it should only prevent changes. BUT - sometimes Ctrl-A Ctrl-C in theirs and Ctrl-V in mine does work. And sometimes it does not ! Q1: What am I doing wrong, and what am I doing right ? Q2: If I have to unlock it, how do I re-lock it ? Or does it stay locked if I don#t save it ?
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
