Unable to Access Admin Center - SMS and Authenticator Options Not Working for Account Recovery I am currently unable to access the Microsoft 365 admin center because I cannot complete the account verification process. When I try to loggin to my account, the assistant only offers two options: using the Microsoft Authenticator app or receiving an SMS code. Unfortunately, I do not have access to the Authenticator app, and the system is not able to send me the SMS code either. This leaves me completely locked out of the admin panel. I have tried multiple times to use the SMS option, but I never receive the code. The recovery assistant keeps prompting me to use either the Authenticator or SMS, but neither method works. Because of this, I cannot regain access to the admin center. I have the correct password, but without multi-factor authentication (Authenticator or SMS recovery) I cannot access the Microsoft 365 admin center. Without access to the admin center, I cannot create or manage support requests directly from the admin portal. I also tried calling support by phone, but the AI does not understand what I am saying and does not transfer me to a human agent who can actually help me resolve the problem. I would appreciate any guidance on how to contact so a human for support or alternative ways to verify my identity and regain access to the Microsoft 365 admin portal. Thank you in advance for your help. Melvin_Orellana3 Occasional Reader Aug 13, 2026 Place Microsoft 365 Microsoft 365 admin microsoft 365 admin center 20 Views 0 likes 1 Comment Unable to Access Admin Center - SMS and Authenticator Options Not Working for Account Recovery Braille Translator Challenge Using the Braille Alphabet lookup table provided: Part 1 - convert the given phrase from Braille to words. Part 2 - convert the given phrase from words to Braille. ✅ Solutions should be in the form of a single-cell formula. ✅ Generalized Lambda functions are welcome, provided the function definitions are included with your solution. ✅ Keep in mind, the "best" solution is not necessarily the shortest... Strive for conciseness, if you wish; just don't let your solutions be ordinary. 😉 Good luck and have fun! djclements Silver Contributor Aug 13, 2026 Place Excel Excel excel Formulas and Functions office 365 132 Views 0 likes 8 Comments Braille Translator Challenge Bookings 2026, Cannot Find or Edit "Staff" Configs Whenever a staff member goes to bookings, they can share their 15- and 30-minute times, but they do not see Staff or anything on the left side of the window like if the menus were available. I am a global admin and even I don't see those left pane options. We made a user the Virtual Visits Admin and they also don't see those options. So how do we get Bookings to consider other calendar appointments already in place so there is no double booking? There is also not a three lines icon to open the pane to see the left side menus. JWhit Copper Contributor Aug 13, 2026 Place Microsoft 365 Microsoft 365 admin Bookings microsoft 365 apps 23 Views 0 likes 1 Comment Bookings 2026, Cannot Find or Edit "Staff" Configs File Sharing between licensed account holders From a starting point of this year, we have been finding that any to most file shares that happened between licensed MS account users are being flagged and quarantined by the anti-malware policy. This should be, we are looking to resolve this issue. Has anyone else experienced this issue and what was your resolve. At the moment we have to monitor the quarantines and manually go in to release the share notifications. AnthonieJ2025 Copper Contributor Aug 13, 2026 Place Microsoft 365 admin center Microsoft 365 admin center admin microsoft 365 microsoft 365 apps security users 7 Views 0 likes 0 Comments File Sharing between licensed account holders Purview DLP Blocks Sharing Files with Specific Domains or Users A new DLP rule is available to control sharing of SharePoint and OneDrive files with selected domains and email addresses. The new rule supports an allow list (permit sharing) and can also specify a deny list (block sharing). The user interface takes a little getting used to, but when everything is configured and SharePoint has had a chance to respond to the block, the rule works and any attempt by a blocked user to use a sharing link is refused. https://office365itpros.com/2026/07/22/block-sharing-dlp-sharepoint/ TonyRedmond MVP Aug 13, 2026 Place Microsoft 365 Microsoft 365 data loss prevention Microsoft Graph microsoft purview 67 Views 0 likes 4 Comments Purview DLP Blocks Sharing Files with Specific Domains or Users Access 2608 Build 20326: Line controls disappear in Print Preview I believe there may be a regression in Microsoft Access Build 16.0.20326.20034 (64-bit) affecting Line controls in reports. I can reproduce the problem even with a completely new blank MDB database, so it does not appear to be related to an existing application. Steps to reproduce: 1.Start Microsoft Access 64-bit Build 16.0.20326.20034. 2.Create a new blank MDB database. 3.Create a new report in Design View. 4.Add a Line control to the Detail section. 5.Add a Rectangle control to the same section. 6.No VBA code or special event handling is required. 7.Select Microsoft Print to PDF as the printer. 8.Open Print Preview. Actual result: The Rectangle control is displayed correctly, but the Line control disappears in Print Preview. The problem is not specific to a particular printer. We have reproduced it with multiple printers. Expected result: Both the Line and Rectangle controls should appear in Print Preview and in the printed output. Workaround: Rolling Microsoft Access back to an earlier build immediately resolves the problem. The same MDB file and the same report then display and print the Line control correctly. We have also reproduced the issue with Build 16.0.20326.20044 (64-bit). Has anyone else been able to reproduce this with Version 2608 / Build 20326? h_mochizuki Copper Contributor Aug 13, 2026 Place Access Access 2016 access developer office 365 423 Views 2 likes 8 Comments Access 2608 Build 20326: Line controls disappear in Print Preview Disabling authentication methods in Entra having no effect Fairly new to MS365 here and we're trying to restrict which MFA methods our users can use. We want our users to be able to either use the Authenticator app or a FIDO2 key depending on their role, in addition to a TAP to do the initial login. We're testing disabling various methods via the Authentication methods page in Entra. As a representative test we set TAP to disabled and it gave an error when I attempted to issue a TAP for a user via the user's Authentication methods page in Intune. However we don't get consistent results with other auth methods: Authenticator, Security key (FIDO2) and SMS. I put a specific group in the 'Enable and target' > 'Exclude' section for all 3 and was still able to configure Authenticator and a phone for SMS. When viewing the methods configured for the user, only the security key was listed under 'unusable methods'; hence the policies for Authenticator and SMS appear to have no effect. Similar tests with just one auth method yield the same result. Is there something we're doing or understanding wrongly about how these policies work? RichardP860 Copper Contributor Aug 13, 2026 Place Identity & Authentication Identity & Authentication multi-factor authentication 1.1K Views 1 like 3 Comments Disabling authentication methods in Entra having no effect Microsoft Forms interface stuck in Swedish after login – account language is Italian Hello, Microsoft Forms is displayed in Swedish after I sign in, even though all my language settings are set to Italian (Italy). I have already checked the following: Microsoft account display language: Italian (Italy) Microsoft 365 interface: Italian Microsoft Edge preferred/display language: Italian The issue also occurs in an InPrivate session Before signing in, the Microsoft Forms website is correctly displayed in Italian. Immediately after signing in, the Forms dashboard and editor switch to Swedish. This suggests that the locale/language associated with my Microsoft Forms profile may be incorrectly stored as Swedish on the service side. I have already contacted Microsoft Consumer Support. They confirmed that they cannot access the Microsoft Forms backend or modify the Forms profile locale, and advised me to report the issue here and through the Microsoft Forms feedback function. I also tried the Feedback option inside Microsoft Forms, but clicking it does not open anything, both in normal browsing and InPrivate mode. Could someone please check whether the locale associated with my Microsoft Forms profile can be reset from Swedish to Italian (it-IT)? Thank you. Geremia2798 Occasional Reader Aug 13, 2026 Place Microsoft Forms Microsoft Forms Error forms language microsoft forms 4 Views 0 likes 0 Comments Microsoft Forms interface stuck in Swedish after login – account language is Italian Need suggestions for managing email signatures organization-wide Hi everyone, I'm looking for advice on managing email signatures organization-wide in Office 365. Right now, every user creates their own signature in Outlook. This has led to inconsistent branding and outdated contact details across the company. I explored a few built-in options, but nothing seems to give proper centralized control, and manually asking every user to update their signature isn't practical. I'm wondering if there's a better way to handle this natively within Microsoft 365, or if most organizations end up going with a third-party tool for this. If you've dealt with something similar, I'd love to hear how you approached it and what worked for you. Any suggestions or experiences would be really helpful. Thanks in advance! Solved KastroMoff Brass Contributor Aug 13, 2026 Place Microsoft 365 Microsoft 365 microsoft 365 office 365 outlook outlook on the web 48 Views 0 likes 3 Comments Need suggestions for managing email signatures organization-wide Entra Admin Center Flags Licensing Problems with Conditional Access The Entra admin center is flagging licensing gaps for conditional access. The messages are informational, not the beginning of a new automated billing procedure to charge tenants when Entra ID notices that some accounts use conditional access policies when they don’t have a license. In this article, we discuss the product license insight and how Microsoft measures conditional access usage, and show how to use PowerShell to find who’s using conditional access. https://office365itpros.com/2026/08/13/licensing-gaps-entra-id/ TonyRedmond MVP Aug 13, 2026 Place Microsoft 365 Microsoft 365 Azure AD Licensing & Activation 6 Views 0 likes 0 Comments Entra Admin Center Flags Licensing Problems with Conditional Access Major Trouble Activating Win. 11 Pro After Hardware Change Hello, I am trying to transfer a Windows 11 Professional product key to a different machine. It seems like no matter what I try, Windows will not reactivate. It activated just fine on the old machine. Before moving the installation to the new machine, I first signed into my Microsoft account on the old machine, per Microsoft's recommendation for hardware changes. I then signed into my Microsoft account on my new machine. When the activation failed on the new machine, I ran the troubleshooter in settings, which told me it couldn't find any devices to transfer the product key from. I then tried "slmgr /ato" which was unsuccessful but told me to call Microsoft. The chatbot told me to use a tool found here: "aka.ms/aoh". The tool said the "installation ID was unable to be activated". I'm feel like I'm out of options, however, I still want to use Windows. Any help would be greatly appreciated. Thank you. thegrindisreal Occasional Reader Aug 13, 2026 Place Microsoft Forms Microsoft Forms Error Licensing & Activation 17 Views 0 likes 1 Comment Major Trouble Activating Win. 11 Pro After Hardware Change

Sum of data across multiple columns & rows based on Criteria I have a data set that ranges across multiple rows and columns. I am building a formula and looking to sum based on multiple criteria. I tried sumifs, however, that does not work. Below is my example using a hypothetical sumifs (keeping in mind, this does not work). Any suggestions on how to return my expected result would be greatly appreciated. =SUMIFS('Query Budget'!$C$10:$HV$1000,'Query Budget'!$A$10:$A$1000,F$1,'Query Budget'!$A$5:$HV$5,$D5) MirsadaMK Copper Contributor Aug 12, 2026 Place Excel Excel excel Formulas and Functions 133 Views 1 like 7 Comments Sum of data across multiple columns & rows based on Criteria "Getting Name" bug on my worksheet One of the cells in my worksheet has a "Getting Name" bug on my worksheet - I have no idea what this is referring to - I've never seen this in my 40-years of using Excel - there are no Range Names nor Links in this workbook. What is it and how do I get rid of it? Tahoe24x7 Copper Contributor Aug 12, 2026 Place Excel Excel excel 1.8K Views 1 like 14 Comments "Getting Name" bug on my worksheet Trapped in an Authenticator Loop Dear Community, please help! I am trapped in an Authenticator Loop. I've got a microsoft workplace account, but if I want to log in, I have to type in a code from the microsoft authenticator app. I downloaded the app, but in order to use it, I have to log into my account and in order to do so, I also have to type in a code from the authenticator app, which I don't get, because to get the code I would have to log into the authenticator app, what I would need a code for... No matter which link I click, I can't open anything before I enter the code, which I can't get. I am using teams on mac, either on a firefox browser or on the desktop app and the authenticator on an Iphone. Please don't just tell me "don't use teams on a mac", this wasn't my choice. Unfortunately, my emplyer's IT support also is chronically unavailable. So is here anyone who could help me? I've already gone through the usual deleting the app, using another browser etc. options. Best Lukas LukasMaerz Copper Contributor Aug 12, 2026 Place Identity & Authentication Identity & Authentication Authentication Authenticator app microsoft teams mobile modern authentication 235 Views 0 likes 3 Comments Trapped in an Authenticator Loop Corrupted Timestamp Display in Recent Files View I am using Office 365 for iPadOS on a 2025 iPad Pro. With an Excel workbook open, the battery died. Ever since, the Recent Files (in List View) displays the timestamp of any workbook opened after the battery death into numbers: 0, 1, 2, 3, etc. The unopened files are not affected until they are reopened. The thumbnail view shows the correct timestamps, as does OneDrive. This carried over into Word as well. A second iPad shows the same corruption, but computer and iPhone are fine. So it is limited to just the iPadOS applications. Since it has propagated to a second iPad, it looks like the problem may exist on the server. The sorting algorithm or the user interface rendering loop may be hitting a fatal mathematical error, and to prevent the entire application from crashing, the app's code panics and falls back to simple numbering. Extensive troubleshooting has been done, including full app deletion/reinstall multiple times with sign-outs, account swap, time zone toggling, calendar format changes, and force restarts and updated/replaced the iPadOS using recovery mode. All settings have been reset. Since a backup to iCloud occurred after the incident, it may have the corrupt data. I have done everything but a full restore as a new iPad, which is impractical due to the number of applications. Solved Gastropod Occasional Reader Aug 12, 2026 Place Excel Excel Excel on mobile office 365 57 Views 0 likes 2 Comments Corrupted Timestamp Display in Recent Files View Stuck in an authenticator loop I have a 365 Business account. Haven't logged in for a while due to reasons, i was just starting up as a sole trader. Anyway decided now is the time to resurrect it and get up and running, except Authenticator doesn't work because I changed my phone, and my back up email is out of date, and no longer exists. I have tried the support web chat which wants to send a code to authenticator or my back up email. Just called the help line that referred me to the web chat which doesn't work, I couldn't get past the bot. So I am stuck. Any recovery options does not recognise my log in details, i think this is because its been a while since I logged in (I still pay but ....) but I can't resurrect it because I don't have a way of getting a code due to authenticator/back up email as cited above. I am really at a loss as to what to do. I don't want to abandon it and start again as there are documents in my one drive that I need. Can anyone help please. (I think all that needs to happen is an update to my back up email and then I can get going). I am the sole administrator on my business account. RoisMJMB Copper Contributor Aug 12, 2026 Place Identity & Authentication Identity & Authentication admin Authenticator app microsoft 365 microsoft 365 admin center multi-factor authentication 54 Views 1 like 3 Comments Stuck in an authenticator loop How to look up specific text in a specific column, multiple columns involved Hello, I am trying to implement a search field for a vertically oriented list, lets name it #1 for reference, looking for the number of results of the desired text within a range in a specific column in separate ranged list, #2, which is horizontally oriented. Neither list are Excel tables. Values in List 1 are automatically obtained and sorted from List 2 via dynamic functions which spill over underneath. For better reference, I have implemented a simple sanitized example as an attachment, both in Workbook screenshot format. Is it possible for this to be implemented, and how could I go about to do so? Thanks in advance Solved Chris14 Iron Contributor Aug 12, 2026 Place Excel Excel excel Formulas and Functions office 365 62 Views 0 likes 2 Comments How to look up specific text in a specific column, multiple columns involved Mastering Clipchamp – From Beginner to Pro 5 Creating a good video is about more than simply recording clips and putting them together. The right visual effects can transform a basic collection of footage into a video that feels polished, engaging, and intentional. With tools such as filters, transitions, overlays, stickers, and blending options, Clipchamp makes it possible to add creative touches without requiring advanced video-editing experience. Link to the post JohnNaguib MVP Aug 12, 2026 Place Microsoft 365 Microsoft 365 microsoft 365 13 Views 0 likes 0 Comments Mastering Clipchamp – From Beginner to Pro 5 Office Home & Business 2019 license no longer recognized after reinstall ("No license found") Hello everyone, I'm looking for some help because Microsoft Support has not been able to solve this issue. I own a genuine perpetual license of Office Home & Business 2019 for Mac, linked to my Microsoft account since August 2019. The license is still listed under Services & Subscriptions, but Office no longer activates. My hardware MacBook Pro (Retina, 13-inch, Late 2012) Model: MacBookPro10,2 Intel Core i5 8 GB RAM macOS Ventura 13.7.8 Installed using OpenCore Legacy Patcher Office version originally working: 16.78 Later tested with 16.101 and 16.93 Same result on every version What happened Office had already been successfully activated and worked normally. I was able to: create documents edit documents save documents After restarting the Mac, Office suddenly requested activation again. Since then it has never activated successfully. Initially Office failed to activate with an unknown error. After completely uninstalling and reinstalling Office using Microsoft's installer, the activation process changed. I can now successfully sign in with my Microsoft account, but after authentication Office displays: "No license found for this account." My Office Home & Business 2019 license is still present in my Microsoft account under Services & Subscriptions. Even though my Microsoft account clearly owns Office Home & Business 2019 for Mac. Microsoft account The license appears correctly under: Services & Subscriptions Office Home & Business 2019 for Mac Added to my account on August 7, 2019. The website instructs me to open an Office application and sign in to activate. Everything I've already tried Uninstalled Office completely Installed Office again using Microsoft's installer Installed Office 16.78 Installed Office 16.93 Updated to Office 16.101 Removed Office containers Removed Group Containers Deleted OneAuth cache Deleted Entrabroker cache Removed activation tokens Cleared Office preferences Signed out and signed back into Microsoft account Deleted Office credentials from Keychain Reinstalled Microsoft AutoUpdate Verified no MDM profile exists Verified Internet Accounts Verified Microsoft account Microsoft Support remotely accessed my Mac and repeated all troubleshooting steps Nothing solved the issue. Additional information Running: defaults read com.microsoft.office returns: OfficeActivationLicense = NoLicense although: OfficeActivationEmailAddress = email address removed for privacy reasons is correctly detected. The activation window successfully reaches Microsoft's login page. Office now asks for my Microsoft account credentials. Authentication completes successfully. After a few seconds Office reports: "No license found for this account." It then offers only two options: Buy Microsoft 365 Use another account Microsoft Support remotely connected to my Mac, completely removed Office, installed a newer official installer, and the problem remained exactly the same. My question Has anyone experienced this after reinstalling Office 2019? Could this be: a licensing server issue? an incompatibility introduced after Office 2019 reached end of support? an activation problem related to OpenCore Legacy Patcher? something else? I would really appreciate any suggestions. Thank you very much. Additional notes: The Office license has been associated with the same Microsoft account since 2019. The same installation was successfully activated and worked normally before the problem started. The issue only appeared after restarting the Mac. Microsoft Support has already remotely accessed my computer and could not resolve the problem. jpdlima Copper Contributor Aug 12, 2026 Place Microsoft 365 Apps for enterprise Microsoft 365 Apps for enterprise mac microsoft 365 microsoft 365 apps microsoft 365 apps for enterprise microsoft 365 groups 298 Views 0 likes 6 Comments Office Home & Business 2019 license no longer recognized after reinstall ("No license found") "In-Review" status on my replies. Hello, I started contributing to this forum a few years ago, but lately I've noticed that every reply I make is placed in the "In-Review" status. This status lasts approximately 24 hours and is then removed. What does this status mean? Why does it happen? Does the same situation happen to other contributors or just me? Thanks in advance to anyone who answers me. IlirU Solved IlirU Iron Contributor Aug 12, 2026 Place Excel Excel excel 99 Views 0 likes 10 Comments "In-Review" status on my replies. 2 MIN READ Co-create slides with Copilot in PowerPoint for iPad A popular feature on desktop and the web is now available in PowerPoint for iPad: the ability to co-create with Microsoft 365 Copilot directly in your presentation. aparna_jethani Microsoft 365 Insider Blog Aug 13, 2026 copilot ios powerpoint 62 Views 0 likes 0 Comments Co-create slides with Copilot in PowerPoint for iPad 1 MIN READ The Microsoft Excel World Championship is back on ESPN8 The Ocho for the 5th year in a row The MEWC returns to ESPN8 The Ocho for the 5th year in a row, airing on Saturday, August 8th. msexcel Excel Blog Aug 07, 2026 blog excel 416 Views 0 likes 0 Comments The Microsoft Excel World Championship is back on ESPN8 The Ocho for the 5th year in a row