Recent Discussions
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.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.
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 basisMISSING 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.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
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
