Recent Discussions
Understanding OneDrive for Business and Personal Storage
In today’s digital-first world, cloud storage has become the backbone of productivity and collaboration. Among the most trusted solutions available, Microsoft OneDrive stands out for its seamless integration with Windows and Microsoft 365. However, many users often wonder about the difference between OneDrive for Business and OneDrive Personal — and which one is right for them. This comprehensive guide explores both versions in detail — their features, benefits, limitations, and best practices for using them effectively in 2025. https://dellenny.com/understanding-onedrive-for-business-and-personal-storage/Microsoft 365 Admin Center Overview for Beginners
If you’re just getting started with Microsoft 365 Admin Center (often called the M365 Admin Center), this article is your friendly walkthrough. We’ll explore what it is, how to access it, the key sections you’ll use as an administrator, and best practices to help you stay organized and secure. After reading this, you’ll have a solid foundation to start managing your Microsoft 365 tenant confidently. https://dellenny.com/microsoft-365-admin-center-overview-for-beginners-a-complete-guide/Collaboration Scenarios How Teams, SharePoint, and OneDrive Work Together for Seamless Productivity
In today’s digital workplace, collaboration is the foundation of productivity. Teams are often distributed across locations and time zones, yet they must share files, co-author documents, and communicate instantly. Microsoft 365 offers a powerful trio — Microsoft Teams, SharePoint, and OneDrive — that together create a seamless collaboration environment. While each tool has its distinct purpose, their true power lies in integration. Understanding how Teams, SharePoint, and OneDrive work together helps organizations avoid confusion, improve document management, and ensure smooth, secure teamwork. https://dellenny.com/collaboration-scenarios-how-teams-sharepoint-and-onedrive-work-together-for-seamless-productivity/How Microsoft Keeps Your Data Safe in the Cloud – A Deep Dive into Cloud Security Practices
In an era when organizations increasingly store sensitive information in the cloud, security and trust are paramount. Microsoft recognises this and has built a comprehensive security architecture that spans encryption, identity, physical infrastructure, compliance, and transparency. In this blog, we’ll explore how Microsoft keeps your data safe in the cloud — covering the major pillars of its approach, what that means for you, and how you can leverage this for your business. https://dellenny.com/how-microsoft-keeps-your-data-safe-in-the-cloud-a-deep-dive-into-cloud-security-practices/
EXCEL FORMULA INTEGRITY VALIDATION USING POWER AUTOMATE
OVERVIEW I built a Power Automate workflow to validate Excel financial models and alert errors in real-time. Excel Agent Mode can miss formula dependencies and reconciliation checks. This workflow ensures formula integrity and sends real-time email alerts when issues are detected. FLOW LOGIC Trigger – Starts when an Excel file in OneDrive is modified List Rows – Retrieves validation table Filter Array – Keeps rows where Status = "Error" Initialize Variable – Prepares summary string Apply to Each – Adds each failed check Condition – Sends email if errors exist Send Email – Include bold red highlights for errors SAMPLE EMAIL ALERT A validation error was found in your financial model. Net Income Flow-through: Error (11/04/2025 03:30) Test Error Trigger: Error (11/04/2025 03:30) Please review the Excel model and correct the issues. USAGE INSTRUCTIONS Upload your Excel file to OneDrive with the validation table Update the Power Automate flow to point to the correct file and table Ensure the Filter Array step checks Status = "Error" Save and test the flow; errors trigger email alerts Optional: Customize the email template for formatting or recipients WHY THIS MATTERS Excel Agent Mode may miss formula linkage or integrity issues Dependent relationships may be misinterpreted Workbooks may be modified without validation records This workflow ensures: Formula integrity is maintained Errors trigger real-time alerts Audit trails are preserved REFERENCE Microsoft Support: Agent Mode FAQ https://support.microsoft.com/en-us/office/frequently-asked-questions-about-agent-mode-in-excel-frontier-1cfd906d-40b4-46be-8e2d-65b893e28a02?utm_source=chatgpt.com GITHUB REPOSITORY For full workflow and files: https://github.com/olufemiolamoyegun/excel-formula-integrity-validation?utm_source=chatgpt.com
Can't Login to Authenticator App
I am unable to login to my Microsoft 365 Business account, because I'm unable to login to my Authenticator App. I am also the only administrator on my business account, so no one in my organization can help me. Microsoft online support and phone support just keep sending me in circles. The only way I see to create a support ticket is to login, but my issue is that I can't login. Help, please!
D365 F&O: dual write error
Hi all, I hope this is the right place where to ask my question. We have set up a dual write solution between D365 F&O and CRM Sales. In D365 we have an error when we create a new contact, it seems that the dual write is not correctly sincronizing for first the global addressbook table. How can we setup the dual write assigning priorities or syncronization sequences? Thanks in advance for your help. Andrea
Summarizing Text From Multiple Excel Tabs
I have created a workbook with several tabs. I have a tab where I want to capture a summary of data from the other tabs. The data I want to summarize is in cells where I have used data validation to create drop down boxes (Y/N). I have tried to summarize the number of Y's and N's using SUM and COUNTIF but neither have worked. I've looked at YouTube videos to help to no avail. I have even tried to do add the text in each cell manually and that didn't work either. I am not an expert in Excel so can someone please tell me what I'm doing wrong. I've been trying to figure this out for a couple of days.Effortless Time Tracking in Teams, Outlook and M365 Copilot
How do you stay in the flow of work when tasks move across Teams, Outlook and now M365 Copilot? Many of us already collaborate and manage our day in these Microsoft 365 tools, but logging time often feels like something separate that interrupts our focus. With https://www.klynke.com/ time tracking stays right where your work happens. It runs inside Teams, Outlook and M365 Copilot, creating one consistent and natural experience for logging hours without leaving your workflow. We shared more in our blog: https://www.klynke.com/post/log-time-in-teams-outlook-copilot, and were grateful that Microsoft featured our story in a Tech Community interview: Building Secure SaaS on Microsoft Cloud. A quick look under the hood Microsoft 365 SSO (Entra ID) – Employees sign in with their existing credentials Tenant-based storage and security – Data stays within your Microsoft 365 tenant, under IT control Native experience – Same workflow in Teams, Outlook and M365 Copilot Simple reporting – Export to Excel, Power BI or dashboards How do you currently manage time tracking in Microsoft 365? Would having it built directly into Teams, Outlook and M365 Copilot make a difference in your day? CTO at Klynke
Excel formula
How to revise the formula to become a string to calculate if the review year is not 36 months but can be 36 months or 48 months. The Original formula in column C is EOMonth(b3,36) column A column B Column C Document name Release date Next review date in 3 year time (mth-yyyy) Document management 1/8/2025 Aug 2028formula in excel
Dear Experts, i want to insert a formula in column C to auto calculate the next review date as shown. column A column B Column C Document name Release date Next review date in 3 year time (mth-yyyy) Document management 1/8/2025 Aug 2028 Question 1 I use formula using EOMonth(b3,36), it show 1/8/2028 and I dont know how to fix it to show only Aug 2028 ? Question 2 my column B format cell is Date format. What date format should i set in column C ?
Format cell border tab with limited line options
Several line options are missing from the dropdown menu (see the picture above). That is all the line options I get. I no longer have the thicker line option, double lines, or several other styles I used to have. My 365 is up to date. I need help restoring all the line options.
How do I propagate info from Master Tab to Other Tabs
I work with a group of retired teachers in Northern New York. We have a master list, but would like to generate separate lists (tabs) based on counties (sub-councils) of residence. I have attached a screenshot showing the general set up. Thanks in advance.
Le séparateur de milliers ne fonctionne pas dans Excel sur Mac
Dans les anciens fichiers Excel sur Mac, le séparateur de milliers ne fonctionne pas quand le format est "Feuille de calcul open XML strict (.xlsx)" alors qu'il fonctionne très bien avec le format "Classeur Excel (xlsx)". Mais dans "Enregistrer sous..." il n'est pas possible de changer de format. Merci de votre assistance !
Another issue with Value transformation.
I've played for a couple of days with this, having tried a number of different solutions that worked for others. Cannot figure out how to make a text field convert to value. Here is my XLS. I am running MS Excel for Mac, V 16.102.1 (25101829), Office Home and Business 2021. Years of my "moderate skills" applied with Excel but stuck on this transformation. https://1drv.ms/x/c/4d0957bca9736d6d/Ec0gUD0-JTlCsi2fCIg8bpUBvkTobtXpP5Mt-piIA90uqg?e=AGOdCD
Summing rows values while a specific column answers a specific condition.
Its much smaller than the sheet I work with but for this example I want to scan column 1 representative and if the value in a cell form A2:A6="D" I want to sum its rows. in this case I expect the answer 3+1+8+1=13. Tried the sumif but it works for 1 column at a time and not scanning multiplied arrays. Tried sumproduct and still couldnt get the cell to show the total amount. since in my actual worksheet there are 37X57 array, going manually and put formula in each specific row is less ideal soo I am looking for a specific command to solve it and calculate along the data that changes on the sheet.Nesting SortBy and Filter functions
Can someone suggest where I've gone wrong with this syntax please: =SORTBY(FILTER(Worklist,List!I2:I500=0),List!A2:A500,1,List!G2:G500,1,List!E2:E500,1) Currently returning the #VALUE! error. "Worklist" is a table on worksheet "List". All I am trying to do is to filter out all of the zero values in column 'I' and then sort the result by columns 'A', 'G' and 'E' I'm sure I'm doing something stupid! Many 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
- We’re thrilled to announce that Surveys Agent - your intelligent assistant for managing surveys end-to-end - is now generally available to all commercial customers worldwide with a Microsoft 365 Copi...Nov 10, 2025
- Thanksgiving and Christmas are fast approaching! Prepare for the holiday shopping and travel rush with Microsoft Copilot.Nov 06, 2025
