Recent Discussions
Side load office add-in?
I've created an office.js add-in that I can test with debugging in VS Code. I have deployed it including the manifest to a web site, but now I can't find the option to add it to my Excel anymore, where has that option gone? I'm on Microsoft® Excel® for Microsoft 365 MSO (Version 2602 Build 16.0.19725.20126) 64-bit Thanks GJ
unpivot data and handle merged cells without using Power Query (Unpivot_Toolkit)
Hey, guys!! I’ve been working on a set of functional Excel Lambdas to solve a common headache: transforming "Wide" human-readable data into "Long" database formats without having to open Power Query every time. =UNPIVOT_PLUS(table, [no_of_cols], [no_of_headers], [attribute_names], [value_name], [remove_errors], [remove_blanks],[pad_blanks_with],[pad_errors_with]) Don’t worry about the full list, most use cases only require 5 arguments. I've included a table of default values at the end. Merged Cell Support: Automatically handles fill-down/fill-right logic for merged headers/columns. Bonus Helper: SPLIT_INJECT =SPLIT_INJECT(array, target_indices, delimiter, [ignore_empty], [match_mode], [pad_with]) It targets specific columns, splits them by a delimiter (like TEXTSPLIT), and expands the entire table horizontally while keeping all other columns perfectly stable. Optional arguments match TEXTSPLIT defaults. Feel free to tear this apart or adapt it for your own edge cases. I’d love to hear how you end up using it! You can grab both functions from my GitHub Gist https://gist.github.com/Medohh2120/f8553c149684e39bb499249e39f01017. Argument Description Default Behavior table The array or range of data to unpivot. Required argument (no default) [no_of_cols] Fixed left columns to keep as identifiers. 1 [no_of_headers] Top rows used as headers, handling merged cells. 1 [attribute_names] Header name for the unpivoted attributes . "Attribute" [value_name] Header name for the unpivoted values. "Value" [remove_errors] Excludes grid rows with formula errors. FALSE [remove_blanks] Removes grid empty cells and empty strings. TRUE [pad_blanks_with] Value to substitute for empty cells. Leaves cell blank [pad_errors_with] Value to substitute for errors. Leaves error as-is
File always corrupt
Anyone have the same problem with me? I use microsoft excel 365 on my mac. At the beginning everything alright, until i use formula and then save the file. When i want to re-open the file, the messagebox showed up "we found something wrong in your content...". It gives 2 option, yes and no. If i click no, the file wont open. If i click yes, the file open, the excel do the recovery, the file open but end up with all the formulas is gone, deleted by excel and just left the value. What should i do? Do the file can still be fixed?
Copy and Paste Will Not Using the Destination Formatting
I am writing a book in Wood and will submit it to Amazon KDP, and I have set up the document per KDP guidelines. I am working on an English version and a Spanish version at the same time as two separate documents. The text is justified. Both documents have Normal/Modify settings set up exactly the same. The Fonts and Paragraph settings are exactly the same. I have gone into the Options/Advanced area of Word and played with all of the Cut, Copy, and Paste settings to try to fix my problem. But I can't figure out what is going on. I created the Spanish document by using Google Translate to take English paragraphs, translate them, and pasted them into the Spanish document The Spanish document is completed, and all of the formatting looks fine. So I already have paragraphs that are a certain size in the document, meaning they take up a certain number of lines. I am now editing the book using the English document. Something has changed with the Spanish document! If I make a small edit in an English paragraph, use Google Translate to deal with the edit and do a new translation, and then copy and paste that edited Spanish paragraph from Google Translate back into the same place as the original paragraph in the Spanish document, the words are slightly more compressed together, so the paragraph gets shorter! This happens if I even change just a single word in a paragraph, which has not really changed the length of the translation. The paragraph will become shorte by a half of a line, or a full line on long paragraphs. This is all becasue the words are being spaced slightly closer toegether now, versus when I originally crated the document. Also, when I start to do the paste, from Paste Option only get the option for "Keep Text Only." I don't get the multi-paste option box. Something has changed in my setup of Word from the time I created the original Spanish document, and what is happening now. I can't figure out why the formatting of the destination, or using merge formatting, is not working! It's making up it's own jutification spacing all of a sudden. I can't figure out why now a cut and pasted paragraph from Google Translate is making the spread between the words just slightly tighter. The latest thing I tried was Review/Language and choosing Spanish for the Spanish document, and that did not work. Any ideas? GordonPlanner’s Newly Redesigned Interface
Microsoft has launched a redesigned user interface for the Planner app. The big news is the inclusion of task chat. Goals are also available, but only to people with a Microsoft 365 Copilot or Planner Premium licenses. Task Chat is a nice feature, and I am sure that it will be popular. UX redesigns often disappoint. At least this one offers new features. https://office365itpros.com/2026/02/27/planner-new-ux/Extending Protection for Confidential SharePoint Online Files
Sensitivity labels offer great protection against unauthorized access, but sometimes files that aren’t encrypted escape from a document library. SharePoint Online can now use sensitivity labels configured with user-defined permissions (UDP) to extend protection to downloaded files. The magic works by configuring permissions on download based on the membership of the user who downloads a file. https://office365itpros.com/2026/02/26/sensitivity-label-extend-protection/
How to public mobile layout to web
Hi, I have prepared a Power BI dashboard using the mobile layout, and we would like to make this mobile view available on the web. However, I can only see it working in the Power BI mobile app, and I am experiencing difficulties when trying to implement it on a web page. Is there any way to publish the mobile layout on the web? If so, how? Thanks.How to Use Scoped Graph Permissions with SharePoint Lists
This article explains how to use scoped Graph permissions to restrict app access to lists and list items in SharePoint Online and OneDrive for Business sites. It's a follow-up to other articles covering how to restrict app access to SharePoint Online sites and files. Scoping app access to specific objects is important because otherwise apps can access everything in SharePoint Online, and that isn't good. https://office365itpros.com/2026/02/25/scoped-graph-permission-lists/Microsoft Extends DLP Policy for Copilot Protection to All Storage Locations
Microsoft has enhanced the DLP policy for Copilot to cover Office files held in any storage location instead of only Microsoft 365 locations like SharePoint Online and OneDrive for Business. The change is made in the Office augmentation loop, a little-known internal component that coordinates use of connected experiences by apps. Extending the DLP policy to cover all locations makes perfect sense. https://office365itpros.com/2026/02/24/dlp-policy-for-copilot-storage/
Excel workbooks keep breaking
Hi All, Sorry if this is not the right place to ask, I'm new here. Since a couple of days, my Excel workbooks keep breaking. When opening specific files, Excel states the file needs to be repaired. Everytime certain formulas are being deleted and the values are just pasted as is. I haven't had any issues with these files in the past. Previously I used a license which I bought online via a third party. It seems the issues started after an update. I switched to a license which I bought directly from Microsoft. I did a clean installation, removed all the previous versions files but the issue still exists. For a couple of days I can open the files without problems. And then yesterday excel showed an update was available and excel had to be reopened. After doing so, the issues came up again. I have a Office Home 2024 License, Excel version 16.106.1, on macOS Tahoe 26.2. T.I.AMicrosoft Takes Aim at ChatGPT
Microsoft would very much like Microsoft 365 tenants to use Copilot instead of ChatGPT. A recent comparison between Copilot and ChatGPT outlines some areas that Microsoft thinks are important when deciding which AI tool to use. Microsoft has a point because Copilot is embedded into Microsoft 365 whereas ChatGPT is more of an add-on. The competition for hearts and minds is very intense in the AI space. https://office365itpros.com/2026/02/20/copilot-and-chatgpt/Using Dev Proxy with the Microsoft Graph PowerShell SDK
Dev Proxy is a Microsoft tool built to help developers figure out the most effective way of using Microsoft Graph API requests. On the surface, Dev Proxy doesn’t seem like a tool that would interest people who use the Microsoft Graph PowerShell SDK to write scripts for Microsoft 365. But all tools have some use, and Dev Proxy can help. https://office365itpros.com/2026/02/19/dev-proxy-graph-sdk/How to Use Scoped Graph Permissions to Access SharePoint Files
Scoped permissions grant apps granular access to files and folders in SharePoint Online and OneDrive for Business sites using the Files.SelectedOperations.Selected Graph permission. The permission allows apps to access specific files or all the files in a folder. It’s a great way to make sure that apps don’t have unfettered access to confidential documents. Not that any app would try to have that kind of access… https://office365itpros.com/2026/02/18/scoped-access-files-and-folders/Modern SharePoint Architecture: Best Practices for Scalable Intranets in 2026
In 2026, SharePoint has evolved from being a basic collaboration portal into the backbone of digitally-connected organizations. With businesses demanding agility, security, and personalized employee experiences, the architecture of your SharePoint intranet isn’t just “plumbing” it’s a strategic asset that shapes how people work, share knowledge, and innovate. In this guide, we’ll explore modern SharePoint architecture principles, practical best practices, and technical steps that will ensure your intranet scales with your organization securely and intelligently. https://dellenny.com/modern-sharepoint-architecture-best-practices-for-scalable-intranets-in-2026/Concept Proposal: A Human‑Friendly, Voice‑Enabled AI Assistant for Microsoft 365
Title: Concept Proposal: A Human‑Friendly, Voice‑Enabled AI Assistant for Microsoft 365 Hello everyone, I would like to share a concept that could meaningfully enhance the Microsoft 365 experience and the evolution of Copilot. This idea is offered purely as inspiration for the product teams and as a starting point for community discussion. --- ## Concept Overview Imagine a modern successor to the classic “Clippy,” redesigned for today’s AI era: - A standalone assistant window that works alongside Word, Excel, PowerPoint, and other apps - Full voice interaction, enabling natural, conversational communication - Contextual awareness of the user’s work in Office, allowing the assistant to offer timely suggestions - The ability to propose and apply edits directly in documents or present them in a separate panel This approach keeps the assistant helpful but non-intrusive, supporting the user without taking over the workspace. --- ## Humanized Interaction For many users, AI still feels abstract or intimidating. Giving the assistant a warm, friendly, human-like voice and natural conversational behavior would make it more approachable and easier to adopt. A key element would be allowing users to assign a personal name to the assistant. This simple feature can significantly increase comfort, emotional acceptance, and long-term engagement—especially in voice-based interactions. --- ## Personalization & Monetization A voice-driven assistant opens the door to meaningful personalization: - Licensed celebrity or stylized voices - A marketplace for premium voice packs - Subscription tiers for advanced personalization This could create a sustainable monetization model while giving users more control over their experience. --- ## Ethical & Legal Considerations Voice personalization also introduces important risks: - Using the voice of a living person requires explicit consent and licensing - Recreating voices of deceased individuals raises moral and emotional concerns - Allowing users to upload voice samples could lead to unauthorized cloning and legal exposure To mitigate these risks, Microsoft could implement: - Strict consent and identity verification - Technical safeguards (audio watermarking, anti-cloning detection, usage logging) - Clear policies for voice licensing and takedown procedures - Default neutral voices for safe, compliant use --- ## Closing Thoughts I’m sharing this concept as a high-level idea for discussion and inspiration. I believe a human-friendly, voice-enabled, customizable assistant could be a natural next step for Microsoft 365 and Copilot. I’d love to hear the community’s thoughts and suggestions.
Formulaires Forms bloqués
Bonjour, J'ai réalisé 3 formulaires Forms sur Microsoft Forms d'un compte personnel Outlook. Les formulaires ont été distribués auprès de mes proches pendant 1 mois et demi (inscriptions pour un évènement). Soudainement, mon compte Microsoft a été bloqué et les formulaires ne sont plus accessibles depuis le lien de partage. J'ai récupéré mon compte Microsoft en changeant le mot de passe. Les formulaires sont toujours sur l'application mais je n'ai plus aucunes statistiques et ai perdu toutes les données. De plus les liens de partage ne sont toujours pas fonctionnels et les formulaires impossibles à copier. Comment puis-je récupérer les réponses et relancer le lien pour que mes proches puissent continuer d'y répondre ? J'ai demandé à l'assistance technique qui m'a redirigé ici. Bien à vous.Code Error Allowed Copilot Chat to Expose Confidential Information
A code error allowed Copilot Chat to expose confidential email. Microsoft is fixing the problem, but it’s a reminder of how AI can expose information of Microsoft 365 tenants don’t use available features to restrict AI access. Those features need to be configured and deployed, but that doesn’t take much effort. It’s better than users complaining when Copilot exposes their most secret thoughts. https://office365itpros.com/2026/02/13/dlp-policy-for-copilot-bug/[Update on Microsoft 365 Copilot Mac app issue]
We have identified the root cause of the issue currently affecting some users on Microsoft 365 Copilot Mac app, starting with version 1.2601 released on January 27. A fix has been prepared for the same and will be delivered via Microsoft AutoUpdate (MAU) within the next 48 hours. Please note that the app may not function as expected if MAU configurations are being managed through MDM. To mitigate, tenant administrators can remove the LCID key from their MAU configuration, as illustrated below. Kindly let us know if the issue persists for you beyond this timeline.
Events
You’re passionate about what you do, and we’re passionate about empowering your potential. Microsoft 365 Community Conference - is your chance to keep up with AI, build game-changing skills, and take...
In-Person
Recent Blogs
- Agent mode in Microsoft 365 Copilot Chat now enables you to query locally stored Excel workbooks on Windows and Mac desktop.Feb 27, 2026
- You can now have Copilot in Outlook reschedule personal appointments and one-on-one meetings if a conflicting event arises that takes priority.Feb 27, 2026
