Recent Discussions
Unprotect in Office Scripts
I am writing an office script that requires sorting on a sheet with the overall sheet protected and specific cells not protected. I need to be able to sort an unprotected range using an automation but the protection is restricting it even though I have "sort" allowed in the protection options. Is there a way to unprotect and then re-protect the sheet as part of the scripts? Including passwords? function main(workbook: ExcelScript.Workbook) { let selectedSheet = workbook.getActiveWorksheet(); // Clear auto filter on selectedSheet selectedSheet.getAutoFilter().clearCriteria(); // Custom sort on range range C9:I6001 on selectedSheet selectedSheet.getRange("C9:I6001").getSort().apply([{key: 0, ascending: true}], false, true, ExcelScript.SortOrientation.rows); // Apply values filter on selectedSheet selectedSheet.getAutoFilter().apply(selectedSheet.getAutoFilter().getRange(), 6, { filterOn: ExcelScript.FilterOn.values, values: ["1"] }); }
How to make a chain selection with drop-down lists
What formulas can be used to generate a chain of filters from a selection of data that, in turn, filters the data again until a specific element is selected? For example: I have lists of various pieces of equipment categorized by type, brand, and model, and what I need is to select them in stages. That is, I position myself in a cell that displays a series of data from the "type" matrix (a long list located on another sheet). When I select a piece of data, the next cell only shows me the list of data, but also the previous cell from a list on another sheet. And in turn, the next cell shows or displays the list from the selected cell. It's a chain filter where each selected piece of data depends on the previous one.
Android Teams login fails during ADFS federation with SSL error
Hello Android mobile users cannot sign in to Microsoft Teams The login fails during the ADFS federation step due to an SSL error Environment Android OS versions 10 to 14 Microsoft Teams mobile app Entra ID federated with on premises ADFS ADFS service URL is masked Public certificate issued by Sectigo Issue description After entering the account in Teams the sign in process redirects to ADFS The page does not load correctly and shows infinite loading or a blank screen The same account works normally on PC browser PC Teams and Outlook Web The issue occurs only on Android mobile apps that use WebView Android log summary OAuth2 WebView client received SSL error Primary error SSL untrusted Wildcard certificate for masked domain Certificate issued by Sectigo Public Server Authentication CA Troubleshooting performed Device date and time verified Teams app cache cleared and app reinstalled Issue reproduced on multiple Android versions and devices PC authentication works with the same certificate Questions Can Android WebView or Microsoft mobile authentication fail with SSL untrusted when the ADFS server does not provide a complete certificate chain Is full chain certificate configuration required on ADFS IIS for mobile authentication Can SSL inspection or proxy interception cause this issue only on Android apps while PC browsers work normally Are there official Microsoft recommendations for certificate configuration when using ADFS federation with Android mobile apps Additional information The same behavior occurs in other Microsoft mobile apps The suspected causes are incomplete certificate chain or network SSL inspection Thank you
Chart linking with Name Manager
so it's known chart behave different than other items, i linked it to a box that indirect the limit of which it should take values from a column, like i used this code to do it: =OFFSET('Study '!$F$25,1,0,'Study '!$BD$26), but this fails when i want it to take starting and ending limit with offset command, it just re input values, like if i want beginning to be 100 and ending to be 300 it reads first 100 and then reread them plus the extra 200 so i have 400 values. is it possible to make it so from column F it starts taking values from lets say box BC and the ending limit to be from BD? i tried looking it up and figuring it but you know how it goes with chartsIs there an acceptable method to convert pub to docx?
Unfortunately Microsoft has decided to end Publisher. So users are forced to find methods both for archiving old files and converting current files to be able to continue working. For the first PDF will most likely be the easiest. For the second I've been trying to find a converter. This proves to be a challenge. And the results have been very unsatisfactory so far. My main publication is a brochure which is printed double-sided on A4 paper, stapled and then folded to A5 size. The publication contains 99% text boxes (with formatted text) and pictures. Here and there a shape like a horizontal line. All things that Word definitely supports. So converting it should be a no-brainer - at least I thought so. Of course Publisher can save as DOCX. Unfortunately the function only supports plain text. So the text boxes are removed, which means a lot of manual rework. Also the text isn't converted continuously. For exapmle the text that was on the first sheet in my Publisher file, ended up on page 5 in Word. Bottom line: not acceptable. Microsoft therefore don't even refer to that save function in their official communication to Publisher retirement. They suggest a workaround instead: save the file as a PDF and open it with Word. The suggestion is embarrassing enough, since it implies that Microsoft are unable to provide suitable conversion between their own formats. I tested it anyway. But the layout ends up in Word in a way that requires a lot of manual rework. Tab stops are partially removed, page margins are shifted. The pagination is also incorrect, so that some pages are half empty. Bottom line: not acceptable. Also tried some online converters. Unfortunately the results haven't been satisfying either. Most of them convert text boxes into shapes with integrated text boxes. And even worse: big text boxes are often split into several smaller boxes. In any case there still remains a lot of manual rework. Bottom line: halfway acceptable. Disappoiting Conclusion: At present, I consider it the best option to rebuild the file from scratch in Word using Copy-Paste. If someone knows a better method, would be happy to hear about it.Index and match mystery (for me that is...)
Hello, I am having a hard time with an Index and match function I created. It's very simple but I am overlooking something. I am creating a file in which I can keep track of my golf progress. In golf you use a handicap system. This means that based on your formal handicap you get a number of extra strokes on a course. For instance: The formal handicap of a player is 21.3 Ranges: From to Course handicap additional strokes 16,4 19,4 3 19,5 22,5 4 22,6 25,7 5 In this example the player is awarded 4 additional strokes based on that 21.3 falls in the range from 19,5 to 22,5. I've created a function but it doesn't always seem to work...It does return a value but not always the correct one.... =INDEX(C21:C36;MATCH(C48;A21:A36+(C48<=B21:B36);1)) In cell C48 people can fill in their formal handicap. In cells A21-A36 the 'from' values of the range In cells B21-B36 the 'to' values of the range In cells C21-C36 the extra strokes for the course handicap What am I doing wrong? Merry Xmas!!!! :-)
Gantt Chart Weekday Function
I am trying to use a gantt chart with conditional formatting for a project. I have my conditional formatting set up the following: =AND($D9<=H$5, WORKDAY($D9-1, $C9)>=H$5) problem is, some of the tasks have a duration of less than 1 day (column C) and so adding the -1 is blanking out several tasks. How do i correct this? I'm just starting to learn conditional formatting so some of this is still like a foreign language to me. Thanks!
Microsoft Forms API
Hello. I currently need to read the number of responses in MS Forms at least once a day. But I can't find the appropriate Graph API. The Power Automate trigger option is not suitable because there are 200 forms, and then a separate flow would have to be created for each one. I saw on the forum that Microsoft wrote about the release of such an API in the first half of this year. Has it been released? In Google, I have: REST Resource: v1.forms.responses Methods get GET /v1/forms/{formId}/responses/{responseId} Get one response from the form. list GET /v1/forms/{formId}/responses List a form's responses.Microsoft Graph PowerShell SDK V2.34 Makes WAM the Default
The Web Account Manager (WAM) authentication broker becomes the default method for handling interactive Microsoft Graph PowerShell SDK connections from V2.34 onwards. The rapid release of a new version (V2.33 appeared 12 days beforehand) is usually a sign of a big problem, but in this case the reason is more likely to be a security vulnerability that’s just come to light. We’ll find out after the holidays. We've released V19.1 of the Automating Microsoft 365 with PowerShell eBook (the advantage of ePublishing) to keep track with developments. https://office365itpros.com/2025/12/23/web-account-manager-graph-sdk/
Using mode with several criteria
Hello everyone! I'm currently treating some data before I send it to do some machine learning. I have the following data: id Ano mês data_inversa dia_semana horario uf br km municipio causa_acidente tipo_acidente classificacao_acidente fase_dia sentido_via condicao_metereologica tipo_pista tracado_via uso_solo ano pessoas mortos feridos_leves feridos_graves ilesos ignorados feridos veiculos And I created a new table to summarize this data for months instead of accidents, here are the columns: BR KM Ano Mês Clima (Moda) Tipo Pista Acidentes Veículos Ilesos Feridos Leves Feridos Graves Mortes Causa (Moda) Risco What I want to do is calculate the mode of condicao_metereologica for each combination of BR, KM, Ano and Mês. But I can't wrap my head around on how I could do this. Any help is appreciated! Let me know if I made anything not as clear as it is in my head xDIn "Per-user multifactor authentication" I disabled MFA for one user; All got disabled
Hi, I'm the 365 admin for our org. Today I had a user that got a new phone and became stuck in a MS Authenticator app loop. (The app required MFA to login to the app, but they can't login to the app because they aren't logged into the app. This happened once before, and is a ridiculous Kafkaesque situation; but I digress.) To solve it, I went to disable MFA on their account, allowing them to login to the app. Then MFA could be re-enabled. Problem solved. And indeed that did work. However, on the admin side (per the screenshot) I checked off their user account (the user starting with the letter "B") and hit the "Disable MFA" link. A confirmation appeared asking me if I wanted to disable MFA for all selected users. Because I'm the careful sort, I could still see that only that one user was checked off as the popover div didn't cover that much of the screen. Hence I confirmed that I wanted to disable MFA for the selected users (i.e. that one user). I then refreshed the page, and all users are now shown as having MFA disabled. I'm 100% sure only that one user was selected, not everyone in my org. That would've been foolish. Trying to figure out what's wrong with this portion of the admin site.Graph http 449 throttled
We are experiencing a lot of Microsoft Graph trolling errors from some of our applications that are hosted in Azure Web App Services and other third party such as Front App to name one. I am trying to find an approach or strategy to figure out and narrow down what may be causing so many of these events. Whether I can narrow down by application or process, I am not sure yet. We enforce MFA on all our users, but of course, on Azure Enterprise Applications, we don't, which are used extensively in our ecosystem of apps. Any help is much appreciated here.Excel Tools for Network & Windows
Excel Tools for Network & Windows Some time ago I already shared an earlier version of this project. Since then, I have added several new features. These tools are based on functionalities that already exist in Windows and its associated software. I have consolidated them into a single Excel-based interface, allowing all tools to be executed directly from Excel. The files are free for private use. For business or enterprise environments, a more comprehensive toolbox can be developed, enabling direct support, repair, management, monitoring, and control of users and systems. Everything can be customized according to specific requirements — the scope depends solely on the desired functionality, time investment, and budget. I appreciate any positive feedback, suggestions, or constructive tips. If this project is not of interest to you, please feel free to ignore it. Thank you, and I wish everyone happy holidays.How to Manage Teams Permissions and Privacy Settings
Managing Teams permissions and privacy settings is not just an IT task—it’s a critical part of maintaining productivity, security, and trust within your organization. In this blog, we’ll explore how Teams permissions work, why privacy settings matter, and practical steps you can take to manage them effectively. https://dellenny.com/how-to-manage-teams-permissions-and-privacy-settings/How To Use Sensitivity Labels in Microsoft Teams (Step-by-Step Guide)
Sensitivity labels help organizations protect data by controlling how information is accessed, shared, and stored. If you’re using Microsoft Teams and want to keep confidential conversations, files, and meetings secure, learning how to use sensitivity labels is essential. In this blog , we’ll walk through what sensitivity labels are, why they matter, and how to use sensitivity labels in Teams step by step, even if you’re not a technical expert. https://dellenny.com/how-to-use-sensitivity-labels-in-microsoft-teams-step-by-step-guide/Integrating Copilot in Microsoft Teams Channels and Projects: A Step-by-Step Guide
In this blog, we’ll explore what Copilot is, why integrating it into Teams channels and projects matters, and most importantly, step-by-step instructions on how to integrate and use Copilot effectively. Whether you manage projects, lead teams, or simply want to boost productivity, this guide will help you unlock Copilot’s full potential. https://dellenny.com/integrating-copilot-in-microsoft-teams-channels-and-projects-a-step-by-step-guide/
Recent Blogs
- Rich alt text is automatically generated when you insert an image, making your content more accessible from the get-go.Dec 22, 2025
- Powered by Microsoft 365 Copilot, Explainer offers instant summaries and explanations of text.Dec 19, 2025
