Recent Discussions
Leveraging SharePoint for Performance Tracking Monitoring Team and Project Progress
SharePoint is more than a document management system; it’s a comprehensive platform that facilitates real-time tracking and collaboration. Here’s why it excels in performance tracking: https://dellenny.com/leveraging-sharepoint-for-performance-tracking-monitoring-team-and-project-progress/
Pivot table
having an Excel workbook with multiple sheets. each contain certain data and a pivot table in each one. recently started having problem that is when I copy a pivot table from an existing data sheet to a new inserted sheet and then changing the source of data to the new sheet and then refresh the pivot table then save and close the file; then when I try to open the file again I got an error and the most recent pivot table get deleted. tried several ways to solve the issue with no avail noting I'm using Microsoft 365 for Mac. appreciate any help
Help with data and visuals
I hope i can explain this right, i have data that shows 3 things: person, start date and end date: now i need excel to take this information and represent it as the following in the month tracker: It would look for the charts and figure out the timeline and add them to a row with the timeframe: example is Booy 15-0ct-25 to 23-oct-25 the char would go to the next one and add his information, I hope someone can help me. I just need it to populate the month tracker, Thanks
Language defaults audit for everything M365
We are struggling to find where and how the wrong language is being used for various parts of the M365 platform. We have Swedish set as default, but still English is used for a number of places which often are only realized as a consequence by a user. For example, in Viva Engage language is set to Swedish, and for the SharePoint as well. But: When a new user logs on VE is in English While the SharePoint web part is in Swedish, the link text have for some time ended with "- Home" (English) instead of as it was when we started 2+ years ago " - Startsida" (Swedish) Then when creating a VE group Event (Teams-meeting) default language is also English Tracking down what and where is making the wrong language being used is hard. I would be very grateful if pointed to a resource that give an as complete as possible overview of everything in M365 that we need to look over for making sure that the correct language is default everywhere it should be.
Allowing Users to Add Enterprise Apps to Entra ID is a Bad Idea
Enterprise apps can come from a variety of sources. Most are Microsoft 1st party apps, and the rest are ISV apps. It’s easy to add an app without really intending to, which is a good reason to force users through the Entra ID app consent workflow when they want to add an app. Unhappily, I failed the test and added an app in a moment of weakness. Here’s what happened. https://office365itpros.com/2025/10/24/enterprise-apps-my-mistake/
Excel jumps to A1 when selecting a range on another sheet during VLOOKUP
Hi everyone, I’m experiencing a strange issue in Excel and I’m hoping someone can help. Steps to reproduce the problem: Open a workbook with at least two sheets (Sheet1 and Sheet2). On Sheet1, start typing a VLOOKUP formula When selecting the table array range, switch to Sheet2 to select the range. Excel unexpectedly jumps the selection or view to cell A1 on Sheet2, losing the intended range selection.
Query failure in Windows 11
Hi I just had a new computer at work, and changed from windows 10 to windows 11. I have a query, which compare 2 tables, and add rows in table2 that dont exits in table1. This has been working for years, but now it, only sometimes, double all the rows. INSERT INTO MPS Columns from Table2 (Access linked to sharepoint) SELECT MPS2. Columns from table1 FROM MPS2 WHERE not exists (Select 1 from MPS WHERE MPS.[MPSid] = MPS2.[MPSid]); It compares a unik field MPSid It doubles the rows sometimes, and the MPSid is the same, in the doubled rows Has something changed, or is there a workaround? Best Regards Tonywhy is excel changing a formula in a locked and protected cell
I have quite a complex spreadsheet for use in my hobby of PBM - the spreadsheet includes an order form for players to submit instructions but with 1 player i am experiencing problems that I cannot fathom why it is happening Upon emailing my spreadsheet, one of the cells in a hidden and protected part of the form keeps changing, the formula changes for no obvious reason creating an error as it is then trying to bring in/read data from an invalid cell. This only happens with this 1 person, everyone else who receives the exact same spreadsheet has no issue, the formula does not change and the spreadsheet works as intended - just not for this one person. the cell is hidden and protected, the sheet is also password protected - it should not be possible for this cell to change but it does. Does anyone know why this might be happening? Both myself and the recipient of the spreadsheet run office 365 so there should be no issue with compatibility. as i say it is happening only to this one person, nobody else, and i do not understand why - looking for ideas on how to resolve this issue!!Nested App Authentication (NAA) token to protect middle-tier server
I'm working on an outlook addin and want to use the NAA accesstoken to validate the user on an api running on a php webserver. The addin runs as a taskepane (created with yo office) with the app only manifest. I have setup NAA to do Microsoft graph calls on behalf of the user. I have used this guid to setup NAA (copy/past) https://learn.microsoft.com/en-us/office/dev/add-ins/develop/enable-nested-app-authentication-in-your-add-in I have setup a php server (not in Microsoft infrastruktur) for a simple API, that handlers MySQL calls and app only calls to Microsoft graph. The php api authenticate itself with a client secret from the Azure app registration. Both are working as expected. Can i use the accesstoken from the NAA, to authenticate the user on the php server? If it can be done how do I validate the token?Updating the Entra ID Password Protection Policy with the Microsoft Graph PowerShell SDK
The Entra ID password protection policy contains settings that affect how tenants deal with passwords. Entra ID includes a default policy that doesn’t require additional licenses. Creating a custom password protection policy requires tenant users to have Entra P1 licenses. As explained in this article, once the licensing issue is solved, it’s easy to update the policy settings with PowerShell. https://office365itpros.com/2025/10/23/password-protection-policy-ps/
Delete cells with 3 consecutive consonants
I submitted a question a little while back asking how to delete cells with exactly 3 consonants. The response I had was a huge help, but now I'm faced with a similar problem: How do I sort words by consecutive consonants? And if that cannot be achieved, how can I instead delete cells from a sheet in which a word has 3 consecutive consonants?My Outlook.com doesn't receive NDR (non delivery report)
Hi, I have a personal email on outlook.com (with Microsoft 365 Familly). I always use the web client from https://outlook.live.com. If I send an Email to a non existant address, I never receive any NDR. I have check my spam folder, there is nothing. I have no rules, no Email transfert, no IMAP configuration, no POP configuration, ... That seems useless, but some time I wait some answer from people, and I discover after weeks that I have made a small error in their Email. I already miss important business because off that. And I can't call my client each time I send an Email to be sure they get it. How can I receive the NDR ? Thanks for your help.What is the best OKR Software for Microsoft 365?
So... It is finally happening. Viva Goals is less than two months from shutting down. With Viva Goals having been built by Microsoft for Microsof users, it had a certain advantage over other apps in the app store. So now, what do you all think is the best OKR Software for Microsoft 365? Because I'm pretty sure even though they were warned well in advance, there are probably some organizations still using Viva Goals that will need to switch fast!Taking text from a multi-line cell and making each line its own row.
Hello, I have a sheet with several thousand lines that I pulled from my current system, and all of the data was exported into cells like this: What I would like to do is take each line and make that line its own row in the sheet. For example, the scooter would have its own row, the MWC have its own row, so on and so forth. Is there any way this is possible, or should I be looking to see if there is any other way I can export this data?
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
- You can add Copilot to an existing Teams chat, or start a new group chat directly from a one-on-one conversation with Microsoft 365 Copilot.Oct 24, 2025
- Use Copilot to decipher complex health or finance terms, or find out more information about your company's benefits provider.Oct 23, 2025
