Recent Discussions
CoPilot has suddenly stopped working in Word?
CoPilot suddenly stopped working in Word this morning. After any prompt I enter I get an "Oops, something happened. Can you try again" error message. The error occurs in both the desktop app and web versions of Word (CoPilot is still working fine in Excel, Outlook etc). The issue is not limited to one device or version of Windows - I have Windows 10 on a PC and Windows 11 on a laptop. I have engaged with Microsoft Help Support via chat and after multiple efforts to try and resolve the issue, the suggestion from the agent is that it may be related to a server-side service disruption or a backend issue rather than Word itself. Very frustrating! Is anybody else experiencing the same issue and have you been able to resolve it?
Blocked out of my email
Cannot sign in to email after travelling. I have sent off over 10 account recovery forms with no replies back. My old mobile number is linked to the account so I cannot get a text verification, I also rang the old number and they are not willing to help. And it is so hard to speak to a real person from Microsoft to fix this, I managed to get an agent once and they tell me to fill out another form which clearly is getting me nowhere.Braille Translator Challenge
Using the Braille Alphabet lookup table provided: Part 1 - convert the given phrase from Braille to words. Part 2 - convert the given phrase from words to Braille. ✅ Solutions should be in the form of a single-cell formula. ✅ Generalized Lambda functions are welcome, provided the function definitions are included with your solution. ✅ Keep in mind, the "best" solution is not necessarily the shortest... Strive for conciseness, if you wish; just don't let your solutions be ordinary. 😉 Good luck and have fun!
Planning a Google Workspace to Microsoft 365 Migration? What Should You Consider?
Hi everyone, Has anyone recently migrated from Google Workspace to Microsoft 365? I’m interested in knowing what challenges you faced during the migration, especially around mailbox data, calendars, contacts, user mapping, or the final cutover process. For those planning the migration, what are the key things you recommend preparing before getting started? Would like to hear your experiences and suggestions.BigSpill: A 92‑Function Excel LAMBDA Library for Dynamic Arrays
What is BigSpill? BigSpill is an Excel LAMBDA library containing 92 functions across 10 categories, built from extensive experimentation with dynamic arrays. The goal is to provide elegant, efficient tools that make sheet‑level formulas easier to read, more modular, and more dynamic. The library includes a mix of: quality‑of‑life helpers essential primitives mid‑level operators developer‑level tools a few functions you might not expect to see in Excel Who is it for? Everyone. BigSpill aims to make complex operations more approachable and expressive. A few examples from the library: Pairwiseλ Staircaseλ Grainλ PolarGridλ Convolveλ Foldλ Tessellateλ Revealλ Knapsackλ Magnifyλ Traverseλ The repository includes full documentation and 11 sample workbooks so you can explore the functions without setup. If you’re interested in experimenting with dynamic arrays, or LAMBDA workflows, feel free to take a look. Feedback and suggestions are always welcome. I've attached 1 onboarding workbook. There are 10 more at the link below. GitHub: BigSpill
Does a LET variable get computed even if it's only referenced inside IFNA's fallback argument?
In the formula below, expensiveMatch is defined in LET but only referenced as IFNA's fallback argument: =LET( matchRow, XMATCH(1, (A1=Sheet2!$A$1:$A$1000)*(B1=Sheet2!$B$1:$B$1000)), x, INDEX(Sheet2!$C$1:$C$1000, matchRow), expensiveMatch, INDEX(Sheet3!$C$1:$C$500, XMATCH(A1&B1, Sheet3!$A$1:$A$500&Sheet3!$B$1:$B$500)), IFNA(x, expensiveMatch) ) Question: When x resolves successfully (no #N/A), does expensiveMatch still get computed because it's a top-level LET variable - or does Excel skip it since IFNA's fallback argument is never reached? I know IFNA short-circuits its fallback argument, and LET avoids recomputing a variable if referenced multiple times - but I haven't found much documentation on the behavior of Let. Is the below a more efficient way to write the formula? =LET( matchRow, XMATCH(1, (A1=Sheet2!$A$1:$A$1000)*(B1=Sheet2!$B$1:$B$1000)), x, INDEX(Sheet2!$C$1:$C$1000, matchRow), IF(ISNA(x), INDEX(Sheet3!$C$1:$C$500, XMATCH(A1&B1, Sheet3!$A$1:$A$500&Sheet3!$B$1:$B$500)), x ) ) Is this restructuring necessary, or does the first version already skip the unused computation? Basically I'm wondering if Let computes lazily/defers calculation in the way SQL's optimizer works. Input from anyone with insight or knowledge into the calc engine would be greatly appreciated. Thanks (Currently on Microsoft Excel for Microsoft 365 MSO (Version 2607 Build 16.0.20228.20190) 64-bit)
Referenced cells do not identify themselves with color
For some reason when I create a formula that references other cells, I cannot get those cells to "identify" themselves with a specific color. For example, in the image below the formula references cells B7, B8, B6, etc but they are just black text and don't show up in color per standard excel documents. Usually they "glow" with a specific color so you can find them easily in big spreadsheets. How do I get the colors back?
Microsoft 365 Developer E5 license lacking endpoints and device ON defender portal
Dear Support Team, I am a microsoft certified trainer (MCT). I currently have a Microsoft 365 Developer E5 license assigned to my tenant. However, I have noticed that my Microsoft Defender portal (security.microsoft.com) is missing several critical features. For example, I cannot see the Endpoints or Devices menus, which is preventing me from implementing and testing Microsoft Defender for Endpoint. Additionally, my Azure tenant and Microsoft 365 tenant are separate. This has created challenges when configuring security services such as Microsoft Sentinel (SIEM), as certain prerequisites and integrations require configuration through the Microsoft Defender portal. Due to the missing Defender features, I am unable to complete the necessary setup. I would appreciate your assistance in understanding: Why the Endpoints and Devices sections are unavailable in my Defender portal despite having a Microsoft 365 Developer E5 license. Whether additional licensing, onboarding steps, or tenant configurations are required to enable Microsoft Defender for Endpoint features. How best to integrate or align my separate Azure and Microsoft 365 tenants to support services such as Microsoft Sentinel and Defender XDR. These issues are significantly impacting my ability to evaluate and implement Microsoft's security solutions. I would appreciate any guidance or recommendations to resolve them.
Inconsistent behaviour of AccessRuntime and Access (Developer Version) - Office 365
I am using Access Version 2608 (Build 20326.20132) and I am having big problems because of a differnt behaviour of Runtime and Full (same version). When setting a short timer (for initialisation / 10ms) within the Form_Load event, the timer starts in the "Full-Version" of Access365 immediatly after finishing the Form_Load event (not further action in the other events). The Runtime-Versions don't accept the Timer-Value I set befor in the Form_Load event. Remark: With an old version (I don't know which one, because all customer PC were updated) it works perfekt, also with AccessRuntime. A very old customer installation (16.0.18827.20164) works perfekt. What can I do, because the application is broken down at many customer sites ... and I have to solve this problem very urgent.
Advanced Filter
Hello. I created a filter that has 2 conditions. 1. If the Ref Cert or the SK Cert is YES, bit should appear. The problem is that if the columns with Ref Exp or SK Exp is blank, then it gives me a 0 or if it does have a date, then it gives me the number equivalent. The original table, it does have dates. I tried to format the columns so it would give me an actual date, but it doesn't work. It only works for the blank cells. This is the actual formula. =FILTER(C3:N500,((H3:H500)="YES")+((J3:J500)="YES"))&IF(ISBLANK(I3),"",I3) Array is C3 : N500 (This is the table where is information is coming from) Ref Cert is H3 : H500 SK Cert is J3 : J500 This is what the finish product looks like.Preparing a Microsoft 365 Tenant for Copilot in Late 2026
Forty months ago, Microsoft launched Copilot. Looking back, the lack of guardrails at the time was staggering, and AI had a great time wandering across SharePoint, OneDrive, Teams, and Exchange. Now Microsoft Copilot is a unified client and there’s a bunch of essential steps for tenants to take to keep AI processing under control and their sensitive and confidential information safe. Here’s what we know about implementing Copilot in late 2026. https://office365itpros.com/2026/09/04/microsoft-copilot-in-2026/Simply cannot delete a section break. It is impossible. Cannot be done. Please prove me wrong.
So I was introduced to section breaks as a means of getting page numbering up-to-spec for book I've written (roman. numerals in the front material, arabic numerals in the book itself). I'm using the latest version of Word (16.8?) on Mac. To my horror, I've found that it is impossible to delete section breaks once they're in my document. I have spend an entire day in Google on this subject, and every single suggestion fails. So I have enabled showing markup, so I can see page breaks, section breaks, paragraphs I cannot select a section break. Word will not allow that. So I can't select and delete it. I cannot put the cursor after a section break and then hit the delete button as many suggest. Word will not allow the cursor to be placed after a section break. Putting the cursor before the section break, as other articles recommend, is just wrong. All you're doing there is deleting text before the section break. Why is this so hard? I've lost a whole day on something that should be simple. In the screenshot from my document below, The section break simply cannot be touched.Please Help_ Disappeared Excel Doc
Dear Expert, I just lost my Excel Document that improved after I have downloaded from the Chat GPT. I have improve many different sheets on the documents but it is now only see the excel sheets that I made yesterday. I can only see the last page I improved today. Please help me.Microsoft to Stop Providing Telephony-Based Authentication Methods for MFA in February 2027
In an important announcement for all tenants, Microsoft revealed that Entra ID will no longer provide SMS one-time codes or voice calls for MFA challenges after February 1, 2027. Tenants can continue to use telephony-based authentication methods after that date, but only by purchasing a service from a telecom provider. This is arguably the biggest change in Entra ID authentication since mandatory MFA for administrative interfaces – and we have a PowerShell script to help identify the affected accounts. https://office365itpros.com/2026/07/14/entra-sms-one-time-code/Excel Copy & Paste / Clipboard
When I copy one or multiple cells from excel, and then go over to another program on my computer and use the "copy" function again, and then go BACK to excel, and paste in a different cell - the original copy from excel is the one that pastes. It's almost like the second copy function from another program on my computer does not slate clean the clipboard - and almost like the excel has its own clipboard that separates itself from the rest of the computer. If i copy a cell in excel, and then copy other stuff from a different program (non microsoft, microsoft, anything really) I want the original excel copy to CLEAR. This is something new and randomly starting occurring over the past year or so to me and all my colleagues. This problem is most prevalent with Bloomberg for me fyi. Thanks for any help!
Formatting issues in Word Microsoft 365 Copilot online.
I am experiencing formatting issues in Word (Microsoft 365 Copilot online). I am a student, and I have a problem formatting my thesis in M365 Copilot after previously working on this file on an older device with an older version of Word. I recently purchased a new laptop, where I no longer have access to that same version of Word. My only option now is to use Word in the browser. However, the file that formatted correctly on the old device is now not formatting properly. The automatic table of contents is breaking. After clicking “Update,” Word assigns random page numbers, most often all entries show as page “8,” or, for example, the “Introduction,” which is actually on page 3 (I manually set page numbering in the old version), suddenly appears as page 5 in the table of contents. Every chapter and subchapter is shown as being on the same page, usually page 8. The formatting options and capabilities also seem worse compared to the interface of the older version. The same issue occurs on my student account. Please help, I am currently writing my thesis.
Recent Blogs
- Zoom from 10% to 1000% Supported Access views can now be zoomed anywhere from 10% to 1000%, expanding the previous range of 50% to 500%. New 10%, 25%, and 1000% choices are available in the Zoom me...Sep 04, 2026
- We’ve rounded up some of the most popular features to release lately in your favorite apps. It’s not too late to try them out!Sep 03, 2026
