Power Query - SKU Generator
Hi, I am using MacBook Excel Version 16.102.2 I am trying to build a Power Query - that build out a SKU (e.g Column H). Based on the products I've entered in Column E and the Size Range chosen in Column F. I've managed to build a power query - but when I refresh nothing happens / updates. Some screenshots attached of my workings.
Unified Company Calendar for Mixed Microsoft 365 and Non-365 Users – 2025
Seeking a Shared Calendar Solution for Mixed Microsoft 365 and Non-365 Users I’m working on a solution to create a shared company calendar that everyone in our organization can view, while keeping editing permissions limited to a few selected individuals. The challenge: Some of our team members do not use Microsoft 365, and I’d like them to still be able to subscribe to or view the calendar and receive updates. Ideally, this should work without requiring full Microsoft accounts. I initially considered using an ICS-based calendar, but it seems Microsoft 365 Group calendars don’t support sharing via ICS links. I also explored creating a Group calendar as suggested in other threads, but ran into issues making it accessible to external users or those without 365 accounts. For context, I’m a Global Admin, so I have full access to configure settings in the Microsoft 365 Admin Center and Exchange if needed. We’re a small business, and our main goal is to have a centralized calendar for vacation schedules and company-wide events. It should be simple to access and maintain, with a focus on collaboration and accessibility across the board. What I’m looking for: A calendar that’s viewable by all, including non-M365 users Editable only by a few delegated team members Compatible with Microsoft 365, but not dependent on it for basic access Any tools, workarounds, or best practices that have worked for others in similar hybrid environments
Hide Sheet after missusing shortcut Alt+H+W
I was working on an inventory and frequently using the shortcut mentioned above. Unfortunately, during one of those times, I must have misused it, and my sheet became hidden. Since then, I’ve tried multiple methods to unhide it, but none have worked. I would really appreciate your assistance in resolving this issue.
Issue with DnsConnectorDelivery
Background: We are currently migrating from Exchange 2016 to 2019 in a hybrid environment. We have 2 2016 servers both in our main datacenter, and 2 2019 servers, one in our main datacenter and one in our offsite datacenter. Backup datacenter has its own DCs that are replicas of our main datacenter's DCs. Exchange 2019 has been installed and updated to CU 11. Problem: When I run the hybrid configuration wizard and select all 4 servers to be included in the send and receive connectors, everything completes and no errors appear. However, mail gets stuck in the DnsConnectorDelivery queue on the server in our backup datacenter. The NextHopDomain for the stuck mail is our M365 domain, domain.mail.onmicrosoft.com As soon as I remove the server in the backup site from the send and receive connectors, mail flows correctly again. I've done a lot of internet searching and it seems the issue has something to do with our MX record, but both domains have the correct record in their DNS. What could be causing the issue? Any help is appreciated!Loop governance, lifecycle, manageability for IT Admins – Nov 2024
Dive into our latest update on Loop governance, lifecycle, and manageability tailored just IT admins! Discover how Loop's seamless integration with Microsoft 365 can transform your team's productivity with real-time co-authoring, versatile components, and enhanced security features. From Copilot Pages to comprehensive manageability roadmap items, this blog has everything you need to confidently pilot and fully enable Loop in your organization.
Microsoft 365 Certification
Why Microsoft 365 Certified Apps and Agents Matter for IT Admins As an IT Admin, you're constantly balancing innovation, security, and user productivity. With the growing ecosystem of apps/agents integrating into Microsoft 365, how do you ensure the ones your organization adopts are secure, compliant, and reliable? That’s where Microsoft 365 Certification comes in. What Is Microsoft 365 Certification? Microsoft 365 Certification is a rigorous program that evaluates third-party apps across key dimensions like security, compliance, data handling, and privacy. Certified apps/agents meet Microsoft’s highest standards and are verified through independent assessments and documentation reviews. Top Benefits for IT Admins 🔐 Enhanced Security & Compliance Certified apps/agents undergo thorough security testing, including vulnerability assessments and penetration testing. Many of the controls these apps / agents adhere to are based on established frameworks such as SOC 2, ISO 27001, and GDPR. This ensures that certified apps align with recognized industry standards, providing confidence when deploying them in enterprise settings. 🛠️ Streamlined Governance With certification, IT Admins can confidently shortlist apps or agents in their tenant, knowing they meet Microsoft’s governance criteria. This reduces the overhead of manual vetting and accelerates app adoption. 📍 Discoverability in Microsoft 365 Ecosystem Certified agents are tagged with a “Microsoft 365 Certified” badge in AppSource, Teams Store and the Microsoft 365 admin center, making them easier to find and trust. 📊 Transparency & Documentation The Microsoft Admin Center and Teams Admin Center include a Security & Compliance section under Integrated Apps where admins can view certification details for apps. This feature is designed to improve transparency and speed up app evaluation. Here’s what is available: Certification Class Publisher Verified – Confirms developer authenticity. Publisher Attested – Indicates the app’s security and compliance posture based on self-assessment. Microsoft 365 Certified – Shows that the app has passed Microsoft’s rigorous audit against security and compliance controls. These details help IT teams understand the app’s risk posture before deployment. Evidence Sharing Developers can opt to share certification evidence (e.g., policy docs, system configs, penetration test reports) directly in MAC. This evidence is uploaded during the certification process in Partner Center and, if consented, becomes visible to admins in Microsoft Admin Center and Teams Admin Center. How to Find Certified Apps Visit the Business Apps – Microsoft AppSource to explore certified apps by category, publisher, or certification level. You can also filter apps directly in AppSource or within the Microsoft 365 admin center. Join the Conversation Have you deployed a Microsoft 365 Certified agent in your organization? Share your experience in the comments below or start a thread in the Microsoft Tech Community to help others make informed decisions.OneDrive - Mass File Deletion by OneDrive
I noticed in late July/early August that files in my OneDrive folders suddenly vanished. More than 25 years' worth data gone. Close to 300 GB of both personal and business data. Only the files were gone. The folders and file structure remained untouched. My OneDrive space is 2 TB. The Recycle Bin was empty. My OneDrive account has been active since OneDrive started and remains so without interruption. Through the forum community I learned that I am not alone with my frustrations. Microsoft Support scheduled a telephone call. The gentleman who called was rude. He said the only way files were deleted was by the user (i.e., me). That suggestion is ridiculous as it suggests I went into hundreds of individual folders and subfolders to delete files but leave the folder structure intact. The gentleman said there was no way OneDrive or Microsoft could cause that to happen. News flash. It wasn't just me. I later submitted a request for assistance by messaging OneDrive Support asking my issue to be escalated to the OneDrive Engineering Team for a One-Time Data Restoration (OTDR). I'm still waiting for a response or even as much as an acknowledgement of my support request. Does anyone else recognize this issue? What other ideas have others tried that worked to fix the problem? Any ideas on how I get my files back?
Outlook broke after Office 365 update to 16.0.19328.20158 – cannot open emails Windows Server 2016
Hello everyone, posting to report that after the latest automatic update to Microsoft Office 365 version 16.0.19328.20158, we are experiencing a critical issue on multiple company machines running Windows Server 2016: The Outlook desktop application launches normally, but when trying to open any email, the following error appears: “There was a problem opening this item... The text formatting command is not available... Reinstall Microsoft Outlook.” Launching Outlook in safe mode (Outlook /safe) does not help. Creating the FORMS2 folder (suggested workaround) does not fix it. Attempting a downgrade via OfficeC2RClient.exe fails with error 30183-27 (400). Quick/online repair from Control Panel also has no effect. In our environment, this issue appeared simultaneously on many workstations and servers, right after the Office update today. Temporary solution: We are instructing users to access their mail via Outlook Web App (OWA), which is not affected by this bug. We would like to know: If others have experienced this bug with this build, including on Windows Server 2016 If any working workaround exists, or an official fix timeframe from Microsoft Thanks to anyone who can share their experience or updates!File Attachments
🚫 Reminder: Do Not Share Real Customer Data or PII in the Community As a friendly reminder to all members of the Excel Community: Please do not post any content that contains personally identifiable information (PII) or real customer data. This includes names, email addresses, phone numbers, account numbers, or any other data that could be used to identify an individual. 🔒 Protecting privacy is a shared responsibility. If we suspect that any content contains real customer data, community administrators may remove it without warning to protect privacy and ensure compliance with our policies. Per our Terms of Use : You should only upload content that you have permission to share. If you're sharing examples or screenshots, please use dummy or anonymized data. Clearly indicate in your post that the data is fictitious or anonymized. Let’s work together to keep the Microsoft Tech Community a safe, respectful, and productive space for everyone. If you find a post with content likely to be personal in it then please report the post using the cog in the top right corner. Thank you for your cooperation! Microsoft Tech Community Admin TeamOutlook Classic for M365 - File > Encrypt > 'Encrypt-Only' option applies 'Do Not Forward' label?
I recently joined a new company and am helping support their M365 tenant and admin duties. I'm running into a very weird issue where no recipients can actually read/view the message when we encrypt emails using only 1 specific method (our organization largely uses the Outlook Classic for Microsoft 365 desktop app). If a user follows this method, for some reason the 'Do Not Forward' label is applied to the encryption, despite specifically selecting 'Encrypt-Only' - it defaults to 'Do Not Forward' every single time: New Email > File > Encrypt > Encrypt-Only Sending emails with this method gives any/all recipients a "You don't have sufficient permissions to open the mail." regardless of where they try to open the email (OWA, Outlook Classic, New Outlook) Yet, if the user tries this other method below - the proper Encrypt-Only label is applied, and any Outlook client immediately and opens/views the email as you'd expect: New Email > Options ribbon > Encrypt properly applies the Encrypt-Only label I verified IRM (Identity Rights Management) is enabled for our tenant: And encryption tests pass with flying colors: Ultimately, I'm at a loss for what's going on here and specifically where to check to fix this issue for this 1 specific encryption method. Poking around in the Purview portal, I'm having a hard time figuring out where these encryption policies/settings lie and how to get this method to stop defaulting to 'Do Not Forward' even though 'Encrypt-Only' is checked.
