Recent Discussions
MS Forms branching option is not visible to individual answers in multiselect question
HELLO, I am working on a form. Question type is choice where user can select "Multiple Answers" and based on selected answer, subsequent question should be visible. To achieve this, i want to add branching to main question but i do not see the option to do so. How to achieve this ? NO branching option :
Solver in Excel - Variable Limitation
Hi All, I built a model in Excel to solve 1d Cutlist optimization, model works great and gives optimal results But when there is complex cutting patterns that results in more than 250 cutting combinations model totally fails fails due to the limitation of solver to handle more than 250 variables with integer constraints. using simplex LP, I created model years ago but unable to use it Hoping Microsoft has this in the list to fix this limitation in coming versions ?Why Outlook Locks You Out After Deleting Thousands of Emails — And How to Fix It Fast
We’ve all been there — your Outlook or Hotmail inbox is overflowing with thousands of old messages, and you decide to clean house. You select all, hit delete, and feel relieved… until you try to open your mailbox again and get hit with a dreaded message: “We’ve temporarily limited your account.” Welcome to the world of Outlook throttling — Microsoft’s way of protecting its servers (and your account) from overload or suspicious activity. But don’t worry, it’s usually temporary and easy to fix. https://dellenny.com/why-outlook-locks-you-out-after-deleting-thousands-of-emails-and-how-to-fix-it-fast/Data Residency and Compliance in the Microsoft Cloud with Microsoft 365
In today’s globally connected world, organisations face growing pressure to ensure data is stored, managed, and protected in accordance with national borders and data-sovereignty laws. For users of Microsoft 365 and the wider Microsoft Cloud, understanding data residency and compliance is essential to maintaining trust and meeting legal obligations. https://dellenny.com/data-residency-and-compliance-in-the-microsoft-cloud-microsoft-365-governance-guide/How Cloud Computing Improves Business Agility and the Role of Microsoft 365
In today’s fast-moving business world, agility isn’t just a nice-to-have—it’s essential. The ability to respond quickly to market changes, launch new offerings, support remote or hybrid work, and scale resources up or down can define success. One of the foundational enablers of that agility is cloud computing. Further, productivity and collaboration platforms such as Microsoft 365 (M365) help turn those capabilities into everyday business reality. Here’s how cloud computing boosts agility, and how Microsoft 365 fits into the picture. https://dellenny.com/how-cloud-computing-improves-business-agility-and-the-role-of-microsoft-365/
Partner Intune reporting questions
I need some help for my global partner- SHI International. We have a monthly services modernization briefing with the SHI M365 practice team. They have a need around 1-2 Q&A deep-dive sessions where their team of M365 experts want to ask some in=depth technical and pre-sales related questions related to Intune Reporting Challenges and Customer Pain Points, Current Intune Reporting Limitations, Technical Barriers to Reporting, Permissions and Consent Model Confusion, Feedback on Documentation and User Experience. Appreciate any guidance on a PSA SME on this topic or a global black belt, that would be great. Appreciate if you can point me to the latest updated documentation on this topic. I reached out to several folks in the PSA team with no luck yet. Thanks!
Help Needed: Add Interactive Dashboard to Landowner Engagement Tracker (Same Sheet)
Hi all, I’ve built a basic Excel tracker to monitor engagement with landowners for a large infrastructure project. The purpose of the tracker is to: Show progress tracking of each case of for the project director to monitor progress help the Project Director Identify which cases may require statutory powers to secure access (if voluntary agreement isn’t possible) This helps our leadership team make informed decisions quickly. What I’ve got: A sheet called "LANDS RIGHT TRACKER" Columns include: Reference Number Agreement Status Case Status Risk Level (High/Medium/Low) Willingness to enter agreement Reason for refusal Flag for whether statutory powers may be needed 🛡️ All data is fictitious — names and details are placeholders, so no privacy concerns. What I need help with: my level of excel knowledge is very basic and I was hoping for some assistance to: Add an interactive dashboard and key metrics directly on the same sheet (not a separate worksheet). The below is just my suggestions as you are the expert your guidance expertise is much welcomed, happy for you to put it straight on to the tracker as I have left a section on the tracker for you to insert your items Ideally using a Pivot Table and Slicers to filter by: Case Status Risk Level Agreement Status Willingness to enter agreement https://docs.google.com/spreadsheets/d/1c2IJ-YLsTN-DZE9ltw0JR-nGVuuGzTKE/edit?usp=drivesdk&ouid=104511246399228274463&rtpof=true&sd=trueRequest: Please Professionally Enhance My Gantt Chart Template
Hi everyone, I’ve created a basic Excel Gantt chart template for suppliers to use when discussing project timelines with landowners. The chart lists tasks on the left and shows the duration of works by month from October 2025 to April 2026. My Excel skills are quite basic, so I’d really appreciate if someone could directly improve the template for me. Specifically, I’m looking for: A more professional and visually appealing layout Clearer formatting for tasks and timelines Automatic highlighting of active months for each task Conditional formatting to make the chart easier to read Any other practical enhancements that would make it more effective for supplier discussionshttps://docs.google.com/spreadsheets/d/1SdPU8HEsHDjOHljwYsPnRmRHHNrJ5Whq/edit?usp=drivesdk&ouid=104511246399228274463&rtpof=true&sd=true This is only a template and contains no sensitive data. I’ve attached the file—please feel free to make changes directly to the chart. Thank you very much for your help!Microsoft 365 vs Azure vs Dynamics 365 – What’s the Difference?
In today’s cloud-driven business environment, it’s common to hear about Microsoft’s cloud offerings—Microsoft 365, Azure, and Dynamics 365. While they’re all part of the Microsoft ecosystem, each serves different purposes. Understanding the differences can help you choose the right tool (or mix of tools) for your organisation. https://dellenny.com/microsoft-365-vs-azure-vs-dynamics-365-whats-the-difference/Cloud Benefits Simplified Scalability, High Availability, and Disaster Recovery
Cloud computing has transformed the way businesses manage their IT infrastructure. Whether you’re a startup or an enterprise, the cloud delivers agility, efficiency, and resilience that traditional on-premises setups can’t match. In this post, we’ll break down three of the most important benefits of cloud technology—scalability, high availability, and disaster recovery—in simple terms. https://dellenny.com/cloud-benefits-simplified-scalability-high-availability-and-disaster-recovery/
Import data from a Microsoft Forms PDF into Excel
Hi all. I have a number of PDFs for clients which contain questionnaires, score sheets, etc. Some are completely external, and some are from Microsoft Forms. A while back, I created a Macro/some VBA code to read data from the external PDFs, import it into Excel and display the figures; it works really well. Today, I've tried to update it to load data from the PDFs created by "printing" a Microsoft Forms complete questionnaire and saving as a PDF - unfortunately, when trying to import this into Excel (using "Get Data -> From File -> PDF"), the "Likert" questions are appearing but showing "null" for all the columns, not identifying which contains the "selected" checkbox. Possibly a slim hope, but I was wondering if anyone has experience doing something similar, or can recommend a way to get this to work? I know there are potentially other ways to approach this (I tried connecting it directly to the linked Sharepoint Excel file, but the URL is entirely powered by URL arguments ?foo=bar&baz=boing etc, and Excel demands those all be deleted when giving it a filename to connect to to get data from the web, helpfully); connecting it to a "local" version of the Excel file on OneDrive is a possibility, but ideally I'd a) want the tool to be accessible to people who have access to the PDFs but not the spreadsheet, and b) have to save the print-out PDFs in every client folder to store their data together, and the spreadsheet may occasionally be purged, so the PDF is the "safe" way to access the data.) PDFs can't be run through any online tools due to containing sensitive data. Many thanks.
Trouble Setting Up Computer
Here's my dilemma: I'm setting up a new computer. Updates download and install just fine. I'm clicking through the pages, country, keyboard, etc. I get to to the one that wants you to set up your Microsoft account. I enter my email, then request a code, then enter the code. I get a page saying that since I didn't use a password that I need to create a PIN. I click on the Create PIN button and get a page that just spins and spins and spins and spins. I get someone on the tech support chat. We do the whole hold-the-power-button-for-5-seconds thing. The setup starts over. This time I request a password after I enter my email. I get sent to the same page saying that since I didn't use a password I needed to create a PIN. I click on the Create PIN button and get the page that perpetually spins. It never goes to the page to create a PIN. I wait for a while, like minutes, like unusually long for a page to load. I the routine several more times. Same result. I create a new account, use a new email address, new password, same thing. Internet connection is stable. Same behavior on a different Internet connection. The Create PIN page is not working. Also, one should not be required to sign in or create an account to set up a computer. There is no way to skip it. Moreover, the program sends you to the "since you didn't enter a password" page whether you entered a password or not. Additionally, I already a PIN, I'm being asked to create things that should already be associated with my account, it found my email and password, why not my PIN? I'm just trying to set up this Lenovo. Thoughts?Migrating from Outlook.com to Microsoft 365 Business Basic
I am currently testing Microsoft 365 Business Basic. My users mail boxes are all on Outlook.com. I need those mailboxes migrated to Microsoft 365 Business Basic. This seems impossible as PST files are not supported by that subscription and IMAP is not supportes either. What are the right way to migrate users mail boxes from Outlook.com to Microsoft 365 Business Basic?Leveraging SharePoint for Performance Tracking Monitoring Team and Project Progress
SharePoint is more than a document management system; it’s a comprehensive platform that facilitates real-time tracking and collaboration. Here’s why it excels in performance tracking: https://dellenny.com/leveraging-sharepoint-for-performance-tracking-monitoring-team-and-project-progress/Allowing Users to Add Enterprise Apps to Entra ID is a Bad Idea
Enterprise apps can come from a variety of sources. Most are Microsoft 1st party apps, and the rest are ISV apps. It’s easy to add an app without really intending to, which is a good reason to force users through the Entra ID app consent workflow when they want to add an app. Unhappily, I failed the test and added an app in a moment of weakness. Here’s what happened. https://office365itpros.com/2025/10/24/enterprise-apps-my-mistake/Updating the Entra ID Password Protection Policy with the Microsoft Graph PowerShell SDK
The Entra ID password protection policy contains settings that affect how tenants deal with passwords. Entra ID includes a default policy that doesn’t require additional licenses. Creating a custom password protection policy requires tenant users to have Entra P1 licenses. As explained in this article, once the licensing issue is solved, it’s easy to update the policy settings with PowerShell. https://office365itpros.com/2025/10/23/password-protection-policy-ps/Important Change Coming for Entra ID Passkeys in November 2025
Entra ID is about to introduce passkey profiles, a more granular approach to passkey settings. The change is good, but you might like to check the current passkey settings to make sure that the values inherited by the new default passkey profile behave the way that you want. In particular, check attestation enforcement to make sure that the right kind of passkeys are used. https://office365itpros.com/2025/10/22/passkey-setting-policy/Practical Graph: Creating a Multi-Workload User Activity Report
Microsoft 365 comes will many usage report APIs covering different workloads. This article explains how to use PowerShell to extract usage data for multiple workloads to combine together to create a holistic view of user account activity within a Microsoft 365 tenant. https://practical365.com/holistic-usage-report/Loop development has seemingly stopped
Our team adopted Loop since many of us prefer the personal knowledge management system style of Notion or Obsidian to other classic note-taking and sharing software. However, many core features are still not present that have been Day 1 features of these other tools, and a quick check of the Loop Roadmap leads me to believe that most features will be security/governance focused. That's disappointing if true, because right now Loop is clearly inspired by those tools, but incredibly far behind in a way that makes it hard to justify their continued use. For example: Cannot embed documents inside Loop-- in Notion you can just drag and drop a PDF to upload, and the /embed command lets you put an interactive document inside the page Cannot select multiple pages to re-arrange structure No Copilot to perform page cleanup-- Notion lets you use AI to fix formatting, and it works very well. No command palette-- this is a must for operating in a knowledge management system No Mac app No mind map a la Obsidian I could continue to produce these examples, but I am hoping to find out that once some core governance features are completed, Microsoft will be focusing some development efforts on improving this platform-- we hope it is not abandonware a few years into it's launch.
Events
Learn, Connect, and Be Inspired at ESPC25
Join us in Dublin for ESPC25! One of Europe’s largest community conferences, ESPC25 is your opportunity to expand your Microsoft 365 Copilot, Collaborative...
In-Person
Recent Blogs
- Microsoft 365 Copilot is now built into People and Files, with Copilot in Calendar coming soon.Oct 28, 2025
- 3 MIN READThis month, look for Agent Mode in Excel (Frontier) in the Tools menu of Copilot for Excel. Additionally, PivotTable #SPILL and accessibility assistant updates are now available to Insider users on W...Oct 28, 2025
