Recent Discussions
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.
Data Import issue???
I am working on a drift formula for items being pushed by wind and waves on the water. I imported a text file of weather data, formatted all the data to numbers, and built an "if" formula to convert the wind direction into drift direction. Wind from 360 degrees (north) would cause an item to drift 180 degrees (south). The problem is the formula sees everything as false. Is this a formatting issue with the imported text? =IF(B28<180,B28+180,B28-180)
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 :Agent Mode continuously loading
Hi all, I installed Excel Labs today and have tried to use https://www.microsoft.com/en-us/microsoft-365/blog/2025/09/29/vibe-working-introducing-agent-mode-and-office-agent-in-microsoft-365-copilot/ for Excel in the web. However, no matter which prompt I use, it just loads continuously, even when left for hours. Has anyone got this working? Or know how to resolve this? I appreciate it's a Preview feature, so happy to wait if it's a temporary glitch, but thought it'd be worth checking.
How to sync two worksheets
Hi, I am looking for a way to save myself repeating the same task 100x by syncing several worksheets to the source worksheet, so that if I delete or add column's and rows the same happens on the other worksheets. I know how to have cell values synced, I just need to know how to have row/column additions/deletions also synced it would save me a lot of time. thank you in advance
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 ?
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.
Unwanted automatic change of text number format to scientific
I have a simple spreadsheet in which I was trying to list "codes" for keeping track of data for a game I'm working on. (Table top dice game) I find that the codes 01P2 or 01G2 can be found and replaced with 02 or 03, etc. However, my code 01E2 etc. changes automatically to scientific format. Apparently something about the "E" triggers some sort of auto response. I looked around in options but found nothing that seems to apply to this. I tried chat but the techie wanted to take over the computer, which sounded to me like overkill. He transferred me to second techie who dumped me out of the chat. First time ever I gave feedback of one star. Anybody have a simple solution?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!
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
