Recent Discussions
Combinar correspondencia ahora que han desaparecido los DDE con resultados con solo dos decimales
Buenos días: antes combinaba correspondencia de un word con un excell, para hacer mis facturas mensuales con DDE, pero ahora esa opción ha desaparecido y cuando combino me salen muchísimos decimales. He aplicado el formato directamente en Word modificando el campo de fusión con un cambio de formato numérico (por ejemplo, \# "#,##0.00" para forzar dos decimales), pero sigue sin hacérmelo... alguna idea para poder fijar solamente dos decimales en el excell para que los resultados de la combinación en word den solo 2 decimales?
Pasting formatted tables from Excel into other software - issues
I am copying and pasting a large table, with lots of cells merged into, headers for combined rows and colums, with lots of coloured and formatted cells. When it is pasted into Word or Excel, the first 20-30 rows are OK, but then after a while, mid-row, the colour formatting (but not the cell text contents) becomes displaced a two cells to the right. The colouring then corrects itself further down the table, but then drifts in and out of alignment. I think it may be an issue with the merged cells, particularly in the case where if they weren't merged then the content of the cell is wider than the cell, so requires wrapping - but this does not appear to be consistently the issue. I have tried unmerging everything and allowing columns to autofit to full width, but that does not resolve... it had been fine until around March 2026 - was there an update around then? Any suggestions welcome.
Closing VBA module is crashing excel
If I open a macro enabled workbook, go to developer>visual basic and try closing any VBA module windows, excel closes. If I then start excel, open a blank workbook, go to developer> visual basics and insert several blank modules, and then close one, excel closes. If I reboot my PC, open a blank workbook, go to visual basic and insert modules, now I can close them ok. But once I open an existing macro enabled workbook the problem starts over again. Weirdly, if I start from scratch, open a new workbook, then developer and insert just one module and then delete it, that's ok. I can do that repeatedly. Opening and closing form windows in the developer doesn't show the same problem. It isn't just one particular macro enabled workbook that is triggering the problem. Sometimes the workbook opens without macros enabled and I close it without enabling macros and the problem has been triggered. I have switched off all addins. I did recently activate the Inquire COM addin. My excel version is MS Excel for.365 MSO (Version 2604 Build 16.0.19929.20096) 64-bit running on Windows 11. I don't know when I first saw this but I think within the last month. It's a company laptop with phone IT admin support so I'm limited on the trouble shooting I can do myself. Office 365 has been uninstalled and reinstalled but did not help. Other users in my organisation are not seeing the same issue when they open the same workbooks. The IT admin however told me they did see the issue. Updated. Starting from a clean state after reboot, I open a new workbook, add several blank VBA modules then save as xlsm and close. Then when I open a new workbook the problem is triggered again. No VBA code has been run or written. Updated If I maximise the VBA module windows before closing them then I can close them without crashing!
MATCH formula anomaly?
Can anyone explain this? If I simply type 490.44 and then calculate 490.44 as 490.44/40*40 (or even directly B3/40*40) excel recognizes both as equal through a simple A=B calculation yet not with a MATCH calculation. What is more odd is any other number I use does not cause this error...Gray screen on opening existing docs
I was editing an existing WORD for MAC doc & pasted 2 words from an online article. The 2 words I copied & pasted ("hempen home-spuns") were in a Shakespearean quote included in the article, "7 Shakespearean Insults to Make Life More Interesting" (https://www.merriam-webster.com/wordplay/shakespeare-insults). I pasted the text initially using the match existing formatting option, which worked fine, seemingly. I then deleted one of the words in the quote, and reconsidered whether I wanted to use both words. But instead of clicking undue, I chose to repast the text to look at the phrase again & decide if I wanted to use both words. However, this time I just clicked paste because I just wanted to think it over & not necessarily use the pasted text . . . and that's when all the trouble started! My doc then seemingly locked & wouldn't allow me to do any more editing. I closed it & reopened it & was greeted by a grey screen, without any text, and 3 items in the menu bar -- the "Normal", "No Spacing" & "Heading 1" items -- keep flashing. I tried several times opening other docs by either double clicking or displaying them from a menu listing & clicking open, and in every case, I go a gray screen. When I go to File > Properties, it shows the words & characters are still there. So, whatever happened when I pasted the text w/o saying match formatting caused a problem in my Word for MAC. Doesn't MS have an app to FIX Word for MAC or at least diagnose what the hell is wrong, along with the steps required to fix the problem? I'd really appreciate some HELP, ASAP. Thank you. -- Wayne
Excel Find / Command-F crashing on Mac Tahoe (Office 2019 / Excel 16.78) – anyone else?
Excel Find / Command-F crashing on Mac Tahoe (Office 2019 / Excel 16.78) – anyone else? Mac mini + Tahoe 26.5. Excel 16.78 (Office Home & Student 2019). Problem started after recent Tahoe update. Classic Find is behaving badly and often crashes Excel. Workflow: click/select a column Edit → Find → Find… or Command-F search for text or email fragments (ex: "kristin" or part of an email) Excel may crash or Find becomes unusable Things already tried: full Excel reinstall blank workbook test new macOS test user Office container reset / plist tests preference resets same Tahoe version confirmed Upper-right Microsoft Search appears, but that is not equivalent to classic worksheet Find for email-column workflow. Question: Is this a known Tahoe / Excel 16.78 Find bug or Search-routing issue? Has anyone fixed this or seen it resolved with a newer Excel build or update?
Excell function problem
I have been using Excel for a good few years, i have a spreadsheet that has been working fine until now. My main problem is that when i copy & paste data everything works fine, i have been able to add cells to make a new total. but when i cut & paste the value of cells i get a REF error. so when i need to move a series of cells higher or lower any cells that contain word they move fine, the cells containing numbers move but the cell with the function just goes to #REF, the function was working okay with my previous versions of Excel but now it will not. if anyone has got any idea what the problem is or any way of fixing it i would be most gratefullMicrosoft Wants PowerShell Developers to Change How They Download Microsoft Modules
A Microsoft blog describes some changes for PowerShell developers in terms of installing modules and the role of the Microsoft Artifact Registry (MAR). In a nutshell, Microsoft intends the MAR to be the go-to place to download first-party PowerShell modules and other artifacts. This solves the problem of potentially compromised modules found in the PowerShell Gallery, but MAR can’t work if it doesn’t contain the modules people use. https://office365itpros.com/2026/06/05/microsoft-artifact-registry/sort by column then by numbers in a row
HI all I have a table of results pictured here. Once the results are in, I sort the table by the Total Score Column. When we have a tie (as in line 3 & 4, I need to sort by who has the most highest score... so, who has the most 9 (equal here), then by most 8.5 (line 4 wins the tiebreaker, 4 over 2) Can I do this so it doesn't affect the order of the columns but just the rows involved.
Add-in Error: We could't connect to the '{0}' catalog server for this add in
For the past month every time I try to use an Add-In in word I get the following error "we couldn't connect to the '{0}' catalog server for this add in." I have tried from multiple computers, Safari, Chrome, different accounts, etc. and nothing is working. It is a personal account and I use word online. It happens for multiple add-ins and I have reached out to the companies directly and they said it was a Microsoft issue.need exchange se for hybrid environment
We have a hybrid Office 365 environment with an Exchange Server 2016 that no longer performs any role. It does not host any mailboxes and is not used as an SMTP relay. We would like to keep an Exchange installation solely for administrative purposes through the GUI. Questions: 1. Can we keep Exchange Server 2016 installed? 2. If we need to install Exchange Server Subscription Edition (SE), do we need licenses for this installation, considering that all our Office 365 licenses are Business licenses? Thank you.
Regarding the filter by condition option in pivot table in the excel
I'm taking Google Data analytics course in the coursera, there they use filter in the pivot table and apply conditions like, less than or greater than, they were using the Google sheets, and I couldn't find that option in the excel, you can select or unselect the value in the filter but there's no option to apply conditions like lesser than or greater than such value. Is there any way you guys know, from which you filter the fields by conditions, please let me know.Excel table not using updated formula in new rows
I have an Excel spreadsheet that keeps giving me the same issue with the formulas in column O. Originally, column O contained the following formula: Original formula: =IF(R4<>"", R4, Q4) + IF(ABS(I5-I4) < 30, 25/1440, IF(ABS(I5-I4) <= 50, 40/1440, IF(ABS(I5-I4) <= 150, 60/1440, IF(ABS(I5-I4) <= 250, 80/1440, IF(ABS(I5-I4) <= 300, 100/1440))))) The formula has since been updated to: Current formula: =IF(R4<>"", R4, Q4) + IF(ABS(I5-I4) < 30, 25/1440, IF(ABS(I5-I4) <= 50, 40/1440, IF(ABS(I5-I4) <= 150, 60/1440, IF(ABS(I5-I4) <= 250, 80/1440, IF(ABS(I5-I4) <= 300, 100/1440))))) + C5/24 However, whenever I insert a new row, Excel automatically fills it with the original formula instead of the updated one, even though I have been using the updated formula for quite some time now. How can I make Excel recognize and use the updated formula when new rows are inserted?Microsoft 365 Outlook Classic Latest Update Copilot issues
Hello to all, we are currently using the Microsoft 365 Outlook Classic, using version Version 2604 Build 16.0.19929.20172 (Current Channel) Copilot works as expected; However ever since the next update was released (Version 2605 (Build 20026.20076)) some users including me, have been getting the below error: I have tried uninstalling and installing the latest version directly, with the same issue. Scanned for any corrupted system files with no issues,but still get the error; I have tried the update Licence from the Outlook application, with no issues but the copilot something went wrong error keeps on persisting. Internet searches are very vague and the I have found some registry suggestions which I have also tried with no solution. The only way to get Copilot working on Outlook Classic was to revert to a previous working version, only then Copilot works as expected. This only happens in Outlook Classic; Copilot works fine on the latest version of Microsoft Office 365 with Word, Excel, etc. For those that maybe might ask why not switch to the New Outlook, we have had issues with it and it has been recommended to use the Classic Outlook for the time being. Has anyone been experiencing such issues please? Thanks for any help.
Regression in v2605: Subform with overlapping controls breaks timer in unrelated form
I found another issue (sorry) which might be caused by the zoom-related changes in 2605. The following repro example works fine in 2604 (Monthly Enterprise Channel) but breaks in 2605 (Current Channel). Again, this issue is unrelated to zooming itself. Prepare database The repro requires three forms and a few controls. Since those are tedious to get right manually, I wrote some VBA code to do that for us. Execute BuildRepro() in the Immediate Window to create the forms and controls. Option Compare Database Option Explicit Public Sub BuildRepro() CreateFormASubform CreateFormA CreateFormB End Sub Private Sub CreateFormASubform() Dim frm As Form Dim ctl As Control Set frm = CreateForm() Set ctl = CreateControl(frm.Name, acTextBox, acDetail, , , 345, 1140, 1746, 260) ctl.TabStop = False Const textBoxTop = 260 Set ctl = CreateControl(frm.Name, acTextBox, acDetail, , , 56, textBoxTop, 270, 270) ctl.TabStop = False Set ctl = CreateControl(frm.Name, acImage, acDetail, , , 56, 0, 270, 270) Set ctl = CreateControl(frm.Name, acCommandButton, acDetail, , , 60, 795, 5895, 260) SaveAndClose frm, "FormA_Subform" End Sub Private Sub CreateFormA() Dim frm As Form Dim ctl As Control Set frm = CreateForm() Set ctl = CreateControl(frm.Name, acSubform, acDetail, , , 100, 100, 3000, 3000) ctl.SourceObject = "FormA_Subform" SaveAndClose frm, "FormA" End Sub Private Sub CreateFormB() Dim frm As Form Dim ctl As Control Set frm = CreateForm() frm.TimerInterval = 1 Set ctl = CreateControl(frm.Name, acLabel, acDetail, , , 100, 100, 5000, 1000) ctl.Name = "my_label" ctl.Caption = "Waiting for Timer..." frm.HasModule = True frm.Module.InsertText _ "Private Sub Form_Timer()" & vbCrLf & _ " Me.TimerInterval = 0" & vbCrLf & _ " Me.my_label.Caption = ""Done""" & vbCrLf & _ "End Sub" frm.OnTimer = "[Event Procedure]" SaveAndClose frm, "FormB" End Sub Private Sub SaveAndClose(ByVal frm As Form, ByVal newname As String) Dim oldname As String oldname = frm.Name DoCmd.Save acForm, oldname DoCmd.Close acForm, oldname DoCmd.Rename newname, acForm, oldname End Sub Run repro 1. Open FormA. 2. Open FormB (while FormA is still open). Expected result: FormB opens completely, the timer runs and the label reads "Done". Actual result: FormB opens "halfway" (it's visible, but it's tab is still missing, see screenshot below) and the label still shows "Waiting for Timer...". As soon as you right-click anywhere, the form finishes opening and the timer runs, changing the label to "Done". Notes: I tried to make the repro as simple as possible. If you remove one of the controls from FormA_Subform (or enable TabStops), the problem disappears. It might have something to do with overlapping controls: If you change textBoxTop from 260 to 280, so that it no longer overlaps with the image, the problem also disappears. We need the overlapping controls because in our real code the subform is continuous and displays data at different indentation levels (like a treeview).
Recent Blogs
- Pin, Snooze, Sweep, and more features can help you organize your inbox and work more efficiently.Jun 05, 2026
- Bug Name Issue Fixed Edge Browser Control didn't render PDFs on some machines When the Edge Browser Control was used to display a PDF, on some machines the PDF would not render...Jun 03, 2026
