Recent Discussions
OneDrive Sync Client Changes How It Processes Deleted Files
Microsoft plans a May 2026 update for the OneDrive Sync client to improve the way that the client handles the deletion of files stored in SharePoint Online and OneDrive for Business. The client will no longer move the local synchronized copy of the deleted file into the workstation’s recycle bin, meaning that the only copy is on the server. The change removes complexity and should improve performance. https://office365itpros.com/2026/04/27/onedrive-sync-client-deleted-files/
Word Version Incompatibility
Good morning everyone, I've switched from Microsoft 365 Personal to Microsoft Plus 2021 Business. My question is, is there any incompatibility between the Word versions of these two services? I ask because when I try to work with a file saved as a "Microsoft Word 97-2003 Document," I get a memory error message. However, when I save the same file as a "Microsoft Word Document" and work with it, I don't get the error message. Looking forward to your kind reply. Fernando
Spreadsheet corrupts upon saving it
After reaching out to MS Support regarding this, they suggested I post my issue over here. Starting this week, a spreadsheet that I've been using for years is no longer working. When I launched it yesterday, it opened without issue as it usually would, I was able to make some edits and save. But after opening it up again, it came up with the prompt: "We found a problem with some content. Do you want us to try to recover as much as we can?". After clicking on Yes, comes up with "Excel was able to open the file by repairing or removing the unreadable content. Removed Part: /xl/drawings/drawing1.xml part. (Drawing shape)". At this point, I restored a saved copy from backup (from around five days prior). Once again, file opened and was working fine, but only after saving it would it corrupt upon reopening. To make the issue even more strange, this same behavior is now retroactively occurring if I try to open a template version of this spreadsheet I had saved from 2024, or even as far as 2020. It's almost like an update was pushed which made objects used in this spreadsheet retroactively no longer viable and corrupted. This behavior is not occurring on new spreadsheets I create, nor other ones I tested that are completely different to this specific spreadsheet I'm referencing above; though I haven't tested every single spreadsheet on my system. I've tried repairing MS Office, I've tried saving as different extensions (i.e. from xlsm to xlsx), but no matter what I try, this spreadsheet and any version of it historically saved (and I have years worth of copies) are now all exhibiting this error if I open and save them. Thoughts?Bold Duplicates (Conditional Formatting)
Hello experts I have a form based on qryLCAmends I want to bold the [LCNo] if there is a duplicate but ONLY where LCID = LCID here is what I have but it doesnt bold anything: DCount("*","qryLCAmends","[LCID]=" & [LCID] & "[LCNo]='" & [LCNo] & "'")>1 LCNo is text. I am using the "expression" in conditional formatting: Example: How can I do this with conditional formatting?
Word freezes or crashes when pressing the G key in the file search
When pressing the letter G in the file search on Word, it either just freezes and doesn't respond or crashes immediately. Regardless of whether Word is in Safe Mode or not. It also pops up a "Word couldn't start last time" pop-up when I try to open the app again and asks if I want to open it in Safe Mode. Which, as I said, still has the same problem. As far as I can tell, that's the only issue with Word. Everything else works great so far. This does not happen with other apps like PowerPoint or Excel. I have only recently reinstalled all the apps and it does not seem to have helped. Windows 11 25H2Spreadsheet Corrupts Upon Saving
Starting this week, a specific spreadsheet I've been using for years is now corrupting when I save it. First it'll prompt "We found a problem with some content. Do you want us to try to recover as much as we can?", and after clicking on Yes it'll come up with "Excel was able to open the file by repairing or removing the unreadable content. Removed Part: /xl/drawings/drawing1.xml part. (Drawing shape)". I restored the spreadsheet from backup (saved and working fine 5 days ago) and I'm able to open... until I save it. Once it's saved, it'll corrupt it with the prompts mentioned above. For a test, I even opened a 2024 and a 2020 template version of this spreadsheet and I get the same issue now. I suspect an update was pushed and now somehow is corrupting some of this spreadsheet's objects. Other spreadsheets seem to be ok, only this one is impacted; though I haven't opened all my spreadsheets to test yet. Thoughts?Employee Onboarding in a Day: Creating Role-Specific Training Guides from SharePoint Content
In today’s fast-paced business environment, the expectation to get new employees productive as quickly as possible is higher than ever. Yet, onboarding often remains one of the most fragmented and time-consuming processes within organizations. Information is scattered, training materials are outdated, and new hires are left navigating a maze of documents with little guidance. https://dellenny.com/employee-onboarding-in-a-day-creating-role-specific-training-guides-from-sharepoint-content/
MC1269241 - Can't turn off antropic for agentmode
Hi, I’m trying to figure out how to turn off the new feature where Anthropic is enabled by default for everyone in the EU for agent mode in excel and powerpoint, as described in the Message Center news in the title. It is not possible to press Save when you have unchecked the setting unless you also consent to the terms of use, it is greyed out. Since we want the feature turned off, we do not want to agree to any terms of use. Has anyone found a solution? This seems to be misconfigured.
Functionality to mark a slide complete
I do not believe this functionality alread exists but I'm quite sure I'm not the only one that would love to have it added. Now when working in a larger powerpoint slide deck I start with adding a "traffic light" to my slides that's red, and when the slide is finished I turn it green. Then, before presenting I have to delete all traffic lights before the deck is truly ready. This way I can keep track of which slides still need attention and prevent myself from spending time on slides I shouldn't. Now I believe it would be very nice if it was a built in feature where you can mark individual slides as "complete / final" or "needs attention" with visual feedback of this status in for example the navigation pane. How do others handle this and is there a trick I do not know of?MICROSOFT O365 LICENSES TO ACCESS IN IRAN
Howdy Folks, Coming back to this tech community to get to know one important thing and it's really urgent to get to know this query coming up from Customer!! Could anyone let me know if the O365 licenses can be accessed by Iran Users who are living in IRAN. If no then please let me know can we provide the licenses from other country tenant like US,UK India etc to IRAN users?? Is it possible for them to access O365 Licenses? As per screenshot attached it says O365 can't be used in these countries...CUBA, IRAN and some others! Please help me out to get the exact answer!!
"Clear Filter From" Option is Never Available
Once a column is filtered, the option to remove that filter just from that column is always greyed out in my Excel (Microsoft 365, v2604, Build 19929.20090). I have seen multiple references advising to remove protection, check for hidden columns, or ungroup workbooks. None of these apply, since I have also tested this with a new worksheet containing a single column, with nothing possibly hidden, and with no shared access. Here is a screen shot of what I see: Thanks to anyone who may have some advice on how to re-enable this feature.
Xlookup with nested IF
Thank you in advance for your help. What I am trying to do is return a value (using Xlookup) but only if another value matches. Maybe I need to use Index/Match, but here's my example: Col A Col B Col C Col D Yes John Smith 1.50 No John Smith 1.25 So, I'm trying to enter an Xlookup that will search for "Smith" in column C and return Col D, but only if Col A is also "Yes". I tried =XLOOKUP("Smith",$C:$C,IF($A3="yes",$D:$D,"-"),"-") but I get a "#Value" error. For real life application, I would be replacing "Smith" with a cell reference and "yes" with another cell reference. But for the example, if A=yes, then return D if Col C=Smith. I just need to figure out in which order xlookup (or index/match) would look for those. Any help is appreciated.ODBC error (incorrect syntax) since 2604
Overnight i have the problem that many inserts in my MS Access app do not work anymore. I get the error Run-time error '3155': ODBC--insert on a linked table 'tablename' failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '='.(#102) I have been able to isolate this issue on a column of type NVARCHAR(MAX). If I insert any value except null in this column the error above will show on save. I tested with other variants of NVARCHAR. The problem happens starting from NVARCHAR(256), thus what is Long Text for Ms Access. When i insert the record first with a value null for this column, no error is generated and the record is saved. If i 'Update' the record later with a text value in this column, that is no problem. So, the ODBC connection generates a sql insert statement that is mallformed in case of a long text. I have this problem consistent on all apps and all tables where i have NVARCHAR(>255). My solution is to go back to office release 2508 (semi annual support).
Cross Referencing Data in Excel
Hello, I have a spreadsheet that lists document numbers that are stored in a document management system. I have to cross reference the documents in that management system, which means I have to go into each individual document in the management system and add in all the documents where that individual document is referenced. The attached spreadsheet lists all the documents in our system (column B) and each document where they are referenced (columns C-AP). Is there a way to have Excel search columns C-AP, find a specific value, and provide me with a list from column B where that value is found in columns C-AP?What is this Madness? Weird Average and Sum results
What is this devil math? What am I missing? The darker green value and blue value should match. I checked for truncated decimal values, even rebuilt the sample to ensure nothing was weird about the original cells. This is not an insignificant difference for what I'm doing, and I don't understand why these aren't lining up. I'm sorry if I'm missing something simple, but please, help!
Events
Agent 365--generally available May 1, 2026--is a control plane that empowers IT admins, Security Operations analysts, Identity and Network Security admins, and Data Security & Compliance admins to ob...
Online
Recent Blogs
- Bug Name Issue Fixed Values display in the wrong control when using a form as a sublist When a form was used as a sublist (subdatasheet), field values could display in the wron...Apr 24, 2026
- Interpreter now supports consecutive interpretation mode, designed for back-and-forth speech-to-speech conversations.Apr 24, 2026
