Recent Discussions
Creating a Comprehensive Inactive Guest Account Report
Many examples of how to report inactive Entra ID guest accounts with PowerShell are available on the internet, but they're all flawed because they make decisions based on the last sign in. That's a shortsighted method because it doesn't take guest activity into account. This article explains how to combine audit data with sign-in data to create an enhanced view of guest account activity so that intelligent decisions can be made to keep or retain the accounts. https://practical365.com/inactive-guest-account-report/
Excel macro VBA issues
Hey guys. - I wrote a macro, which contain other macros using Call orders. If I running the macros separately everything ok, from the main macro one of them didn't running it's like it skipped from the list. Reason unknown. -On running I can see 4 application window get visible, and those didn't connect any kind of application. Also a Clipboard error message get visible, but I get a Clipboard cleaning macro, which several times cleaning the Clipboard, so it can't be. It's like a hack, or something which I don't recognize. - One a sheets called Total, I can't use the built in group function and can't collapse the selected section so the project I working on lost functionality. I didn't make any change on that side, but previously it was useable. Thanks for help in advance. Cheers. Zsolt
How to stop MS Word from saving doc and pdf files to the cloud
I'm on Windows 10 and Office 365. When I hit F12 on an MS Word file and save it as a .docx file or a .pdf file in a OneDrive folder: (1) the file does not immediately appear in the folder. (2) when it does appear, after more than 5 minutes later, it's on the cloud and it has be downloaded. (3) saving has become a lot slower. I'm not sure when I first noticed this but it has been a while. I've gone to File > Options > Save > Unchecked "Show additional places for saving, even if sign-in may be required". How do I prevent that? It slows everything down.Replying to emails from M365 Outlook group
A problem I am stumped with, so I am reaching out for some help/guidance. One group wants to not have the emails going into their own inbox but manage and reply only from the group inbox itself (so they know the email has been processed by deleting it once replied). It worked OK to begin with and then some users couldn't reply, then more. Some still can. I have tried reindexing local copy, using browser instead of app & changing the send on behalf of permissions. Owner or member of group doesn't seem to make a difference. Error messages include "This message can't be sent because it no longer exists. It can only be discarded. Make sure you copy the contents of the message before you discard if you want to use them later." and "Couldn't send this message". Please see screenshots attached. My questions: 1: Is Outlook on M365 designed to allow users to reply from the group either as the "group" or as themselves? Information I found isn't clear. 2: If it is / can be - what can I do to make it work for all users? Thanks!ChatGPT Enterprise Connects to SharePoint Online
OpenAI has launched a ChatGPT enterprise SharePoint Connector that allows organizations to synchronize files from SharePoint Online to ChatGPT. I could never understand why Microsoft 365 tenants allowed users to upload individual files from SharePoint or OneDrive to ChatGPT for processing. Using a connector to synchronize entire sites to ChatGPT makes even less sense, especially from a compliance perspective. I must be missing something! https://office365itpros.com/2025/10/13/sharepoint-connector-chatgpt/
Formule avec condition
bonjour J'ai un classeur de 13 feuilles, 1 avec les décomptes de mais différents repos, mes jours d'absences, mes nuits etc et 12 avec mon planning de chaque mois( noté de janvier à décembre), mon total de RU de départ est de 8(case B15 sur ma feuille décompte) et lorsque je faits plus de 5 nuits dans le mois( j'ai le décompte qui se fait sur chaque mois en case C12), je gagne 0,8 RU et je souhaiterai faire le rajout de 0,8 à chaque fois que la C12 de chaque mois est > 5 , en gros 8+0,8(si Janvier!C12>5)+0,8(si Février!C12>5)+0,8(si Mars!C12>5) .....+0,8(si Décembre!C12>5) Merci de votre aide
Remove sub-folder urls if the parent folder url exists
I have an excel sheet with one column which contain urls from sharepoint, the urls looks as follow:- /sites/Marketing/Budget /sites/Marketing/Budget/2015 /sites/Marketing/Budget/206 /sites/maps /sites/Expesnes /sites/Expenses/2020 now i want to delete all the sub-folders if their parent folder exists? so for example the above rows should be as follow:- /sites/Marketing/Budget /sites/maps /sites/Expesnes is there any script i can run to do this cleanup? ThanksCan't Install 365 on Mac Air Sequoia 15.7.1
I have a 2024 Mac Air with the latest Sequoia OS, 15.7.1. I am looking to replace MS Office Version 16.101 with MS 365. I have uninstalled 16.101 three times and then tried to install from the online MS 365 site three times, and each time I end up with the old Office 16.101, not 365. I have spent endless hours online and by phone with MS bots and personnel, and with the JustAsk technical "service" they referred me to (which was a waste of $45). No one has an explanation and they just keep telling me to uninstall and reinstall. There seems to be some technical incompatibility between 365 and my Mac, so when I go to download it feeds me 16.101 without explaining what that incompatibility might be. I'm not a techhead, but I have used Mac Airs for years and MS for decades without such problems. Has anyone else had such problems? Any suggestions? Thanks for any help.Maintaining Productivity During Hybrid or Phased Rollouts in Microsoft 365
Rolling out Microsoft 365 (M365) across an organization is rarely a single event — it’s often a journey. Whether you’re migrating from on-prem systems, introducing new collaboration tools, or enabling hybrid work capabilities, phased or hybrid rollouts are the norm. However, these staggered deployments come with a common challenge: how do you maintain productivity and minimize disruption when not everyone is on the same page — or platform — yet? Below are practical strategies and best practices to help your teams stay productive, connected, and confident throughout your M365 rollout. https://dellenny.com/maintaining-productivity-during-hybrid-or-phased-rollouts-in-microsoft-365-2/Microsoft 365 Tips for Non-Profits with Limited Budgets
Running a non-profit means balancing passion with practicality. You want to maximize your impact — but every dollar counts. Fortunately, Microsoft 365 offers powerful tools that can help you streamline operations, improve collaboration, and boost productivity — often at little or no cost for eligible non-profits. Here are some smart, budget-friendly ways to make the most of Microsoft 365. https://dellenny.com/microsoft-365-tips-for-non-profits-with-limited-budgets/Spell Number in Bangladeshi/Indian Style By Excel Formula.
On web there is SpellNumber() VBA custom function which spell numbers to word in million, billion. We Bangladesh, India, Pakistan spell amounts like lakh, crore etc. Here is a formula to convert amounts to word in Bangladeshi/Indian style. In attached file there is also a generalize LAMBDA() named function SpellNumberBD(). =LET(x,A2,lr,TEXT(INT(x),"00000000000000"),cr,LEFT(lr,7),lc,RIGHT(lr,7),dec,ROUND(x-INT(x),2)*100,c,CHOOSECOLS, digits,{"One","Two","Three","Four","Five","Six","Seven","Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"}, Tenths,{"Ten","Twenty","Thirty","Fourty","Fifty","Sixty","Seventy","Eighty","Ninety","Hundred"}, SPELL,LAMBDA(val,abr,IFERROR(IF(val<20,c(digits,val),c(Tenths,LEFT(val,1)) & IFERROR(" " & c(digits,RIGHT(val,1)),"")) & SWITCH(abr,6," Lakh ",5," Thousand ",3," Hundred ",1," Poisa Only.",""),"")), Taka,SPELL(--MID(cr,1,2),6) & SPELL(--MID(cr,3,2),5) & SPELL(--MID(cr,5,1),3) & SPELL(--MID(cr,6,2),"") & IF(--cr>0," Crore ","") & SPELL(--MID(lc,1,2),6) & SPELL(--MID(lc,3,2),5) & SPELL(--MID(lc,5,1),3) & SPELL(--MID(lc,6,2),""), Poisa,IF(dec<=0," Taka Only."," Taka And " & SPELL(dec,1)),TRIM(Taka & Poisa)) Alternate Download Link (Google Drive).
Inconsistent “Wrap Text” Behavior Between Excel Desktop and Excel Web
We’ve observed inconsistent behavior with the “Wrap Text” format across different Excel environments (Windows Desktop vs. Web). Steps to Reproduce: Create or open an Excel file. Enter multi-line text in several cells and enable Wrap Text. Save the file locally. Upload it to OneDrive or open it in Excel for Web. Observe the displayed cell content without resizing the columns or reapplying formatting. Observed Behavior: On Excel for Windows (Desktop) → Wrapped text displays correctly. On Excel for Mac (Desktop) → Wrapped text displays correctly. On Excel for Web → Text may not wrap properly by default, requiring manual reapplication of “Wrap Text.” Expected Behavior: Cell content formatted with Wrap Text should display consistently across all Excel platforms (Windows, Mac, and Web) without requiring manual adjustment or reapplication. Excel Mac Desktop: OneDrive:
Cannot Create Conversation on multiple ios and android devices with translator app.
Our schools heavily use the Microsoft Translator application on iOS and Android devices. Starting 10/2 all devices have started receiving the following error message "Cannot create a new conversation, please try again". This has been tested on iOS and Android devices and on multiple networks to verify the issue isn't related to filtering / firewall rules. Application has also been uninstalled / reinstalled and still receive the same error. It's clear this is affecting lots of customers yet we can't get any response from Microsoft on the issue. https://learn.microsoft.com/en-us/answers/questions/5580071/microsoft-translator-conversation-feature-stopped?comment=question#comment-2261689Setting Up Conditional Formatting in Microsoft Lists
Microsoft Lists is a powerful tool for organizing, tracking, and managing information. But beyond just storing data, Lists also lets you visually highlight important details using conditional formatting — a feature that can make your lists more intuitive and actionable at a glance. In this post, we’ll walk through what conditional formatting is, why it’s useful, and how you can set it up step by step. https://dellenny.com/setting-up-conditional-formatting-in-microsoft-lists/Conditional Formatting
Hello, I am developing a conditional formatting rule that allows me to enter a specific text value, and if it matches the content of another cell, that cell will be highlighted in green. However, instead of highlighting only the matching cell, the entire selected range is being highlighted each time I enter a text value.Microsoft Translator Conversation feature stopped working (“Unable to create new conversation”)
When trying to start a conversation, the mobile app (Android/iOS) shows the message: "Unable to create a new conversation. Try again." (Swedish version: "Det går inte att skapa en ny konversation. Försök igen.") About two weeks ago, the live transcription started to become very slow, with text appearing in large chunks instead of line by line. Shortly after that, the Conversation feature stopped working completely. We have tested this on multiple devices and platforms: – Android (several users, including myself) – iOS (tested by a colleague and a user we support) All users experience the same issue — no new conversation can be created. This function is used as a speech-to-text accessibility tool for deaf and hard-of-hearing users, so it is critical for communication support nationally in Sweden.
Recent Blogs
- Fight book bans, support independent bookstores, and more with Copilot!Oct 13, 2025
- You used to have to rely on external tools to crop a picture before putting it in OneNote. Not anymore!Oct 09, 2025
