Recent Discussions
Same XMATCH formula stopped working when I updated data.
A month ago, I used the following formula to find an exact match in a column on a different tab with 259,999 rows and it worked. =XMATCH (A3,'EPC - 09-4-25'!B$1:B$250000) I copied over the list of 250,000 with updated information. The formula does not work and returns #NA. =XMATCH (A3,'EPC - 09-4-25'!B$1:B$250000) Any suggestions for what could be wrong?
Add a page title to a OneNote page using Power Automate
Hello, I have set up a flow in Power Automate to create a new page in OneNote. It extracts information from an email, including the information that I want to be the title of the new page in OneNote. The flow creates the new page in the correct notebook and section, but the page is untitled. My flow correctly composes the title in a Compose action named PageTitle. The parameters for the action "Create page in a section" only include the following Notebook Key Notebook section Page Content AI suggested that I add the page title to Page Content inside either an html h1 tag. I tried that. It does not turn the text inside the tag into the title of the page. It simply formats the text inside the contents of the OneNote page. I also tried using the html title tag. That didn't work either, and the PageTitle wasn't even output into the contents of the OneNote page, so it was just empty. I would appreciate suggestions for how to do this. I cannot see either a OneNote tag or Power Automate tag for this discussion. If I am posting my question in the wrong discussion place, please direct me to the right place. Thanks.
Issues with Office applications after latest updates
Following the latest (Office 365) updates, we encounter issues with Office applications in general and Outlook (Classic) specifically. Slow start-up that disables add-ins, app freezing, slow scrolling, ... Tried adding RAM - even up to 40 GB ! - but no real improvement. Only re-install of MS Office seems to have an effect in one case. Is this a general issue caused by implementing Copilot into all those MS Office apps ?What Is the Cloud? A Beginner’s Guide for Microsoft 365 Learners
If you’ve ever saved a document in OneDrive, joined a Teams meeting, or collaborated on a Word file in real time, you’ve already experienced the cloud. But what exactly is “the cloud,” and why does it matter for Microsoft 365 users? Let’s break it down in simple terms. https://dellenny.com/what-is-the-cloud-a-beginners-guide-for-microsoft-365/
Excel: Count cells with specific value + colour
Hi there, I would like to be able to count the number of cells that contain a specific value and are shaded a specific colour. This is for a rota spreadsheet that will be tallying the total number of shifts which have been agreed. The cells that contain "Yes" as a value from a drop down list and are shaded green, should be counted as part of the quarterly total. I'm assuming that a VBA custom function would be needed for this. I've tried a few but cannot figure out a way to get this to work with both a specific value and colour. I would be very grateful for anyone that is able crack this challenge. In the example screenshots, it is the cells shaded in green that would need to be counted and the totals appear in column GJ. Best regards, Daniel
Desktop Click (lower right taskbar) pointing to wrong desktop
I have 2 accounts on my laptop. Have enabled "Select the far corner of the taskbar to show the desktop" but it goes to the wrong account. I am signed in under the correct account, one drive syncs to the correct account, all the apps are signed in to the correct account, the correct account is in settings. But the desktop that shows and that taskbar icon in the right corner goes to the wrong desktop and I cannot figure out how to change it. Current desktop: C:\Users\user\OneDrive – MSFT This is the default desktop on my laptop. It’s the wrong account. The correct account is : "C:\Users\user\OneDrive" (personal) How do I switch from the first account to the second one – for the desktop to be correct? PS - I have wasted 4 hours already with 3 different MS departments who think live chat is the answer - and they each keep trying to pass me off to the next one. It's like they get a bonus for doing nothing, knowing nothing, keeping me on live chat for hours, only to tell me it's my job to contact the next department and start over. Nice job, MS.
Autocorrect "Replace text as you type" no longer working in comments
I'm a college English professor. I've been using MS Word's Reviewing features for years (decades?) to offer feedback on student essays. I mainly make bubble comments in the margins of the document (CMD-OPT-A or Insert > Comment). Until recently, my Autocorrect "Replace text as you type" feature was working in the comments (my fumbly fingers mistype things like "differnet" and I've even added some shortcuts like "dangmod" to "dangling modifier"). But as of maybe a few months ago, my comments no longer autocorrect. I haven't changed any settings, and the function works in the body text of the document. I have a 2023 Macbook Pro running Sequoia 15.7.1, and I'm using MS Word for Mac Version 16.101.3. Anybody have the solution for this? I've spent years training myself to use MS Word's Reviewing so I can be very efficient with my time (I know all the keyboard shortcuts, etc.), but if autocorrect no longer works, I'll probably just switch to Google Docs or something. Thanks for any help you can give.
I cannot select continuous words by dragging pointers
A week ago, I could not select words or sentences by dragging pointers. What I can do: double-click a word and it can be selected. Or I triple-click and I can select a whole paragraph. But I cannot exactly select what I want. Can any supporters help me solve the problem?Multi-replace Macro
Hey all, I need some assistance creating a macro that replaces multiple phrases. Below are the phrases I have and the phrases I want them changed to without having to manually use "Find and Replace" each time. "ROr ROY" replaced with "LK Fin" "OKP and DON" replaced with "HU Dep" "Signs (Single)" replaced with "PE Dep" When I look elsewhere, I'm shown how to replace words but not phrases. Any assistance would be greatly appreciated.Running percentage
I want to create a formula that calculates the percentage of days that I completed a task throughout the month. For instance, I want my formula to calculate 90% if I complete a task 9 days out of the first 10 days of the month, and I want this formula to automatically calculate or update based on how many tasks I completed for each subsequent day of the month all the way to the end of the month. Thanks to whomever helps me with this.Exploring Microsoft Designer The Creative Tool for Everyone
In today’s digital-first world, creativity is no longer reserved for professional designers or those with extensive technical skills. Whether you’re a marketer, a small business owner, a student, or someone looking to create stunning visuals, having access to user-friendly tools can make a world of difference. Enter Microsoft Designer, a powerful AI-driven graphic design tool that makes creating professional-quality designs simple and accessible. https://dellenny.com/exploring-microsoft-designer-the-creative-tool-for-everyone/How to Sync Song Lyrics in Microsoft Word with Music in Clipchamp
Adding synced lyrics to a video enhances the viewing experience, making it easier for audiences to follow along. If you’re using Microsoft Word to format your lyrics and Clipchamp to edit your video, syncing them properly can elevate your content. Here’s a step-by-step guide to ensure your lyrics align perfectly with your music in Clipchamp. https://dellenny.com/how-to-sync-song-lyrics-in-microsoft-word-with-music-in-clipchamp/Drop down menu linked to an Excel file
Hi! I would like to populate Word drop down menu to data stored in Excel spreadsheets. I found a post (https://learn.microsoft.com/en-us/answers/questions/5448059/drop-down-menu-linked-to-a-file) in https://learn.microsoft.com showing how to get it done, but I'm new to VBA and need a more detailed explanation. The last line in that post reads, "For a step-by-step guide, you can check out this tutorial on linking Excel drop-down lists to Word.", but no link to that step-by-step guide is provided. Please, do you know where that guide, or any other helpful manual, is available? Thanks!
Access Query Finding Old/Deleted Data
I have replaced several outdated tables in an Access database recently with updated versions. The issue that is now occurring is that my queries are pulling the old data that doesn't exist anymore in the table and creating duplicate entries in my output (one row with the updated data and one row with the deleted data). Does anyone know why this happens and what the fix is? The old data isn't in my table so I'm not sure how to surface it to remove it.
Recent Blogs
- October 17 marks a quiet revolution. On this day in 1979, VisiCalc shipped—the first electronic spreadsheet—and suddenly, anyone with a computer could model ideas, track budgets, and make decisions f...Oct 17, 2025
- 2 MIN READThe newly designed app icons reflect a strategic shift in Microsoft 365: unified, intuitive, and designed for flow across every canvas.Oct 16, 2025
