Recent Discussions
Word Similarity Checker fails in desktop and web: “Something went wrong”
Hello, I am having an issue with Microsoft Word Similarity Checker. The Similarity Checker consistently fails with the message: “Something went wrong. Try again.” This happens in both: - Microsoft Word desktop - Word for the web / Microsoft 365 web version Product/account details: - Microsoft 365 subscription is active - Word shows activated under File > Account - Connected experiences are enabled - Word desktop version: Microsoft 365 Apps, Version 2606, Build 20131.20112 Click-to-Run Current Channel Troubleshooting already completed: 1. Confirmed Word is activated under File > Account. 2. Confirmed connected experiences are enabled: - Experiences that analyze your content: ON - Experiences that download online content: ON - All connected experiences: ON 3. Ran Office Update Now. 4. Restarted Windows. 5. Ran Quick Repair. 6. Ran Online Repair. 7. Tested in a brand-new blank Word document. 8. Tested on mobile hotspot instead of normal network. 9. Confirmed ProtonVPN was turned off. 10. Cleared Office Wef cache contents at: %LOCALAPPDATA%\Microsoft\Office\16.0\Wef\ 11. Checked Microsoft Edge WebView2 Runtime. The installer says it is already installed for the system. 12. Signed out of Word/Microsoft 365, restarted Windows, and signed back in. 13. Tested again in Word desktop. 14. Tested again in Word for the web. 15. The same “Something went wrong. Try again” Similarity Checker error still occurs. I also previously saw a script error when clicking Update License in Word: URL shown included: https://oc.officeapps.live.com/odc/v2.1/hrd Error: 'Hrd' is undefined Because the issue occurs in both desktop Word and Word for the web after these troubleshooting steps, this seems like a Microsoft 365/Word Similarity Checker service-side or account-side issue rather than a local installation problem. Can someone from Microsoft confirm whether there is a known issue with Similarity Checker right now, or whether this needs to be escalated as an account/service-side problem?10Views0likes1Commentgenerate list
Good day! I have a file that has list of all names on one sheet. is there a way to generate on a different sheet list of names based on the first letter of the names? like in sheet1 would be all the names, sheet2 would be names starting in A-D, sheet3 names starting in E-J... TIA!27Views0likes3Comments- 23Views0likes1Comment
Add-in Excel Labs
Da tempo sto utilizzando l'add-in Excel Labs, soprattutto nelle sua funzionalità base di "Advanced formula environment" particolarmente utile nella compilazione di formule LAMBDA che stanno avendo un così grande sviluppo in questi ultimi tempi. La facilità nella redazione e nel debug inline delle formule, i commenti e la gestione delle stesse in "Gestione Nomi" ne ha fatto per me e penso per molti uno strumento eccellente che ovviamente non può essere paragonato all'edito base di Excel. Rivolgo perciò un invito a considerare possibile la sua implementazione direttamente in Excel come strumento alternativo all'editor di base . Ritengo che tutti potranno giovarne.26Views0likes1CommentPlanning to Migrate OST Files to Microsoft 365 - Need Some Guidance Before I Start
Hey folks, I have a task coming up where I need to migrate OST files into Office 365 mailboxes. A few of the OST files I'm dealing with are orphaned or corrupted which is making me a bit nervous about the whole process. A couple of things I'm unsure about: How to handle OST files that are no longer linked to an active profile Whether corrupted OST files can still be migrated to Office 365 without major data loss Best way to verify data integrity after migration Haven't started yet and want to make sure I'm going in the right direction before I begin. Has anyone migrated corrupted or orphaned OST files to Office 365? What approach worked best for you?37Views1like2CommentsUser agent : ODMTADemand-Transform_Zip
Hello guys, I’m investigating a SharePoint/OneDrive alert and noticed the following user agent: """ODMTADemand-Transform_Zip""" I found information about OneDriveMpc-Transform_Zip/1.0 being related to ZIP downloads from SharePoint/OneDrive, but I can’t find anything specific about ODMTADemand-Transform_Zip. Does anyone know what this user agent is used for? Is it a legitimate Microsoft backend process, and is it related to ZIP generation/download operations in SharePoint or OneDrive?30Views0likes1Commenthow to ignore conditional formatting for a cell that is not empty but invisible (cell format ;;;)
hi, i need help with a conditional formatting of cells that are not empty but invisible (cell format to ;;; (invisible)). I have a calendar where the dates are invisible (outside of the month) but the cell formatting applies to it (cuz it is that date, i.e., public holiday). i have attached the screenshots and i hope someone can help me out. thank you so much. regards, angel51Views0likes2CommentsGoogle Workspace sender stuck at SCL=5 to all Microsoft-hosted recipients
Sending email from a new domain via Google Workspace. All mail to Microsoft-hosted recipients (both Outlook.com consumer accounts and Microsoft 365 Exchange Online tenants) is being routed to junk. Authentication passes perfectly on every message. This appears to be a domain reputation cold-start issue and I am looking for guidance on how to resolve it without waiting 2-4 weeks. Affected recipients are all Microsoft-hosted recipients tested (Outlook.com consumer + Microsoft 365 Exchange Online tenants). Please help me!!! Confirmed via X-MS-Exchange-Organization-SCL: 5 and delivery header dest:J;OFR:SpamFilterAuthJ;RF:JunkEmail on all test emails including ones with normal subject lines and body text. Content makes zero difference to the score. What has already been done: SPF hardened from ~all to -all DMARC upgraded from p=none to p=quarantine IP confirmed not listed on Microsoft's delist portal (sender.office.com) Domain confirmed not listed on Spamhaus DBL or SURBL Domain registered with Google Postmaster Tools JMRP enrollment attempted — not available to Google Workspace senders as SNDS requires IP ownership Outlook.com Postmaster support request submitted9Views0likes1CommentCan anyone help me with this SWITCH function
Hello Everyone, This SWITCH function is used to produce a number that then I can use to sort workers and their functions. =SWITCH(TRUE, IF(AND(ISNUMBER(J2)=TRUE,M2="Working")=TRUE,5,0), IF(AND(ISNUMBER(K2)=TRUE,M2="Working")=TRUE,500,0), IF(AND(ISNUMBER(J2)=TRUE,M2="Special Project")=TRUE,15,0), IF(AND(ISNUMBER(K2)=TRUE,M2="Special Project")=TRUE,515,0), IF(AND(ISNUMBER(J2)=TRUE,M2="Stand By")=TRUE,20,0), IF(AND(ISNUMBER(K2)=TRUE,M2="Stand By")=TRUE,520,0), IF(AND(ISNUMBER(J2)=TRUE,M2="Special Project UFN")=TRUE,25,0), IF(AND(ISNUMBER(K2)=TRUE,M2="Special Project UFN")=TRUE,525,0), 50 ) In Column J I have their Start Time, from the Kronos System, and in Column K I have their End Time. In Column M I have Tasks names that would indicate what each Team member is doing. Each component does evaluate correctly but the function always return 50? What am I missing here? Thanks in Advance! GiGi80Views0likes3CommentsWord Help
My word application kept defaulting to an old version that is no longer active. With the help of one of your technician's, I was able to erase that and sign in to my microsoft word account. However, I cannot restore my dissertation document with all the formatting, charts, maps, etc. Thankfully I saved it on my OneDrive through my university, but when I try to download it back onto my computer, it scrubs all the formatting, charts, maps. I've tried to pull it off my icloud but it only has the scrubbed version. The technician suggested I post here to see if anyone can help me.12Views0likes1CommentHEIC codec is not working with Windows 11
My client has 350+ users, no one has this kind of issues with their windows machines. This laptop has Windows 11 v 25H2. In his team, coworkers shared some pictures over the shared drive and teams app also (remember I already checked its NOT application or file corruption issue) because same file opens everywhere except by this laptop. While opening the .HEIC file in windows the "Photos" app said there is no codec installed and give the link to download from MS store. After, moving on MS store, the codec asks us to purchase it. We proceed to buying the codec it says use only personal Microsoft ID. In my research I found that MS restricted to buy anything using any business account. The problem is not buying this codec in actual, the purpose to ask and provide further solutions. Why this particular laptop or windows 11 missing this codec? (low priority question) What is the other easiest way to fix the problem? like copy some file from healthy system and paste in somewhere. or whatever else. The client is not agree to reformat the OS and Download any Third party app from MS store, as they said to find the way in fixing this problem.37Views0likes1CommentIs XML in Power Query is broken on macOS
Hello, XML from Power Query seems to have broken after update (July 2nd 2026). I tried this on several Macs To recreate just create a new file. Power Query -> XML -> Choose any xml file For me it doesn’t work. It keeps loading endlessly Am I the only one? Is there a workaround? Thank you69Views0likes4CommentsMissing MS Form
Hi everyone, I created a MS Form and now have gone back to check the results of said form and it is nowhere to be seen. Not in my personal account (where i am 99.9% sure I created it) and nor in my work account. Tried MS Support and after much tooing and throwing they have said to post here and promptly closed the Live Chat I was having with them - helpful not! Anyway help...16Views0likes2CommentsUnable to access our Microsoft Entra admin center
We cannot create a support request from the admin center because we cannot sign in Dear Microsoft Support Team, We are unable to access our Microsoft Entra admin center because even our administrator account, email address removed for privacy reasons, is being prompted for MFA, and we do not currently have access to the Microsoft Authenticator method required to complete the sign-in. As a result, we cannot access Entra ID / Microsoft 365 admin settings to reset MFA methods, issue a Temporary Access Pass, or re-register authentication methods for the affected users. Tenant/domain: itieurope.com Affected admin account: email address removed for privacy reasons Issue: MFA is required to sign in, but the Authenticator method is unavailable Impact: We are locked out of the tenant administration portal and cannot manage users or authentication methods We request assistance with one of the following recovery actions: Reset MFA methods for the administrator account email address removed for privacy reasons; or Enable re-registration of MFA for this account; or Provide a Temporary Access Pass or another Microsoft-approved recovery method so that we can regain administrative access to the tenant. We had force majeure, the only authenticator was on the phone, which was destroyed due to an unforeseen situation. (crashed) We are ready to verify domain ownership, provide billing information, tenant details, proof of identity, or any other information required to confirm that we are the legitimate owners/administrators of this Microsoft 365 tenant. Please escalate this as an urgent tenant lockout / admin access recovery issue. Kind regards, itieurope.com email address removed for privacy reasons>">" Logic Question
I love looking at the Excel BI Challenges on Linked in. I was going back over challenge 7 and saw a new answer with some new logic that I don't quite understand. Here is the challange Provide a formula to count the number of English alphabets and numeric digits in every cell. Expected answers given against all cells String Expected Answers V%ij5yVer_m@y 10 &Qw00Ty] 6 0 M%a^r#sh!ALL 8 1234 4 EXCEL 5 $9%6#-2+ 3 https://www.linkedin.com/posts/excelbi_excel-advancedexcel-excelchallenge-share-6969180817432424448-EKbX/?utm_source=share&utm_medium=member_desktop One new since the REGEX functions came out was the true "best" answer.... =LEN(REGEXREPLACE(A6:A12,"[\W_]","")) But another user this formula: =REDUCE(0,SEQUENCE(MAX(LEN(A6:A12))),LAMBDA(a,n,a+(MID(A6:A12,n,1)>">"))) I understand it for the most part; but can't quite figure why they used the greater than sign to their true answers. Why the ">"? I started looking at character codes to see if that was it: 8 TRUE =N87>">" 9 TRUE =N88>">" : FALSE =N89>">" ; FALSE =N90>">" < FALSE =N91>">" = FALSE =N92>">" > FALSE =N93>">" ? FALSE =N94>">" @ FALSE =N95>">" A TRUE =N96>">" B TRUE =N97>">" C TRUE =N98>">" But that must not be it as numbers come before ">". I thought maybe it was a number within a text that made it true; but then i looked at other characters that come further down the character code index (see below). There are some trues mixed in there. I tried adding those characters into the question and it didn't change anything. y TRUE =N152>">" z TRUE =N153>">" { FALSE =N154>">" | FALSE =N155>">" } FALSE =N156>">" ~ FALSE =N157>">" FALSE =N158>">" € FALSE =N159>">" TRUE =N160>">" ‚ FALSE =N161>">" ƒ TRUE =N162>">" „ FALSE =N163>">" … TRUE =N164>">" † TRUE =N165>">" ‡ TRUE =N166>">" ˆ FALSE =N167>">" ‰ TRUE =N168>">" Š TRUE =N169>">" Thoughts?86Views0likes5CommentsPower Apps + Excel Online: RFC 3339 Date/DateTime Format Error When Patching to Excel Date Columns
Hi everyone, I need help with a Power Apps canvas app connected to an Excel workbook stored in SharePoint/OneDrive. The app is a warehouse inventory system using Excel tables as the data source. The app has these Excel tables: tblSKU tblLocation tblInventory tblTransactions The main issue is with date fields when using Patch() from Power Apps to Excel. Error Message I keep encountering this error: Expected value "" to be valid RFC 3339 'date-time' format. Allowed ISO 8601 format(s): 'YYYY-MM-DDThh:mm:ssZ', 'YYYY-MM-DDThh:mm:ss+hh:mm', 'YYYY-MM-DDThh:mm:ss'. This happens during receiving / issuing / stock count transactions when patching to Excel. Date Columns Involved In tblTransactions, I have: DateTime TransDate ProductionDate ExpiryDate In tblInventory, I have: ProductionDate ExpiryDate LastUpdated These columns are formatted in Excel as Date or Date/Time. Current Patch Logic I already changed my formulas to stop saving formatted text like this: DateTime: Text(Now(), "dd mmm yyyy") TransDate: Text(Today(), "dd mmm yyyy") ProductionDate: Text(dpProductionDate.SelectedDate, "yyyy-mm-dd") ExpiryDate: "" Now I am trying to patch real date values instead: DateTime: Now(), TransDate: Today(), ProductionDate: If( IsBlank(dpProductionDate.SelectedDate), Blank(), dpProductionDate.SelectedDate ), ExpiryDate: If( IsBlank(varExpiryDate), Blank(), varExpiryDate ), LastUpdated: Now() However, I still sometimes get the RFC 3339 error. Sample Receiving Patch Here is the relevant part of my receiving button: Patch( tblTransactions, Defaults(tblTransactions), { TransID: Text(GUID()), DateTime: Now(), TransDate: Today(), Type: "RECEIVE", SKU: varSKU.SKU, Barcode: varBarcode, Description: varSKU.Description, Category: varSKU.Category, UOM: varSKU.UOM, LotNo: Upper(txtLot.Text), ProductionDate: If( IsBlank(dpProductionDate.SelectedDate), Blank(), dpProductionDate.SelectedDate ), ExpiryDate: If( IsBlank(varExpiryDate), Blank(), varExpiryDate ), Location: drpLocation.Selected.LocationCode, Qty: Text(Value(txtQty.Text)), User: User().FullName, Status: "POSTED", Remarks: "" } ) Expiry Date Calculation The expiry date is calculated based on SKU shelf life: Set( varShelfLifeDays, IfError( Value(varSKU.ShelfLifeDays), 0 ) ); Set( varExpiryDate, If( varShelfLifeDays > 0, DateAdd( dpProductionDate.SelectedDate, varShelfLifeDays, TimeUnit.Days ), Blank() ) ); Related Issue In galleries and labels, Excel sometimes returns date values as serial numbers, for example: 46192 So I had to use formulas like: Text( DateAdd( Date(1899,12,30), Value(Text(ThisItem.ExpiryDate)), TimeUnit.Days ), "dd mmm yy" ) This works for display, but I am still unsure about the correct way to patch date/date-time values back to Excel. Any guidance would be very much appreciated. Thank you.26Views0likes1CommentMS Excel Macro issue - Cannot run macro 'ITC_04_Offline_utility.xlsm!jw2m5BModule.validate5B.
Cannot run macro 'ITC_04_Offline_utility.xlsm!jw2m5BModule.validate5B. . This macro is in the File downloading from GST Site and this happen in my system only ......works ok in other sys17Views0likes1CommentUnwanted pasting of data in new raw or column
There is a strange property of excel - when I have a range copied (a cell or more) and will like to add new columns or rows excel will add the with the copied rang pasted. It is awful, as it take time and sometimes leads to a crash. Is there a way to prevent excel from doing so? By the way I wonder when Microsoft will produce excel that does not crash?55Views0likes2CommentsWord for iPad cannot edit documents marked as “Recommended Reading” in Windows
I have a Word document created in Windows that was saved with the “Recommended Reading” option. When I open it in Word for iPad, the file is locked in reading mode and there is no option to switch to editing mode. Word Online can edit the document without any issues, so it seems that the limitation affects only the Word app for iPad. This appears to be a recent limitation, since the document could be edited without any issues a couple of months ago. Is this a known limitation in Word for iPad? Is there any way to remove this flag from the iPad or force editing mode without having to return to Windows? Thank you.35Views0likes4CommentsOutlook Classic - Crashes When Drafting with Copilot in RDS environment
Hi all, I'm interested to see whether anyone else is experiencing this issue, particularly in an RDS environment. We have a number of users who have paid-for Microsoft 365 Copilot licences, including the integration within Office applications such as Outlook, Word and Excel. In Outlook Classic running on our Windows Server 2019 RDS environment, Copilot no longer works correctly. When a user presses Alt + I to Draft with Copilot, or clicks the Copilot pencil icon within the body of an email, and then enters a prompt, Copilot displays "Writing your email" and the blue progress bar starts moving from left to right. At that point it freezes, Outlook crashes, and closes. In some cases Outlook will automatically reopen after the crash. The Copilot integration appears to work fine in Excel and Word. Is anyone else running Outlook Classic in a Windows Server 2019 RDS environment with Microsoft 365 Copilot licences? I would be interested to know if you have experienced the same issue. I've tried repairing and reinstalling Office apps, and always ensure they are fully up to date. Thanks.257Views1like4Comments
Events
Recent Blogs
- 6 MIN READExplore what's new for Agent 365 in June 2026.Jul 08, 2026491Views0likes0Comments
- Unlock financial intelligence from Xero directly in Copilot.Jul 08, 2026268Views1like1Comment