Recent Discussions
Application.SaveAsText posible Bug
I'm discovering the powerful Application.SaveAsText and LoadFromText methods, never used before, and found that Application.SaveAsText acTable,... always produces an Error 2.487: The Object Type argument for the action or method is blank or invalid The method works flawlessly with any other ObjectType. I've tested this behavior in a bare new accdb, with a single table in it, in three different systems (win10 & win11), all yielding the same result. My Access is 365 2508 (32 Bits) May someone check if it is a bug?Disabling Microsoft AutoUpdate
I have a customer with a Mac mini M4 with multiple user accounts. Each user has access to Office 365 apps, Outlook, Word, Excel. I have disabled Automatic Updates in the AutoUpdate app. This has not stopped app from showing updates are available. I want the update app to not open when updates are available. My question is what can I do to stop there update app from opening but still have it available for manual checking and updating. Thanks Len Levin BSC
Dibbling Microsoft AutoUpdate - macOS
I have a customer with a Mac mini M4 with multiple user accounts. Each user has an access to Office 365 apps, Outlook, Excel and Word. The issue I am having is with Microsoft AutoUpdate. I have turned off "Automatically keep Microsoft apps up to date" on all of the users. This has not stopped update application from opening and showing on each of the users there are updates available. If one of the users tries to run the update while an application is open by another user, it cause all kinds of problems. My questions is, "Is there another way to prevent AutoUpdate from indicating there are updates available? Thanks Len Levin BSCUsing Microsoft 365 Effectively in Education Without Overloading Teachers
Technology has become a cornerstone of modern education. Platforms like Microsoft 365 (M365) offer powerful tools to enhance teaching, streamline workflows, and foster collaboration. But with so many apps and features, the risk is real: teachers can feel overwhelmed rather than supported. The key lies in using M365 intentionally—focusing on what makes teaching easier, not harder. https://dellenny.com/using-microsoft-365-effectively-in-education-without-overloading-teachers/Naming Conventions People Actually Use in Microsoft 365
If you’ve ever worked in a Microsoft 365 environment, you know how messy things can get: Teams called “Project”, SharePoint sites named after random acronyms, and files scattered across libraries with names like “Final_v3_Updated_ReallyFinal.docx”. The root problem? Naming conventions that look good in policy documents but fall apart in day-to-day use. The good news: you can design conventions that are practical, simple, and easy for people to actually follow. Here are some steps to make it work. https://dellenny.com/naming-conventions-people-actually-use-in-microsoft-365/Overcoming “Microsoft Teams Fatigue” and Keeping Communication Effective
he rise of hybrid and remote work has made Microsoft Teams an essential tool for collaboration. But with constant pings, endless meetings, and a stream of notifications, many employees are experiencing what’s often called “Teams fatigue.” While Teams (or any collaboration platform) is meant to increase productivity, without mindful practices, it can lead to burnout, reduced engagement, and even miscommunication. The good news? With the right strategies, you can overcome Teams fatigue and keep communication effective. https://dellenny.com/overcoming-microsoft-teams-fatigue-and-keeping-communication-effective/
Wanting to create an automated calculator
I am wanting to create a formulated calculator that automates penal rates for hours worked (hours worked between specific times would decide what penal rates apply) Here’s a table of what I’m trying to accomplish. I have no idea on where to start formula wise and am hoping for some assistance 😊Microsoft’s Push to Save Office Files in the Cloud
A new policy setting is available to force Microsoft 365 enterprise (Office subscription) applications to save to cloud locations and ignore the local disk. The idea is to increase cloud usage and improve compliance by storing all Office files in OneDrive for Business or SharePoint Online. Like a network PC, creating a dependency on a network connection only makes sense when a network connection is dependable, which might not always be the case. https://office365itpros.com/2025/09/09/save-to-cloud-locations/
Macro to filter table to a searched result, then hide columns that contain a blank or a set value.
Hi All, I'm trying to figure out how to do the above. Essentially I have a list of assemblies and along the same row is a list of each part within that assembly. Not every sub-part is used in each assembly so there are blank spaces. I currently have a Search cell in B2 with a macro button next to it to Autofilter the table in B5 to the assembly I want to see. I'm struggling to get a reliable way to select the line that is visible after filtering so I can hide columns containing no information. Also if there are any better ways to hide the columns then seen below as I just recorded a macro of hiding them. The table I have spans from B5 to W808 currently. Range("C7:W7").Select works but the result will not always be in that row as only hiding cells above it. Sub Search() Application.ScreenUpdating = False If Range("B2") <> "" Then ActiveSheet.Range("B5").AutoFilter Field:=1, Criteria1:=Cells(2, 2).Value Rows(Cells("A2").Value).Select 'Doesn't Work Selection.SpecialCells(xlCellTypeBlanks).Select Selection.EntireColumn.Hidden = True End If Application.ScreenUpdating = TrueSUMIFS function won't give me a sum for 1 text criteria and date range
I have been trying to create a formula that will pull the sum of my various expenses/income according to the their category and within a month's range. Here is the formula I wrote: =SUMIFS('Transactions'!E:E,'Transactions'!C:C,'Gifts','Transactions'!A:A,'>='&'1'!G2,'Transactions'!A:A,'<='&'1'!H2) I want the sum to populate on the sheet named '1' and I'm having it pull the info from the sheet named 'Transactions,' which has a masterlist of all my transactions for the year (both income and expense) which includes the columns date, paymentmethod, type, description, and amount. I have data validated date, paymentmethod, type, and amount. Column E is amount, C is type (which includes 'Gifts'), and A is date. G2 and H2 are start date and end date which I typed out as 1/1/25 and 1/31/25. They are formatted as dates and data validated. Every time I press enter on this it just shows what I typed with red dotted lines around it. Other basic functions work (e.g. sum) but this one won't. Any idea how I can get this to work?
Clash analysis for manufacturing hall
Hi all, I'm trying to build an excel sheet that has 3 "manufacturing bays" and when I list a move date & location against a piece of plate, that it moves a cell and recreates that live picture in that build hall. Initially I was trying to use some of the functionality in the (board game) Battleship excel templates to see if writing a VBA would allow for this/ linking it to a button. Something like the below: I then want it to highlight if two plates are likely to be moved into the same space at the same time as part of the clash analysis. Does anyone know if it's possible to build this level of functionality into excel through VBA etcStreamlining Legal Workflows with Microsoft 365 A Guide for Compliance-Heavy Industries
Legal teams and compliance-focused industries face constant pressure: strict regulations, high stakes, and endless documentation. Efficiency isn’t just a nice-to-have—it’s essential. Microsoft 365 (M365) provides a powerful ecosystem for streamlining workflows, ensuring compliance, and enabling secure collaboration without sacrificing productivity. In this post, we’ll explore how legal teams and compliance-driven organizations can harness Microsoft 365 workflows to reduce risks, save time, and stay audit-ready. https://dellenny.com/streamlining-legal-workflows-with-microsoft-365-a-guide-for-compliance-heavy-industries/Preparing Employees for Moving from Google Workspace to Microsoft 365
Migrating from Google Workspace to Microsoft 365 (M365) can be a major step in improving productivity, collaboration, and security within your organization. However, a successful transition doesn’t just depend on the technical migration—it also requires preparing employees for the change. People are at the heart of your workplace tools, and ensuring they are informed, supported, and confident in using M365 is the key to unlocking its full potential. Below are some best practices to prepare your employees for a smooth and positive migration journey. https://dellenny.com/preparing-employees-for-moving-from-google-workspace-to-microsoft-365/Auto save is not enabled prompt every time.
In word when I open documents there is a yellow bar telling me autosave is not enabled. I know, I am a grown adult and chose not to have auto save. How can I stop this annoying yellow bar? Whilst we are at it, how can I stop excel from telling my my work book might be slow on every workbook I open? Who in the coding department thinks this is helpful?Microsoft Bolts on Copilot License Check onto ExRCA
Microsoft announced a new Copilot license check diagnostic for the Exchange Connectivity Analyzer. Sounds good, but the test is very simple, and its results don’t tell you anything more than a few lines of PowerShell can deliver. To prove the point, we wrote a quick script to show how to perform a Copilot license check with the Microsoft Graph PowerShell SDK. https://office365itpros.com/2025/09/08/copilot-license-check-exrca/
copy day name by value only from cell containing =today() function
is this any way to copy day name (text only) only from cell containing =today() function i set A1=TODAY() and i set format to dddd so the today name is displayed i want to set A2 cell to be set to the day name as text to use it in conditional format using day names ? any help ???PDF figures inserted in Word exhibit black background
I am using Word for Mac to prepare a manuscript. I inserted a PDF figure with transparent background, which was created with Adobe Illustrator. It looks fine on my Mac. But when I transfer the document to a Windows computer, the transparent background of the figure becomes black. For other Office softwares, such as PowerPoint, similar issues also happen. I know if I convert the figure to png format would fix the issue. But I still want to stick on the PDF format since it's vector image and compatible with LaTeX. Can you figure out why is this happening and how to fix it? Thanks!!Run Your Microsoft 365 Tenant Like a Pro Right from Your Couch
Managing a Microsoft 365 tenant no longer requires sitting in front of a workstation all day. With today’s mobile tools, you can resolve user issues, monitor service health, and keep your environment secure — all while sitting comfortably at home with just your phone or tablet. Here’s how you can stay in control of your Microsoft 365 tenant as an admin, even when working from the couch. https://dellenny.com/run-your-microsoft-365-tenant-like-a-pro-right-from-your-couch/How to Recover from OneDrive Sync Nightmares
If you’ve ever relied on OneDrive to keep your files safe and accessible across devices, you know how amazing it can be when everything just works. But when it doesn’t? You end up in what I like to call the OneDrive sync nightmare. Files go missing, versions clash, your desktop looks like it went through a blender, and suddenly you’re not sure if your data is safe. Don’t panic. In most cases, your files are still there—you just need to untangle the sync mess. Here’s how to recover from OneDrive sync nightmares and get your files back under control. https://dellenny.com/how-to-recover-from-onedrive-sync-nightmares/
Recent Blogs
- 1 MIN READCelebrate Excel's 40th Birthday by joining the Microsoft Excel team for our Reddit AMA on September 30, 2025, at 10AM PT.Sep 09, 2025
- Now you can apply all grammar and spelling corrections simultaneously in Word for the web!Sep 09, 2025
