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!
Excel/VBA Worksheet_Change function running old version
I wrote a Worksheet_Change function initially. It worked. If I entered an incorrect value I got an error message, let's say the msgbox said "Error: A". Then I changed the error message to read "Error B". No matter what I have tried to do, rename the sheet, Debug>Compile VBA Project, etc, nothing can remove the old error message from appearing. I have tried every suggestion Copilot has made without success. I rebooted my machine. I am using Microsoft Office for Home and Student 2021 running on Windows 11 Pro. Does anyone know what might be the matter? Microsoft chat was totally useless and I am pretty sure Copilot is masquerading as a human in chat support because the wording and suggestions mirrored exactly what I encountered with Copilot, so that was a giant waste of my time. If there's anyone who can help, I would welcome hearing from you with suggestions.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/
How to create a Date-Time Temperature Graph
Hi there, I was wondering if Excel is able to create a similar Date Time vs Temperature graph as shown, the green coded one? (the data was extracted from an app) I want to be able to show the Date AND Time on my Excel chart I have the raw number data but is unable to convert it into a graph similar to the one shown above, for reference the format of my raw data looks like this (below), but my raw data have three thousands results. Thank you in advance to anyone who can help me! - NonTable of contents bug - num list headings are on multiple lines in the TOC
I'm working on some documents with multiple headings and table of contents. As part of the formatting, most of the headings are numbered using the num list format, like so: However, a strange issue has been occurring where, when I set up the table of contents, some of these headings and subheadings spill over multiple lines in the table. I can't figure out why this might be—every heading has the same formatting as each other, and every subheading has the same formatting as each other, yet only some of the headings and subheadings experience this bug in the table of contents. Most are normal. See below for a simulated example of what I mean: As can be seen, the actual titles are on separate lines from the page numbers, and some of the numbers are on separate lines from their titles. The ideal format should be, say: "1.2 [Title] [leading dots] [page number]", all on the one line. I've had a look at the headings to see if there are any formatting or paragraph inconsistencies, but I can't find any. I'd like to get some help with figuring out what might be causing this issue. I apologise, I know this is a bit vague, but I really don't know how to explain it any other way. I'll appreciate any help you can offer, thank you.
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
