Recent Discussions
Exchange online retention policy
Hello, We are using Microsoft Purview to setup an Exchange retention policy through Data LIfecycle Management. We are wanting to do a gradual rollout, we don't want do apply it to everyone all at once. It looks like in the policy settings you can apply it to individual mailboxes. I'm wondering if we can instead setup a mail-enabled security group and add users to that for the policy to apply to them. Is that possible? Thanks in advance.
Distribution List & Security Group
I need a group that is a distribution list (so we can send emails to members of the group) & a security group (so I can assign the group to intune policies). How do I accomplish this? I don't want to just create the security group as our memebers don't like to go to groups in Outlook to check for email, they rather have it in their inbox... TIA, JBookings Page not sending confirmation emails to customers
Hello, I am the main technician for my company's service desk. We have a Bookings page, but any time anyone books a time slot, they receive a message indicating that they will receive a confirmation email, but no email comes to them. In the settings, it shows the checkbox to send a confirmation email is checked. I have also looked in Exchange Admin and run a message trace and cannot find any confirmation email sent to myself or other testers. In Bookings, I have unchecked the confirmation email checkbox, saved, checked, saved, and tested - same result. Additionally, this Bookings page is only for internal users, and all of them are 'customers' with their full organization email address. In researching, I found that there was mention of the Bookings needing to have an Exchange account as a shared mailbox, which I do not believe we have - when I search the email that confirms for me that someone has booked with me, it is a long string of seemingly random letters and numbers with an internal domain address. I have also tried searching in Exchange Admin for 'IT' 'Service Desk' 'Service', and 'Desk', none of which have any results under Mailboxes (which would include shared mailboxes). Any advice/suggestions would be greatly appreciated. Screenshot:
Excel formel
I am going to, have the same date pasted in about 50 places for labels. Request: I did Create a cell, AL2 - wrote, 27 Oct Then I want to create a formula in the 20 different places, that picks up 27 Oct from AL2, from the same Excel sheet. I have tried =!AL2, =$AL2... etc. but nothing works 🙁Formula help - daily pay vs supplement monthly payments
Hi all, I have two sets of data for bonus calculations. SET ONE is in multiple rows by employee, e.g. the annual pay from 1 Jan to 31 Mar. Then 1 Apr to 31 Dec - when their pay has changed from 1 Apr onwards. And then a count of the number of days per row. I use this count to calculate the annual bonus. SET TWO is any annual supplement paid, by calendar month, that I need to split by days relevant to their pay in SET ONE and add to their salary for that period. So how can i take the data in SET TWO, and split by the same time period in SET ONE - and cut the Supp Amount and add to the Supplement Row column, thus updating the Total Paid column? I have 2k employees to calculate e.g. ThanksHow to Control Access to Entra Multi-Tenant Apps
Entra multi-tenant applications can be used by any tenant – unless you restrict sign-in audiences to permit only specific tenants to use the application. In this article, we explain the preview feature and use the Microsoft Graph PowerShell SDK to restrict sign-in audiences by defining a list of permitted tenant identifiers in the properties of multi-tenant applications. https://office365itpros.com/2026/01/28/restrict-sign-in-audience/
CANNOT OPEN THE SPECIFIED FILE with tel:-hyperlink
Hi, I have several "tel:" hyperlinks in a Excel sheet (xlsm). Yesterday, they sended the phone numbers to whatsapp. But today i become the errer:"CANNOT OPEN THE SPECIFIED FILE". I saved yesterday a xlsx file as xlsm, after the conversion, the links were still working. What goes wrong?
Not able to count with COUNTIFS
I am having problem counting with COUNTIFS In a column of an Excel table =TEXT([@[Date: Referral Rx]], "mmmm") This shows the month in the column Then, I am counting the total of those in the current month with the following code: =LET( targetDate, TEXT(TODAY(), "mmmm"), COUNTIFS( Table[Month: Initial Referral Rx], targetDate ) It is not counting it. I get 0. I tried COUNTIFS(Table[Month: Initial Referral Rx], TEXT(TODAY(), "mmmm")) It also didn't work. Need help. Thank you in advanced.
Top n vs. Others in Excel
Hi all, I'm seeking some help because I'm kind of new to the more intermediate stuff in Excel. I have an Excel table with the following columns: Subcategory in column A, Brand in column B, Region in column C, Year in column D and Values Month in column E. I want to create a PivotTable and a Pivot line chart from this PivotTable that ranks the Top 5 Brands vs. Other Competitors by each region. For added context: There are 5 subcategories, 3 regions and 25 brands. Currently, I've tried grouping the remaining 20 brands as "Other Competitors" vs. the Top 5 brands within a selected region and possibly all regions (when no selection is made). I'm seeking a solution similar to this... Please mind the colours. I will sort those out later. But, the problem that I'm faced with is that upon selection of a region, the PivotTable won't update to the Top 5 brands of a selected region because they've already been grouped. How can I make this more dynamic so that I'm able to show The Top 5 brands vs. Others? Please help. EDIT: My operating system is Windows 10 (64-bit) and I use Excel 365 (Desktop version). For reference, I've attached a link to a sample file. https://1drv.ms/x/c/b2d878e32a062614/IQC1wcnwLICcQasOfnGcwKn0ASjpXp9xQ6rjnOP10Jal5cc?e=HaXEWd Thank you all once again.
Asian and Latin fonts
I have documents which are a mix of Asian and Latin fonts and I am having difficulty with footnotes and endnotes. Their numbersare in roman numbers and can be used in the midst of both the Asian and the Latin text passages. The first difficulty I have encountered is if I want to change the Asian font style say by increasing the font size then when I try to do this the footnote/endnote numbers change font size as well For example I start with font size 18 then I change the font style on only the asian font part using a style which puts the asian font to size 10 , but the asian font does not change but the Latin font does Clearly something is not set correctly - but what? My second question is regarding the Font dialog - this is how I currently have it set. But I am not entirely sure what the boxes marked actually do and would much appreciate clarification and each and/ or good tutorial link for using mixed font registers in general.AVERAGE reduced lambda on GROUPBY or BYROW formulas not working on specific workbook.
Currently using excel with spanish formulas. When using GROUPBY formula, i can use SUM, PRODUCT, LAMBDA, however AVERAGE (PROMEDIO) won't work on a specific workbook which previously has a lot of GROUPBYs that work properly. When I update the previously working formula, it now returns NAME error and PROMEDIO turns into Promedio. Inserting the function looks like this: I have no custom name called Promedio. This same GROUPBY formula works in different workbooks. Help would be appreciated. Best regards
Help with a Formula
Below is a formula I created to return specified rows and columns for a sheet named Detail and in the case or column 49 detect if there are comma separated values and explode them into separate columns. The formula works when there Is not comma separated values and returns and error #VALUE! instead. Can someone help me with this formula? =LET( f, FILTER( Detail!$A:$BZ, (COUNTIF($B$16:$B$25, Detail!$BP:$BP) > 0) * (TRIM(SUBSTITUTE(Detail!$AW:$AW, CHAR(160), "")) <> "")), base, CHOOSECOLS(f, 1,3,4,5,68),split49,TRIM( TEXTSPLIT(SUBSTITUTE(CHOOSECOLS(f,49), CHAR(160), ""),",")), split53,TRIM(TEXTSPLIT(SUBSTITUTE(CHOOSECOLS(f,53), CHAR(160), ""),",")), SORT(UNIQUE(HSTACK(base, split49, split53)),1, TRUE))
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 "IF" function
I'm creating a spreadsheet for my golf club. We have special rules. One of them is that if a player has fewer than 30 Stableford points after a round, their handicap increases by 1 point. Can I do this with an "IF" function? And what would that look like? I have separate columns for stableford points and handicaps.Font issue Inter in PowerPoint
Hi everyone The font "Inter" in PowerPoint incorrectly displays some special characters (ß, –, —) when exported as PDF. It shows correctly in PowerPoint and only displays as "No Glyph" when exported. As the letter "ß" is commonly used in German, this is a noticeable problem for us. The phenomenon is happening on all checked company devices, in the desktop software and browser version. I deleted the font multiple times and installed different versions (variable and static from Google and GitHub). We only use the light weight, but it also happens in the other weights. Does anyone have any idea why that is and how to fix it? I'm thankful for any hints! Nele Microsoft 365 PowerPoint Version: 16.101.2 (25092825) for Mac Mac Tahoe 26.1 (25B78) Chrome Version 144.0.7559.97 (Offizieller Build) (arm64)
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
- We celebrate National Data Privacy Day by spotlighting our long-standing commitments, and the choices and protections available to you.Jan 28, 2026
- 3 MIN READAgent Mode in Excel is now generally available in Excel on Windows and is rolling out to Excel on Mac, as well as the full Power Query experience in Excel for the web, and more this month!Jan 27, 2026
