Recent Discussions
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/How to Test and Roll Out New Features Without Disrupting Users in Microsoft 365
Microsoft 365 evolves constantly, with new features and updates rolling out regularly. While this innovation is great, IT admins often face the challenge of introducing changes without overwhelming end users or disrupting business operations. The good news? With the right approach, you can test, validate, and roll out features in a controlled way that boosts adoption and minimizes risk. Here’s a step-by-step guide. https://dellenny.com/how-to-test-and-roll-out-new-features-without-disrupting-users-in-microsoft-365/Understanding the Microsoft 365 Roadmap
The Microsoft 365 ecosystem evolves rapidly, with new apps, features, and security enhancements rolling out almost every week. For IT professionals, business leaders, and even everyday users, keeping up with these updates can feel overwhelming. That’s where the Microsoft 365 Roadmap comes in—a central hub designed to help you anticipate, plan, and take advantage of what’s coming next. https://dellenny.com/understanding-the-microsoft-365-roadmap/
Excel Web- Lost Power Query Button
Last week, I had a Power Query button in Excel web. It worked great. I created my Query and such. I connected to the Dataverse. Today, I open Excel Web and the button is missing in the Data tab. Not only that, but my PQ table crashes every time I try to update it. I am not sure what is happening, but I need this functionality back. PS. Excel desktop (macos) is missing the dataverse option too and opening the same file in desktop, tells me that OAuth is not working or something, when I try to update the table. I am lost...
Long data copied to wide data
Hi, I am trying to do exam analysis and need to copy data from Excel (see image) into my home-made analysis sheet on Numbers mac (see image). The trouble is the exam board data is in a long format data sheet while my numbers table is in a wide format. I have tried copy/paste special/transposing but all that does is run all the candidate names horizontally along with the data horizontally (see image). What I am looking to try and do is have the candidate names go down in a column and have the data from each question run horizontally across from their name. How can I do that? Any help would be immensely appreciated - I have been at this for 2 hours now and am sure I could have just single-copied all the data by this point!!!
Having trouble with IF formula
Hello, I'm not sure what's going on with my formula, but it is supposed to double the "Grip" when a checkbox is checked. All the numbers being pulled from tables are correct and when not checked the "Grip" adds up correctly. When doubled, it is also adding the "Wall Thk." number an extra time. Correct single Grip = 1.625" Correct double Grip = 3.25" I get 3.5" for double grip. Formula used below, as well as pictures. If my formula is wrong, then I can't see it, but it has to be adding T8 somehow. =IF(X8,((INDEX(DATA_THK,MATCH(1,(Flg_Thk[Spec.]=N8)*(Flg_Thk[Series]=O8)*(Flg_Thk[Class]=P8)*(Size=Q8),0),MATCH(R8,FLG_TYPE,0))+T8*(R8="Lap Joint (LJ)")+V8*(U8="RF"))*2),(INDEX(DATA_THK,MATCH(1,(Flg_Thk[Spec.]=N8)*(Flg_Thk[Series]=O8)*(Flg_Thk[Class]=P8)*(Size=Q8),0),MATCH(R8,FLG_TYPE, 0))))+T8*(R8="Lap Joint (LJ)")+V8*(U8="RF")Excel - Matching outgoing to incoming inventory based a specific conditions
Hello, I wonder if anyone here can help me. I have created an inventory tracking file in excel but I have encountered a difficulty that I cannot seem to find an answer for. I have sequenced each incoming shipment but I am unable to sequence or match or track outgoing shipments automatically based on specific conditions: I need to assign #1 to outgoing shipments until outgoing piece count of 25 is reached, then #2 until 20 is reached and so on When incoming and outgoing piece count net out to 0, I need the status to be "Closed", when we've started pulling from but not emptied out yet, "In progress", and when untouched "Open" I would like outgoing to be link to earliest, not closed, incoming shipment. Of concern: "Out" and "Status" columns Can anyone help with this? Thank you! Christine
Filter function with a criteria
Dear Experts, I have a data like below( in columns A/B/C) , and needed the result in column (I/J/K), but I could achieve only like in Column (E/F/G) For example for the rnti = 19453, the corr0 , at time -> 06:34:32.171912 is not there so at Row-3, the entry should be empty Attached is the worksheet, Br, Anupam
Word on line
Prezados bom dia, Estou com problemas no uso do aplicativo, pois ao realizar o documento no programa no computador e subir ele no on drive ele abre desconfigurado on line, com modificaçoes de margens, fontes e ao abrir de novo no programa ele fica desconfigurado também. Estou tendo o retrabalho de ajustar a formatação do documento várias vezes. Além de não conseguir usar recursos on line como referenciar a legenda da foto e indice para poder só mexer no arquivo on line.How to restore the option to delete row in the edit drop down menu in Excel Checkbook 2023
I just downloaded excel checkbook 2023 and am setting up my register. Originally I had the option to delete row in the edit drop down menu, but then after deleting a column I now only have the option to delete columns. I want to restore the option to delete a row instead of deleting columns. How do I do that?Form does not exist
I recently printed some leaflets with the QR code and URL to my forms and had 40+ responses. I had made some minor changes to the form and the outcome of the blue when you scan the form you get an error message that read "the form does now exist".... The thing is ,it does exist. It's not in the deleted bin it's active, it's just upon further exploration I can see the QR code and URL has changed. I have been using the tick box that says make URL shorter...could it be that? Does this change the URL and QR Code every time you press it?
Excel 365: dd-mmm-yyyy now gives Sept instead of Sep
Excel 365: dd-mmm-yyyy now gives Sept instead of Sep — that breaks the documented format standard. Who thought this was a good idea? They linked it to the Unicode locale standard. But it violates the formatting of "mmm". Work arounds for USA locale format as [$-409]dd-mmm-yyyy → 05-Sep-2025 UK locale [$-809]dd-mmm-yyyy → 05-Sep-2025 AU [$-C09]dd-mmm-yyyy → 05-Sep-2025 NZ [$-1409]dd-mmm-yyyy → 05-Sep-2025 Problem is this is not portable. PLease can someone reach out to the devs and get this reverted? Formulas trying to pick out Sep & year from the string now will break.Copy and paste doesn't work!!
Hi, I've been running 365 and have been using word with out a problem for quite a long time. recently however I've noticed copy and paste simply doesn't work! I can not click say inside a document and then move the cursor forward to highlight say a few lines and then right click to copy let a one paste! What happens is if I right click and hold and attempt to move the cursor it simply does nothign and instead a small tool panel opens up offering the choice of colour, changing to italic, bold etc and then a dialogue box opens saying, 'Start a conversation'!! Its immensely frustrating, I've tried all manner of things to correct this including uninstalling and reinsalling word. The same thing happens to all my word docs which makes me think it must be a setting but I can't see what! I've played around with the review tab, editing tab etc and nothing seems to work. At wits end here, any ideas please do put them forward and thanks for your help. PaulaMy Azure login is stuck at MFA and cannot proceed
In August, I was still able to log in to Azure, and by logging in through GitHub I could bypass 2FA. But now, no matter how I try, logging in via GitHub always requires 2FA. I can’t access my Azure account anymore—nothing works. The system prompts me to use Microsoft Authenticator to confirm a two-digit code in real time. My Microsoft Authenticator on my iPhone is logged into the same Microsoft account, but I’m not receiving any verification requests for Azure login. No matter how much I refresh, nothing shows up. I’ve already updated the Microsoft Authenticator app to the latest version from the App Store. However, my personal Microsoft account works fine and can log in without any issues.
Recent Blogs
- This podcast-style recap will summarize key topics and takeaways from a single or multiple meetings in minutes.Sep 05, 2025
- Your product will still work, but when Microsoft says a product has reached "end of support", it means the product will no longer receive: Security updates Non-security updates Bug fixes Ne...Sep 04, 2025
