Recent Discussions
Introducing Knowledge Agent in SharePoint (Public Preview)
In September 2025, Microsoft launched the Knowledge Agent feature in public preview for SharePoint, as part of the broader Copilot & AI investments. This marks a significant step toward making SharePoint not just a content repository but a more intelligent, AI-aware knowledge system. https://dellenny.com/introducing-knowledge-agent-in-sharepoint-public-preview/How to Migrate from Facebook Workplace to Microsoft Viva
As businesses evolve, the need for a more integrated, secure, and Ahttps://dellenny.com/how-to-migrate-from-facebook-workplace-to-microsoft-viva/I-powered digital workplace grows. Many organizations that initially adopted Facebook Workplace are now considering Microsoft Viva, a modern employee experience platform designed to work seamlessly within Microsoft 365. If you’re planning to migrate from Facebook Workplace to Microsoft Viva, this guide will help you navigate the process smoothly.
Word on iPhone
In the past, I’ve managed to edit some documents on my iPhone in Microsoft Word. But now Microsoft is slapping me in the face with grammatical suggestions that obscure my document. I don’t want any grammatical suggestions, but I can’t figure out how to make them stop. Can anybody suggest how I can do that? Am I in the right place to ask this question? Is there another place for the iPhone app?
max corresponding to a value which may be in 1 or multiple sets
Hi G6 is showing error because F6 is not found in D15:D50. what would be the simple process that F6 is searched in D15:D50 and D56:D91 and returns value from col K instead of an error whether or not that value exist in either of the sets.Unlocking Employee Potential A Complete Guide to Microsoft Viva Suite
In today’s digital-first workplace, employee engagement, well-being, and continuous learning are just as important as productivity. Microsoft Viva, an integrated employee experience platform within Microsoft 365, empowers organizations to connect, engage, and grow their teams seamlessly. Whether you’re a business leader, HR professional, or IT manager, the Viva suite offers tools to transform how your workforce collaborates and thrives. Let’s dive into its features, benefits, and how you can start using it effectively. https://dellenny.com/unlocking-employee-potential-a-complete-guide-to-microsoft-viva-suite/Microsoft Entra Suite The Future of Identity and Access Security
As organizations shift more workloads to the cloud, adopt hybrid and remote work models, and integrate multicloud environments, identity and access risk becomes a central security frontier. Traditional network perimeter defenses are no longer sufficient. Zero Trust is the guiding principle: no implicit trust, always verify, least privilege, assume breach. https://dellenny.com/microsoft-entra-suite-the-future-of-identity-and-access-security/
Best way to get rolling 12-month totals
I am using Excel for Mac version 16.102. I have data in a Table which is basically date, category & value. There are many other columns I use for filtering. I pivot this data to get totals by month within year but I hide the yearly totals and just have the grand total. My pivot table is filtered to include\remove high-level category data. I have a Timeline which allows me to select the date range of my pivot. I have a number of slicers to facilitate filtering to get the dataset totals I need. There maybe a better way but the above works. My ask is how do I go from the above to easily get a rolling 12-month totals for say Jan 24 - Dec 24, Feb 24 - Jan 25, Mar 24 - Feb 25 etc etc? I can move the timeline which gives me the correct answer but I'd like to be able to see the rolling totals for the last 12-months at a glance without having to keep moving the timeline. Eventually I'd like to graph the last 12-months so I can see movement over time. Can I do want I want with a pivotable or do I need another approach? Thank you for your help.
SEQUENCE formula with curly brackets
I have this simple formula, it works as expected up until the SEQUENCE part : In short rws would equal to 32, and srt to 1 I expected this to output the same as SEQUENCE(32,1,1,1), but it outputs just a single 1 I did check the evaluation process of the formula and it seems like this instead makes SEQUENCE({32},1,{1},1), and that, in a new cell does outputs the same single 1 What is it that i'm missing? Is it because of the LET function? Is there any fix to this? Thank you in advance! =LET( x,E1:E2288, y,SEQUENCE(ROWS(x)), z,FILTER(y,x=""), str,VALUE(INDEX(z,G1)), rws,VALUE(INDEX(z,G1+1)-str), SEQUENCE(rws,1,str,1) )Column width after Column Insert
Greetings. Is there a way to insert a column between two columns and have the column widths adjust automatically? For instance, Column A is 20 wide and Column B is 60 wide and Column C is 30 wide. If I insert a new column between A & B, I want the New column to be the default width, the new Column C (which was B) to maintain its width of 60, not change to 30. In other words, is there a way to have column widths shift with their columns?Locked out from O365 admin account
Hi! I am locked out from my non-protif organizations O365 admin-account. When trying to login, it ask for the authenticator code, but my authenticator app tells me to login and to login it needs an authenticator code..... I cant contact the O365 support since I cannot login. I found a phone number and talked to some AI bot, but it could not understand when I said the domain name of our organization and shut me down after 3 attempts. So - I have no way to login and handle my organizations account. Can someone please advice how to solve this, or how to get in touch with an actual human being in O365 support???Invited to external M365 group - how add to Outlook 365
Hi all, I have been invited to an M365 group from an external organisation. I have accepted the invitation. I can view the group via the link in the email. I expected the group to appear in Outlook 365 but it hasn't. Can I add the Group to Outlook manually, or at all? thanks j
User Microsoft 365 Apps Freeze when Trying to Save
Having a strange issue with one of our users when using Microsoft 365 Apps on a Windows 11 system. The original behavior reported was when he was trying to save a document to OneDrive. He gets a processing box but it never completes and the app freezes. Then he noticed if you just did a Save As from any of the Office Apps you get the blank page and the app freezes. Sometimes a reboot resolves the issue but only for a short time. Here are some items we have tried to this point: Have tried pausing synching in OneDrive repairing office 365 Reinstalling office 365 Saved to downloads > Can reopen document but when trying to save as again the page is blank. Will either have to force close in task manager or let it sit until "waiting for another application to complete an OLE action" then closing Pausing auto save to cloud in word/outlook/excel Disconnecting the OneDrive sync and re-connecting seem to work at first but after an hour or so we saw the same behavior. We decided to set him up on a brand new system and after we set things up the issue followed. We are seeing the same behavior on the new system. One item of note is we have a third laptop which has an old version of Office using the ODT installer which is working fine with his account. The other two laptops that are failing have the latest Office 365 software downloaded from the portal. Not sure if this is an issue on the backend with his account or some other type of issue. Just wanted to see if anyone has ran into this issue before. Thanks.Access Error on File Import through VBA
We are running a custom VBA routine in Microsoft Access that imports and parses text files into a database. Starting around September 9th, some machines began showing an error dialog during this process. The dialog mentions a failure in the VBA Regular Expression engine. The error does not occur consistently. On the same machine, the import may succeed several times and then fail (roughly 1 out of 4 attempts). The behavior appears to vary depending on the input file. The VBA code itself has been unchanged for years and continues to function correctly on older builds. We are wondering if this is related to a recent update in Access or the VBA runtime. Has anyone else encountered this behavior, and are there known workarounds or fixes? Going to leave version numbers out of this post because it keeps getting deleted and I'm not sure why. This is my 4th or 5th attempt to write this post and it keep getting auto-moderated.
Horizontal Scroll Issue
Since upgrading to Office 365 for my PC, I am encountering a display issue when using the horizontal (tilt) scroll function on my mouse. When scrolling horizontally the displayed columns will suddenly reset to before I started scrolling, but the highlighted cell position remains the same, and selecting a cell will select a cell on where is "should" be and not what is currently displayed. While this easily solvable by quickly scrolling up or down to "reset" the view to where it should be, it is annoying to do while trying to work. I am hoping for a solution to this.Looking up specific period financials from multiple period worksheet
Hello, I have the following sample data: The data from Column I onwards is in a different worksheet in the layout that you see above. I need to be able to bring in the July data as shown from Cols C to E. One easy way would be to concatenate the month with the Sector and Currency headings in rows 3 & 4. For example, JulyADRUSD and then do a nested xlookup to bring in July ADR USD Accounts Receivable information. However this would mean creating a new row for my concat field. Is there any other way we can fetch the required information? Hope you can point me in the right direction. Thank you.
Recent Blogs
- Formula completion autocompletes formulas when you type = by referencing the context of your workbook.Sep 26, 2025
- Whether you're a data engineer building pipelines or data analytics engineer looking to optimize your data model or data warehouse, Copilot in Microsoft Fabric is your intelligent partner for acceler...Sep 25, 2025
