Recent Discussions
Device Bound Session Credentials Edge
Hi everyone, For a customer i did some research about token protection within M365. I did find a lot information what to configure within M365 to get a multi layer protection (CA, Identity Protection, device compliance, etc). What i didn't found was a solution for token/cookie protection from the browser, until i found this article: https://en.ittrip.xyz/windows/edge/edge-147-device-bound#index_id0 This article states that edge 147 supports Device Bound Session Credentials which makes it much harder to do a off-device replay of a cookie. It also is saying: If you buy rather than build, ask your identity provider or SaaS vendor a direct question: do you have a roadmap for Device Bound Session Credentials or an equivalent browser-session binding model? So my question is: Does M365 (via the browser) supports Device Bound Session Credentials or will it be supported any time soon? Hope you have a nice day! Regards, MJCost Savings In Microsoft 365
Long story short, I had a client say, "We have more M365 licensed users than employees. Please help us find them." It took me about a week to find all the waste (first time always takes forever). Now I've run the same steps for a dozen other clients (takes less than an hour now). On average, I've been able to save clients 22% of their budget. Thought I'd share exactly how I do it. There are 5 areas of waste in Microsoft 365: Remove licenses from disabled users. Remove licenses from inactive users. Downgrade licenses on over-licensed users. Stop paying for unassigned licenses. Redefine the license terms. NOTE: I have the steps using the admin center, PowerShell, and a third-party app, but it's too long to re-post in Reddit. Go to Microsoft 365 License Audit to see all the steps. Find Disabled Users Log in to the Microsoft 365 admin center. Users > Active Users > Export > Continue. Open the spreadsheet. In the Home Ribbon, click Sort & Filter > Filter Click the dropdown in the Licensed column > uncheck Unlicensed > click OK Click the dropdown in the Block credential column > uncheck FALSE > click OK. Find Inactive Users NOTE: You need to either have a Microsoft Entra P1 license or use a third-party app to get this data. Open Microsoft Entra Admin Center Users > Manage view > Edit columns. Remove, replace, or add so the only columns you can see are: Display name, User principal name, User type, Identities, Assign licenses, and Last interactive sign-in time. Click Save. Click Download users > Start bulk operation Wait for the success pop-up message to appear, then click the notification bell at the top of the page. Under the notifications menu, click Success!, and then select the [report name]. Open the downloaded spreadsheet. Click Sort & Filter > Filter to enable the column filters. Click the drop-down in the assignedLicenses column. Uncheck any empty options, i.e., []. Click OK. Click the drop-down in the signInActivity column. Click Sort A to Z. Any users who have an empty signInActivity or a sign-in that was over 30 days ago can be safely disabled, and the license removed after the data is properly secured. Find Downgradable Users Review the report located on the website, then click Export. Open the CSV in Excel. Next, download the Microsoft 365 apps spreadsheet by going back to Reports > Usage and clicking View More located under “Active users - Microsoft 365 Apps” Review the report and click Export. You can start by deleting everyone that you’ve already determined hasn’t logged on or is currently disabled. Add the filter by clicking Sort & Filter in the home ribbon > Filter. Add a column for Current Licenses. Copy the licenses from the How To Use The Admin Center To Find Inactive Users spreadsheet you downloaded earlier into the new column. Be sure to align the user names in both spreadsheets. Add a column for Microsoft 365 Apps. Copy the Last Activity Date column from the Pro Plus Usage report you downloaded above in step 7 into the Office 365 app usage spreadsheet you’ve been using. Be sure to align the new data with the appropriate users in the Office 365 app usage report. For each of the following columns, click the drop-down next to the column name and filter out any logins that have happened in the last month. OneDrive Last Activity Date SharePoint Last Activity Date Skype For Business Last Activity Date Yammer Last Activity Date Team’s Last Activity Date Microsoft 365 Apps The users who have not been filtered out are excellent candidates for Exchange Online-only licenses. You may want to double-check their usage of other apps before making any license changes on their accounts. Find Unassigned Licenses Open the Microsoft 365 admin center. Click Show All > Billing > Licenses. On that webpage, you’ll see a list of all your licenses in your organization, along with a column labeled “Available Licenses”. Any number above 0 in the Available Licenses column is typically safe to remove from your organization with two caveats. Some licenses aren’t assigned to users through the Microsoft 365 admin center. NOTE: Some licenses are consumed as they are used. For example, additional storage licenses for SharePoint Online may show as available, but removing them will decrease the amount of free space available in SharePoint Online and possibly cause a disruption to SharePoint Online usage. Redefine The License Terms Microsoft adjusted its pricing model, charging different rates for the same license based on commitment terms, billing frequency, or sector-specific eligibility. The subscription length Billing Frequency Go to the Microsoft 365 admin center Click Billing > Licenses > Select the license you want to review. Click ellipsis (…) next to the subscription > Manage subscription settings. You can view the billing settings right on this page.Announcing Microsoft 365 for IT Pros (2027 Edition)
The editorial team is happy to announce the publication of Microsoft 365 for IT Pros (2027 edition) eBook, the most comprehensive and up-to-date book covering tenant management. Previously named Office 365 for IT Pros and now spanning four books with the addition of Microsoft Purview for IT Pros and Power Platform for IT Pros, Microsoft 365 for IT Pros includes coverage of Exchange Online, SharePoint Online, Entra ID, Teams, Planner, and many other aspects of the Microsoft 365 ecosystem, including hundred of examples of using PowerShell and the Microsoft Graph to automate tenant operations. https://office365itpros.com/2026/07/01/microsoft-365-for-it-pros/
Not For Profit Licence suddenly disappeared and then deleted
Hi All Have a big issue. Have a not for profit account for our charity. Renewed licence earlier in the year and all was ok and working. Then a few days ago I had reports of not being able to access data. After much hunting I found the below. Seems account was suddenly and without warning disabled and then reported as deleted a few days later. What do I do? I desperately need to recover the files that were on the associated teams? Any help would be much appreciatedIssue: numbered labels appear over the Excel ribbon when pressing Option
Description When I press the Option (⌥) key in Excel for Mac, numbered/lettered labels appear overlaid on every tab and button of the ribbon. The pattern is: Over the ribbon tabs (Home, Insert, Draw, Page Layout, Formulas, Data, Review, View): numbers 1 through 9. Over the Quick Access Toolbar icons: a descending then ascending sequence: 09, 08, 07, 06, 05, 04, 03, 02, 01, 0A, 0B, 0C, 0D. The labels disappear instantly when I press Esc. This does not happen in any other application (tested in TextEdit and Finder by pressing Option: nothing appears). Version information Excel version: 16.77.1 (Build 23091703) When checking for updates from Excel (Help > Check for Updates), I get the message: "This product is no longer supported. Support for this product has ended, and in-product help is no longer available or maintained." Troubleshooting steps already taken (no success) I have methodically ruled out the following causes: System Accessibility (System Settings > Privacy & Security > Accessibility): only Google Drive is listed, and it's toggled off. Input Monitoring: no items listed. Screen & System Audio Recording: no items listed. Switch Control: disabled. Excel KeyTips (Excel > Preferences > Accessibility): this section does not exist in my version of Excel — only the "Accessibility Checker" appears, with no KeyTips option or "Activation keystroke" setting. Excel Add-ins (Tools > Excel Add-ins): only "Analysis ToolPak" and "Solver Add-In" appear, both unchecked/inactive. Third-party automation apps (Keyboard Maestro, BetterTouchTool, Alfred, Raycast, Hammerspoon, Kutools, etc.): none installed on the Mac. Background processes (Activity Monitor): no suspicious process is running at the time the issue occurs, aside from normal system/Office processes. Office's internal preference files via Terminal (defaults read com.microsoft.Excel, com.microsoft.shared, com.microsoft.office): no key related to "KeyTips", "AccessKey", "Alt", "Option", or "Hint" was found. Question for support Is this a known behavior in older/unsupported builds of Excel for Mac (build 23091703)? Is there any way to disable this feature — whether through a hidden preference, a corrupted configuration file — or would a full reinstall of Excel be the only solution? Thank you in advance for your help.
Looking for Microsoft 365 best practices for a large dynamic company group
Looking for Microsoft 365 best practices for a large dynamic company group I'm a Microsoft 365 admin trying to figure out the best architecture for a company-wide group (100+ users) and I'm wondering if there's a better approach than what I'm currently doing. What I need I want a single company group that can: Automatically include users through dynamic membership Share SharePoint sites, files, OneDrive content, Teams resources, etc. Allow sending company-wide emails Allow sending required Outlook meeting invitations (not optional) Have moderation/approval for announcements, meeting invites, or posts Allow certain trusted users to bypass approval while everyone else requires approval Scale as employees are hired/terminated automatically Current setup Dynamic Distribution List Used for company-wide emails and Outlook meeting invites. Membership is dynamic using an Exchange recipient filter based on US users. Private Microsoft 365 Group Used for SharePoint, file sharing, and collaboration. Membership is dynamic through an Entra ID Dynamic Membership Rule. I had to use PowerShell to configure some permissions because the portal didn't support everything I needed. Problems I'm running into I now have two separate groups that should always contain the same people. The Dynamic Distribution List works well for email/meetings but doesn't provide SharePoint, Teams, or file collaboration. The Microsoft 365 Group provides collaboration but doesn't seem to support everything I need for company-wide communication. I haven't found a clean way to have approvers/moderators, while allowing a few designated people to post or send meeting invites without requiring approval. I also haven't found a good way to make Outlook meeting requests "required" from the sender side other than relying on attendees not changing their RSVP. My questions Is there a better Microsoft 365 architecture for this? Should I be using a Dynamic Distribution List, a Microsoft 365 Group, a Mail-enabled Security Group, Teams, Viva Engage, or something else? Is there a supported way to have dynamic membership + SharePoint + company email + moderated announcements/meeting invites all in one solution? How do large organizations typically handle company-wide communications while keeping membership automatic? Is maintaining two dynamic groups (one for collaboration and one for email) simply the recommended approach? I'd love to hear how other Microsoft 365 admins have solved this in production. Thanks!
Urgent Escalation: Excel Freezing and Hanging Issue Not Resolved After Troubleshooting
Dear Microsoft Support Team, Greetings. I would like to escalate an ongoing issue with Microsoft Excel that remains unresolved despite extensive troubleshooting. Today, I spent more than 2–3 hours with your technical support representative, who remotely accessed my system to diagnose the issue. During the session, multiple troubleshooting steps were performed, including a complete uninstall and fresh reinstallation of Microsoft Office. Unfortunately, the problem still persists. The issue is very simple but critical. In one of my Excel workbooks, whenever I try to delete even a single row, Excel immediately freezes and becomes unresponsive. After that, I am unable to continue working, and the application has to be force closed. This is significantly affecting my productivity and delaying important work. Since the issue was not resolved after the previous support session, I request that this case be escalated to a senior technical engineer for further investigation. Kindly help identify the root cause and provide a permanent resolution at the earliest. Please let me know if you require any additional information, logs, or diagnostic files from my end. I am available to cooperate with any further troubleshooting required. I look forward to your prompt response and a quick resolution. Thank you. Kind Regards, Farhan Mirza
Excel Help
Is there a way (either formula or macro /something) for the following. I have 2 different spread sheets (files) open at the same time. First is called Time Card Second is called Wages Time Card will have a staff members details as well as dates and shift times. (20 Tabs for different staff members and their details) Wages will have Tab 1 - Summary of all staff names, hourly rates, hours worked for each day and gross amounts to be paid Tab 2 - 20 payslips with the above mentioned details, but payslip style. Lets call the first person Joe Deer I need something in Time Card next or close, to this person's name, when clicking it it will jump to his payslip in Wages sheet As mentioned. Formula or macro.. Guess anything will do. ThanksWrong Stock data linked
Hello, After being on a microsoft livechat and remote access ive been told to post here. Ive used the Excel stock data function for hundreds of stocks without an issue until i tried getting data for 'GAN limited', this is an online gambling company which trades on the NASDAQ. When I try to get the price of the stock it comes up as GAN Limited XNAS:GAN, which is correct, it also has the correct company description, apart from that thats the only correct data. Although it says it links to XNAS:GAN, not only are all the figures wrong but when you click on the 'learn more on Bing' it takes you to the wrong stock. It takes you to Gan PLC, OTCM: GMMNF. Gan limited stock is around $26 where as the stock it takes you to (Gan plc) is $2.80. So in a nutshell, the wrong stock (Gan PLC) is linked to Gan Limited, even thought it says you're looking at Gan limited. This has been like this for the past few months and still no change. Any suggestions?Help needed to filter in Excel please
How do I filter our spreadsheet to populate a list with only lines containing the search word? For example: 18598-Ensign, 6 - 3 POSITION TIE LUGS, RIG 141 18599-Ensign, 6 - 3 POSITION TIE LUGS, RIG 143 18600-Savanna, REPAIR JACO CATWALK SKATE ASSEMBLY, 653 18601-Savanna, REPAIR BAIL TILT CYLINDER, 653 18602-NS Modular, 8" LTC, 6PCS And I only want to see "Ensign" jobs. Thank you
separate columns in excel (imported from .txt file)
Hi all. I have a a table to bring in from a .txt file lots of lines with an excerpt below. I have tried to import data and copy paste etc and then tried to separate columns using delimiters and also number of characters but there is no consistency in the numbers in the columns, it keeps separating different rows differently (ie if i use space the title of the object on the 2nd row may have two or three words so using space as a delimiter is out, same for the number of characters and position). Any suggestions - is too much data to try and clean up by doing one of the above then trying to tidy it!I received 2FA request but I can't identify the source
Since a couple of weeks, I've started received unwanted prompt on my phone to "confirm my identity": asking me to approve (second factor). Obviously, this isn't me and I reject those. At first, I was thinking it was just some phishing/stuffing attack, but I tried to find out how I could see those attempts and it is impossible to see "failed attempt" on the Windows Account web page or on the 2FA application. I have no clue how to investigate this, I would like to confirm what is the "source" of these attempts. Is there any way to have more extensive logs?Word 2010 page number problems
Help! I'm trying to renumber my 2010 .docx file, starting at physical page 11 as page 1. In certain sections of the document, the page number shows up, but in earlier sections, it completely disappears. I've been online, done everything that all the "help" posts say to do, all to no effect. Is there a free app out there somewhere that allows you to renumber your entire document, starting at a specific physical page number, and also allows you to determine where and how the page number is displayed? Or, if anyone knows a trick I don't know, I'd be all for that, too! Thanks for any help you can provide! God bless!!! Pastor Ray YoungSuddenly don't have access to charts (grayed out)
I have owned MS Office (not 365) for a few years and I had been charting my financial data that I enter into an Excel spreadsheet each week. Now, suddenly, when I try to chart my data, the recommended chart icon is grayed out as is all the specific choices of charts. Pivot Tables icon seems to work. What happened and how do I fix it?
Recent Blogs
- 4 MIN READWelcome to the June 2026 edition of What's New in Excel!Jun 30, 2026
- Narrator gives you faster and easier access to essential email and meeting details in Outlook.Jun 29, 2026
