Recent Discussions
Change gradient above Word menu?
I would love to remove this gradient from the Blue theme and replace it with a solid color, as in the Black theme. I doubt it's possible, but I guess it never hurts to ask. This is just annoying - having to squint every time I need the menu. I've set a 200% display on the 4K monitor but it doesn't help much.
Excel Pivot table showing only part of one row
Hello, I have an Excel pivot table that literally has one row that shows data for the 1st 3 columns and then no data for the remainder of the columns in the pivot table. All other rows in the pivot table show data for every field in the pivot table (as long as there is data in the underlying data source). The data source for the row in question is fully populated and contains no trailing spaces or other oddities that I can see. What could be causing this and how can I fix it so the data shows properly in my pivot table for this one row? (Some cell info. partially blanked out intentionally)Key Features to Look for in CAD Software Cloud Hosting Solutions
Businesses using resource-intensive design applications increasingly rely on CAD Software Cloud Hosting Solutions to improve accessibility, collaboration, and performance. However, choosing the right hosting environment is essential for maintaining productivity and ensuring smooth design workflows. Organizations should carefully evaluate several important features before selecting a cloud hosting provider. One of the most critical features in CAD Software Cloud Hosting Solutions is high-performance infrastructure. CAD applications often require significant processing power, GPU acceleration, and large memory capacity to handle complex rendering and modeling tasks efficiently. A hosting environment with powerful virtual workstations helps designers, architects, and engineers work without lag or performance bottlenecks. Remote accessibility is another important consideration. Reliable CAD Software Cloud Hosting Solutions should allow users to securely access applications and project files from any location or device. This flexibility supports remote and hybrid work environments while enabling teams to collaborate on projects in real time. Centralized storage also simplifies file sharing and version management across distributed teams. Security and data protection are equally important. Businesses handling sensitive design files should look for hosting providers that offer encrypted connections, automated backups, disaster recovery options, multi-factor authentication, and proactive monitoring. These features help safeguard intellectual property and minimize the risk of data loss or unauthorized access. Scalability is also a key advantage of cloud-hosted CAD environments. As project requirements grow, businesses should be able to increase computing resources and storage without major infrastructure investments. Additionally, reliable technical support and uptime guarantees are essential for uninterrupted operations. Providers like Apps4Rent offer CAD cloud hosting environments designed to support high-performance workloads, secure remote access, and collaborative design workflows for modern businesses.Best Practices for Secure Yahoo Mail to Office 365 Migration
Businesses moving to Microsoft 365 often choose Yahoo Mail to Office 365 Migration to improve communication, strengthen security, and access advanced collaboration tools. While the migration process offers significant operational benefits, organizations must follow proper security practices to protect sensitive emails, contacts, and business data during the transition. One of the most important steps in Yahoo Mail to Office 365 Migration is performing a detailed pre-migration assessment. Businesses should review mailbox sizes, verify user accounts, and identify unnecessary or outdated data before initiating the transfer process. This helps reduce migration complexity and minimizes the risk of incomplete data transfers. Secure authentication methods are also essential during the Yahoo Mail to Office 365 Migration. Enabling multi-factor authentication for administrator accounts and user mailboxes helps prevent unauthorized access during the migration process. Businesses should also use strong passwords and restrict administrative permissions to authorized personnel only. Another best practice for Yahoo Mail to Office 365 Migration is ensuring an encrypted data transfer. Secure migration tools and encrypted communication channels help protect emails and attachments while data is being transferred between environments. This is particularly important for businesses handling confidential client or financial information. Organizations should also create backup copies of existing Yahoo Mail data before migration begins. Backups provide an additional layer of protection in case unexpected issues occur during the transition. Testing mailbox functionality after migration is equally important to verify email delivery, folder structure, and user access permissions. Proper planning, user communication, and technical support can significantly reduce migration risks and downtime. Apps4Rent provides professional migration services that help businesses complete Yahoo Mail to Office 365 Migration securely while maintaining data integrity, minimizing disruptions, and ensuring a smooth transition to Microsoft 365.Welcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With over half a billion Excel customers, we want to engage with you in fundamentally different ways and the community is a starting point for that. Our community helps answer your product questions with responses from other knowledgeable community members. We love hearing feedback and feature requests from you which helps us build the best version of Excel ever. If you have found an outage or a bug please post at our Answers forum. We look forward to getting to know you! Sangeeta Mudnal & Olaf Hubel on behalf of the Excel TeamI built a free, open-source M365 security assessment tool - looking for feedback
I work as an IT consultant, and a good chunk of my time is spent assessing Microsoft 365 environments for small and mid-sized businesses. Every engagement started the same way: connect to five different PowerShell modules, run dozens of commands across Entra ID, Exchange Online, Defender, SharePoint, and Teams, manually compare each setting against CIS benchmarks, then spend hours assembling everything into a report the client could actually read. The tools that automate this either cost thousands per year, require standing up Azure infrastructure just to run, or only cover one service area. I wanted something simpler: one command that connects, assesses, and produces a client-ready deliverable. So I built it. What M365 Assess does https://github.com/Daren9m/M365-Assess is a PowerShell-based security assessment tool that runs against a Microsoft 365 tenant and produces a comprehensive set of reports. Here is what you get from a single run: 57 automated security checks aligned to the CIS Microsoft 365 Foundations Benchmark v6.0.1, covering Entra ID, Exchange Online, Defender for Office 365, SharePoint Online, and Teams 12 compliance frameworks mapped simultaneously -- every finding is cross-referenced against NIST 800-53, NIST CSF 2.0, ISO 27001:2022, SOC 2, HIPAA, PCI DSS v4.0.1, CMMC 2.0, CISA SCuBA, and DISA STIG (plus CIS profiles for E3 L1/L2 and E5 L1/L2) 20+ CSV exports covering users, mailboxes, MFA status, admin roles, conditional access policies, mail flow rules, device compliance, and more A self-contained HTML report with an executive summary, severity badges, sortable tables, and a compliance overview dashboard -- no external dependencies, fully base64-encoded, just open it in any browser or email it directly The entire assessment is read-only. It never modifies tenant settings. Only Get-* cmdlets are used. A few things I'm proud of Real-time progress in the console. As the assessment runs, you see each check complete with live status indicators and timing. No staring at a blank terminal wondering if it hung. The HTML report is a single file. Logos, backgrounds, fonts -- everything is embedded. You can email the report as an attachment and it renders perfectly. It supports dark mode (auto-detects system preference), and all tables are sortable by clicking column headers. Compliance framework mapping. This was the feature that took the most work. The compliance overview shows coverage percentages across all 12 frameworks, with drill-down to individual controls. Each finding links back to its CIS control ID and maps to every applicable framework control. Pass/Fail detail tables. Each security check shows the CIS control reference, what was checked, what the expected value is, what the actual value is, and a clear Pass/Fail/Warning status. Findings include remediation descriptions to help prioritize fixes. Quick start If you want to try it out, it takes about 5 minutes to get running: # Install prerequisites (if you don't have them already) Install-Module Microsoft.Graph, ExchangeOnlineManagement -Scope CurrentUser Clone and run git clone https://github.com/Daren9m/M365-Assess.git cd M365-Assess .\Invoke-M365Assessment.ps1 The interactive wizard walks you through selecting assessment sections, entering your tenant ID, and choosing an authentication method (interactive browser login, certificate-based, or pre-existing connections). Results land in a timestamped folder with all CSVs and the HTML report. Requires PowerShell 7.x and runs on Windows (macOS and Linux are experimental -- I would love help testing those platforms). Cloud support M365 Assess works with: Commercial (global) tenants GCC, GCC High, and DoD environments If you work in government cloud, the tool handles the different endpoint URIs automatically. What is next This is actively maintained and I have a roadmap of improvements: More automated checks -- 140 CIS v6.0.1 controls are tracked in the registry, with 57 automated today. Expanding coverage is the top priority. Remediation commands -- PowerShell snippets and portal steps for each finding, so you can fix issues directly from the report. XLSX compliance matrix -- A spreadsheet export for audit teams who need to work in Excel. Standalone report regeneration -- Re-run the report from existing CSV data without re-assessing the tenant. I would love your feedback I have been building this for my own consulting work, but I think it could be useful to the broader community. If you try it, I would genuinely appreciate hearing: What checks should I prioritize next? Which security controls matter most in your environment? What compliance frameworks are most requested by your clients or auditors? How does the report land with non-technical stakeholders? Is the executive summary useful, or does it need work? macOS/Linux users -- does it run? What breaks? I have tested it on macOS, but not extensively. Bug reports, feature requests, and contributions are all welcome on GitHub. Repository: https://github.com/Daren9m/M365-Assess License: MIT (free for commercial and personal use) Runtime: PowerShell 7.x Thanks for reading. Happy to answer any questions in the comments.
The latest mobile apps killed mobile first when working with files
Hi, I really enjoyed working only with mobile devices when we started with M365. On iOS the OneDrive app was paramount when organising files in SharePoint/Teams Sites. Easy up- and downloads, drag‘n drop. Move and copy all was there to manage a companies files on mobile devices even when only on mobile network connections. But the upgrades that happened over the last 1-2 years completely break this kind of workflows. There is no really mobile-first paradigm visible anymore. The OneDrive app was worst. All the pretty well integration file management stuff is gone. No drag‘n drop. No useful integration into iOS Files app. Copying between OneDrive and SharePoint got a pain. Bulk operation just silently fail. Files get renamed without any warning (numbers get added to the name or are just increased so no one will ever find the file again). So just two simple usability examples that are a mess: to select multiple files in a folder you have to press the word ‚Select‘ that is not a button or something. This shows up like a column heading in the file view. Right beside ‚Name‘ and ‚Date Modified‘. Why are active user elements placed in table headings? If you browse into some SharePoint folders and quickly want to go back to your OneDrive files you either have to press the back button over and over again until your back to the top level view or you can press-hold the back button and then select ‚Files‘. Butthe latter brings you to the top level Library view and you still have to manually go to ‚Files‘. The old app design just had a top menu bar where views could easily be switched. Am I the only one who wants to work on mobile devices? Does Microsoft still expect everyone to use a laptop and run desktop apps? Annoying.Drawing on OneNote for IOs
I'm ready to give up on OneNote... it used to be good. I have two problems that regularly interrupt my work. The first problem I noticed was that when I double tap my Apple Pencil, although it is set to go to the eraser, it does that for a brief moment and then turns into that text-to-type pen. The second, and more important, problem, is that quite regularly all the drawing pens suddenly are greyed out and there is nothing I can do (other than possibly waiting a long time) to get them working again. The first problem I can work with, it's just annoying, the second has got me ready to shift my notes from OneNote. Has anyone got any suggestions for fixing either of these? The support crew have had me try the same things each week, and none of it works. Thanks in anticipation!
Microsoft 365 Developer E5 license lacking endpoints and device ON defender portal
Dear Support Team, I am a microsoft certified trainer (MCT). I currently have a Microsoft 365 Developer E5 license assigned to my tenant. However, I have noticed that my Microsoft Defender portal (security.microsoft.com) is missing several critical features. For example, I cannot see the Endpoints or Devices menus, which is preventing me from implementing and testing Microsoft Defender for Endpoint. Additionally, my Azure tenant and Microsoft 365 tenant are separate. This has created challenges when configuring security services such as Microsoft Sentinel (SIEM), as certain prerequisites and integrations require configuration through the Microsoft Defender portal. Due to the missing Defender features, I am unable to complete the necessary setup. I would appreciate your assistance in understanding: Why the Endpoints and Devices sections are unavailable in my Defender portal despite having a Microsoft 365 Developer E5 license. Whether additional licensing, onboarding steps, or tenant configurations are required to enable Microsoft Defender for Endpoint features. How best to integrate or align my separate Azure and Microsoft 365 tenants to support services such as Microsoft Sentinel and Defender XDR. These issues are significantly impacting my ability to evaluate and implement Microsoft's security solutions. I would appreciate any guidance or recommendations to resolve them.
I made a new microsoft 365 tenant and suddenly users appeared
Made a new Microsoft tenant account for a customer and few hours later suddenly there were several users on the list without being added? They include several no longer active users and old names for people(like maiden names for married women). The customer is currently using Google workspace and is transitioning to 365. Any idea why? And what happens if I just delete them all? Will they come back and haunt us again?Charting help needed
Dear Experts, I have a data as below, So , in Column "G" we have 2 Rntis( 21,8,66 & 53714), and I need to plot the time difference for report of each rnti, which is calculated by subtracting the consecutive - SFNs, for that rnti. Now , the problem here is that in below for example , for the rnti-53714, it's not correct, for example at row-244, my last report for rnti=53714 came at row 241, so the difference should be (821-789) * 10, while in my case it's doing the subtraction in consecutive SFNs, which basically messes up my analysis. I tried to do something like below from column W to AF, but not sure how to achieve this properly( X axis should be my time, Y axis should be my average-ms and distribution should be based on the RNTI. Attached is the worksheet..(anything in -ve and above 400 is Outliers and need to be removed) in ms column also. Thanks in Advance! Br, Anupam
power querry
Hi everyone, I've run into a recurring issue: after refreshing a Power Query that's loaded into an Excel Table, a completely blank column sometimes appears that doesn't exist in the query output itself. In my case the table starts at cell B2, and the blank column shows up right next to my actual data. My working hypothesis is that this happens when the number of columns returned by the query decreases compared to a previous refresh: Excel's Table object doesn't always shrink to match the new result, so it keeps a "ghost" column inherited from the previous load's structure. However, This behavior seems unpredictable: when I went from 10 columns down to 5, I could only got one extra blank column, not five. Has anyone else experienced this? Is there a reliable way to force the Table to always match the query's current column count exactly, instead of refreshing on top of the old structure? And if the "ghost column" theory is right, why would only one extra column show up regardless of how many were actually dropped? Thanks in advance!Microsoft Blocks Graph Access to Non-IPM Folders
An app written to fetch details of Copilot interactions from the TeamsMessagesData folder suddenly stopped working when the Graph refused to return items. The 403 forbidden error can’t be argued with. Fortunately, the aiInteractionHistory API fills the gap, even if the API does not return the full text of Copilot responses. That information is available, but you’ll need to use eDiscovery to get it. https://office365itpros.com/2026/06/18/copilot-interaction-app/
MCA billing account stuck in "under review" status for 4+ days, no resolution
I'm the Global Admin for a Microsoft 365 tenant (domain: fortunamg.net) recently transitioned from a GoDaddy CSP reseller relationship to a direct Microsoft Customer Agreement (MCA) billing account. After setting up the MCA billing account and adding a payment method, I attempted to make an edit to my billing account address (updating to the new 9-digit zip code format). This triggered an "Account under review" status, which states the review usually takes up to 2 days. It has now been over 4 days with no update or email notification. This review is blocking me from purchasing a subscription, which I need to do to restore an active Microsoft 365 subscription on this tenant (currently showing as "Disabled" following the GoDaddy detach). Billing Account ID: 7793dd6e-68c9-5362-c5e2-3fe091b9854c Domain: fortunamg.net Could someone help check the status of this review or escalate to the appropriate team? Phone support has been unable to resolve this. Thank you.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 appreciatedSole Admin Locked out of Microsoft tenant -- MFA Error 500121
Sole Admin Locked out of Microsoft 365 Tenant- MFA Error 500121 using OTPKEY Im the original administrator of a Microsoft 365 Business Basic tenant for the City of Briarcliff. Tenant: mailto:email address removed for privacy reasons Admin Account: mailto:admin@briarcliffar.onmicrosoft I can succesfully enter the correct password, nut MFA verification fails with error code 500121. I have original microsoft 365 setup email showing the admin account The microsoft purchase receipt and Order ID. Access to billing email account Control of the cityofbriarcliff.gov domain through Cloudflare. The tenant was never fully configured beyond the initial setup process. I was able to sign in originally and reached the Connect and Configure your domain page but did not complete deployment. I need assisstance with recovery of the sole administrator account and MFA reset for tenant. I can provide provide proof of purchase, original setup email, billing information, and proof of control of cityofbriarcliff.gov
PLEASE HELP - Excel Horizontal Scroll Not Working
Hello all: I have an excel workbook that is many columns wide. I am on a Macbook Pro, Office 365. Scroll lock is *not* on, please do not suggest I turn it off. I can scroll in other workbooks. On this workbook, if I am selecting cells and trying to scroll horizontally, it won't continue the horizontal scroll beyond what is visual on screen. I am extremely annoyed, please help. Thank-you, CarlMicrosoft Tightens Security for Self-Service Password Reset
Microsoft plans to improve the security of the Self-Service Password Reset (SSPR) facility in September 2026 by requiring users to register at least one authentication method. SSPR will then use the registered authentication method to verify user accounts when changing passwords. The change aligns SSPR with user sign-ins and improves security by removing fallback on directory attributes, which might be altered by attackers. https://office365itpros.com/2026/06/17/sspr-authentication-methods/Office 365 Mailbox Export to PST - Third Party Tools: What’s Your Experience?
Exporting Office 365 mailboxes to PST is still a common requirement in many Microsoft 365 environments, especially for backup, compliance, and migration scenarios. While Microsoft offers native options like Purview eDiscovery and Outlook export, many administrators also consider third-party tools when dealing with large mailboxes or bulk export requirements. In real-world scenarios, factors like speed, ease of use, permission handling, and consistency of exported data often influence the choice of tool. Some teams prefer native methods for compliance control, while others explore third-party solutions to simplify large-scale or repeated export tasks. For those working with Microsoft 365, what has your experience been with third-party PST export tools? Have they helped in your environment, or do you still rely mainly on Microsoft’s native options?
Recent Blogs
- Our special Pride Month theme in Microsoft Outlook, Word, Excel, PowerPoint, and OneNote has returned!Jun 18, 2026
- Our latest Microsoft 365 Copilot app learning series explores how Researcher, Copilot Pages, Copilot Notebooks, and Create can support workflows.Jun 17, 2026
