Recent Discussions
Chart from dynamic array challenge
Hi (Excel 365 v2512 b19530.20144 Current Channel / Windows 11 25H2) Charts are definitively not my thing. Spent hours on the following, searching, testing… to no available The below chart data range is a dynamic array (could be wrong for the desired chart) - named GRAPH_Series on sheet GRAPH_Ranges - similar to the array on the left side of the pic. The arrays dynamically resize according to the 'START Year' & 'TOPN Cat' variables - so far so good Setting the Chart data range as =GRAPH_Ranges!GRAPH_Series and changing nothing else the chart updates as expected according to the 'START Year' & 'TOPN Cat'. On the other hand if I change anything in the Select Data Source dialog box the chart won't update properly anymore The expected chart is the same as above with 2020, 2021...2025 (instead of 1, 2,...6) horizontally & D, F, B, A as legend (instead of Series1, Series2...Series4) Thanks & any question please let me know Lz.
Office v2508 feature update (new vbe7.dll) breaks library compatibility with LTSC VL versions
Since the Jan 2026 updates, some `accde` or `mde` libraries built with the semi-annual enterprise channel (v2508, Build 19127.20484) can no longer be used with the volume-licensed version of Office LTSC (tested with the Jan 2026 release of Office 2024 LTSC VL, v2408, Build 17932.20638). The reason for this seems obvious: The v2508 feature update contains an updated vbe7.dll. Apparently, this change is backwards-compatible (code compiled with the old dll will run with the new dll) but not completely forwards-compatible (code compiled with the new dll might not run with the old dll, even if the new RegExp class is not used). That's a problem for us. We can't just tell our customers to upgrade, because those with an Office 2024 LTSC volume license already use the latest version available to them. Does Microsoft consider this a bug or "by design"? If the latter, what is Microsoft's recommendation for software vendors who want to build software that runs on all currently-supported versions of Access? We currently plan to work around this issue by installing v2502 of the semi-annual enterprise channel on our "build VMs" (32 and 64 bit) and use those to build our software. (Reverting dev machines to an old Office version is not an option for obvious security reasons.) Repro On a PC with v2508 or newer: 1. Create a new mylibrary.accdb with a module with the following code: Public Function GetColorCode() As Long GetColorCode = vbRed End Function 2. File/Save as/Create accde. 3. Copy mylibrary.accde to a PC with v2507 or older (for example, with the current version of Office 2024 LTSC volume license). On a PC with v2507 or older: 4. Create a new database. 5. Create/Module/Tools/References 6. Add a reference to mylibrary.accde 7. Add the following code to the module: Sub Test() Debug.Print GetColorCode() End Sub 8. Debug/Compile Expected result: The database compiles. Actual result: "Compile error: Can't find project or library". The "references" window opens automatically and highlights "mylibrary". Notes We are not library developers, but we are still impacted by this issue, since the software we ship consists of a (modifiable) startup mdb referencing an (unmodifiable) mde containing the business logic. If you want to try to reproduce this issue but don't have a volume license of Office 2024 LTSC lying around (we certainly don't), you can install a trial version with the Office Deployment Tool and the following configuration file: <Configuration> <Add OfficeClientEdition="64" Channel="PerpetualVL2024"> <Product ID="ProPlus2024Volume"> <Language ID="en-us" /> </Product> </Add> </Configuration>
Excel pads dynamic array output with #NV values
I have come across a couple of instances, where Excel 365 pads the output (of lambdas) or in this case of a specific formula within a lambda with #NV values (or errors if you like to treat them so.) The following snippet: = LAMBDA(assemblyName; LET( filteredParams; {"a";"b";"c"}; mappedValues; {1;2;3}; transposed; MTRANS(HSTAPELN(filteredParams; mappedValues)); return; WENN(filteredParams = ""; "NV"; transposed); return ))("fake") Gives me the following output: a b c 1 2 3 #NV #NV #NV At the same time, the following slightly different code (letting alone the output of WENN): = LAMBDA(assemblyName; LET( filteredParams; {"a";"b";"c"}; mappedValues; {1;2;3}; transposed; MTRANS(HSTAPELN(filteredParams; mappedValues)); return; WENN(filteredParams = ""; "NV"; transposed); transposed ))("fake") Spits out: a b c 1 2 3 This is not the only case, but is the simpliest, I can reconstruct this kind of error with. Do not mind the logic, it is an edited excerpt, just for illustration. P. S. It is German syntax. English would have TRANSPOSE, HSTACK, IF,... instead. Maybe a little difference in punctuation.Generate a Weekly Report of Role Assignments
This article explores how to use Entra ID audit records to create a weekly report about role assignment additions and deletions. After deciphering the information contained in the audit records, it’s easy to generate a report showing who made the assignments and if any critical role assignments are in the mix. We can then email the report to interested parties, all with some relatively simple PowerShell. https://office365itpros.com/2026/01/21/role-assignment-weekly-report/Practical Graph: Find Large Mailbox Items with the Microsoft Graph PowerShell SDK
Server-side filtering is always best when PowerShell retrieves items from the server. In this article, we explore how to construct a server-side filter to find large mailbox items over a certain threshold. The answer lies in filtering against an old Outlook property. The Graph represents the property through the single value extended property resource. But how do you filter against such a thing? https://practical365.com/find-large-mailbox-items/Managing External Sharing in Microsoft 365 Without Chaos
External collaboration is no longer optional. Vendors, partners, clients, and contractors all need access to files, Teams, and sometimes even entire SharePoint sites. Microsoft 365 makes this easy—but too easy if it’s not governed properly. Unchecked external sharing can quickly turn into chaos: sensitive documents shared with the wrong people, anonymous links floating around forever, and zero visibility into who has access to what. The good news is that Microsoft 365 provides powerful controls to balance collaboration without compromising security. This article walks through how to manage external sharing in Microsoft 365 effectively, with clear technical steps, best practices, and real-world governance tips. https://dellenny.com/managing-external-sharing-in-microsoft-365-without-chaos/Synchronizing Security and Microsoft 365 Group Memberships
An article from 2018 uses the AzureAD and Exchange PowerShell modules to synchronize membership between a security and a Microsoft 365 group. The idea is to enable collaboration for the members of the security group. This version does the work with the Microsoft Graph PowerShell SDK. The code is better and it will work as an Azure Automation runbook, which is always nice. https://office365itpros.com/2026/01/20/group-membership-synchronization/
Microsoft Places desk declined despite check-in
Each We've just started using Places in our office and a few users have reported recieving a desk decline email due to no check-in on the desk, despite them using the check-in button on the Places app to check-in on arrival to the office. Has anyone seen this previously? Each desk has two monitors, which I have associated with the desks in the Teams Pro Management portal to enable detection and check-in. Reservation settings for all desks are as below.How to Create SharePoint Sites with the Graph API
Microsoft released the beta version of the SharePoint Online create Site API for the Microsoft Graph in late November 2025. Since then, Microsoft has dropped one of the three site templates. Playing with the API, we’ve discovered that the API can certainly create sites but that the SharePoint Graph API misses a heap of features, like adding members to the new site. Oh well, one step forward… https://office365itpros.com/2026/01/19/create-site-api-spo/Some Microsoft Graph PowerShell SDK Cmdlets Lose Body Parameters
A change made for some Directory Graph APIs has flowed through to the Microsoft Graph PowerShell SDK and affected how the associated cmdlets work, including the beta cmdlet to restore a deleted user account and while replacing the user principal name. Fortunately, the workaround is easy, but it is upsetting when something that worked suddenly doesn’t, even if it is a beta cmdlet. https://office365itpros.com/2026/01/16/restore-deleted-user-account-sdk/Purview eDiscovery Simplifies Content Searches in February 2026
As part of the modernization of the Purview eDiscovery solution, Microsoft will simplify the content searches UX in February 2026 to remove features that are inappropriate for the way that content searches are intended to be used. The change is logical and reasonable because you should use a full eDiscovery case to access all the eDiscovery functionality. https://office365itpros.com/2026/01/15/content-searches-change/Teams External Collaboration Administrator Role Arrives
Microsoft is introducing a new Entra ID role. The Teams External Collaboration administrator role allows users to manage external collaboration settings. Quite how often Microsoft 365 tenants need to manage these settings is unknown, but it’s a useful prompt to review the current set of roles used and users who are members of those roles. Time for an annual clean-up. https://office365itpros.com/2026/01/14/new-entra-id-role/SharePoint Site Administrators Can Now Control Restricted Content Discovery
Restricted Content Discovery (RCD) is a feature that blocks access by Microsoft 365 Copilot and agents to the files stored in a SharePoint Online site. Instead of relying on tenant administrators, site administrators can now enable or disable RCD. It’s a natural evolution of what is an essential feature to keep sensitive and confidential information being leaked inadvertently by AI. https://office365itpros.com/2026/01/13/rcd-site-level/Web-Addins stopped working for Office apps version 16.100 for Mac
Dear experts, Since version 16.100, the web add-in functionality has stopped working with the Office apps for Mac (PowerPoint, Word and Excel). In may case, Templafy web add-in is not being loaded. According to Templafy's support page: https://support.templafy.com/hc/en-us/articles/29028257609501-Templafy-Web-Add-ins-no-longer-accessible-on-Mac-after-Microsoft-Office-update-16-99 this seems to be a bigger issue. Clearing web add-in cache or deleting the WEF folder will not resolve the issue. I have also tried with a full clean uninstallation of Office365 apps and re-installation, same issue. Note that New Outlook for Mac is not affected, just PowerPoint, Excel and Word.Entra ID Rationalizes Session Revocation for User Accounts
Microsoft is rationalizing the options to revoke sessions for a user account in the Entra admin center by removing an old revoke MFA sessions button. That seems like a perfectly reasonable thing to do. When administrators want to revoke sessions for an account, the best way is to create a PowerShell script to perform the necessary steps. That way you don’t need to worry about buttons. https://office365itpros.com/2026/01/09/revoke-sessions-button/How to Design a Future-Proof SharePoint Information Architecture
A future-proof SharePoint Information Architecture balances business needs, user experience, and technical scalability. In this blog, we’ll explore what future-proofing really means, common pitfalls to avoid, and step-by-step technical guidance to design an IA that stands the test of time. https://dellenny.com/how-to-design-a-future-proof-sharepoint-information-architecture/Priority Cleanup for SharePoint Online and OneDrive for Business Is Generally Available
Priority cleanup is a Microsoft Purview solution that allows tenants to remove items even when the items are subject to retention hold. That sounds like Priority cleanup goes against the nature of data governance, but sometimes it's more important to remove items than to keep them for their full retention period. This article explains how Priority Cleanup works and some of the important concepts that you need to master before removing anything. https://practical365.com/priority-cleanup-for-sharepoint/
31.25% Increase
I have just received an email from Microsoft notifying me that my 365 account subscription will increase from £79.99 to £104.99 on 14th February - a 31.25% increase! So, this is either a dud email or Microsoft really does want to lose more of their customer base. What a bunch of crooks!SharePoint vs Teams vs OneDrive: When to Use Each (and When Not To)
If your organization uses Microsoft 365? then you have gone through the pain point of which tool to use “Should this live in SharePoint, Teams, or OneDrive?” At first glance, all three tools seem to do the same thing store files, share documents, and help people collaborate. But using the wrong tool in the wrong situation can quickly lead to duplicated files, messy permissions, frustrated users, and lost productivity. This blog breaks down what SharePoint, Microsoft Teams, and OneDrive are actually for, when to use each one and more importantly when not to. https://dellenny.com/sharepoint-vs-teams-vs-onedrive-when-to-use-each-and-when-not-to/SharePoint Online Dumps Legacy Compliance Features
MC1211579 (3 January 2026) announces the retirement of four legacy SharePoint compliance features in favor of Purview Data Lifecycle management and Records management. It’s always unsurprising when Microsoft chooses to remove old features developed for on-premises and replaces them with better online options, which is exactly what’s happening here. Some tenants might face additional licensing requirements for Purview. https://office365itpros.com/2026/01/05/sharepoint-compliance-legacy/
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
- Microsoft Copilot can help you entertain family, get in the winter spirit, and make the most of this season.Jan 21, 2026
- 4 MIN READClipchamp reached new levels of innovation and enabled increased productivity in 2025!Jan 16, 2026
