Recent Discussions
Series fill a formula down a column automatically skipping a set number of rows
I am trying to fill a formula down a column every 6th row but incrementing the variable in the formula ($A2) for each entry. The formula uses the Take command and inputs 5 rows of data, so to keep it from "spilling" I need the formula to increment every 6 rows, having one blank row between each section. I have been able to accomplish "copying" it each 6th row with VBA #1 and filling the series with VBA #2 but can't figure out how to combine the two. Any help would be appreciated. VBA #1: Sub FillEvery6thCell() Dim ws As Worksheet Dim startRow As Long, lastRow As Long, col As String Dim formulaText As String Dim r As Long ' Set your sheet and parameters Set ws = ThisWorkbook.Sheets("Top 5 Employees") col = "A" ' Column to fill startRow = 10 ' First row to start filling lastRow = 60000 ' Last row to fill ' Get the formula from the starting cell formulaText = ws.Range(col & startRow).Formula ' Fill every 6th cell For r = startRow + 6 To lastRow Step 6 ws.Range(col & r).Formula = formulaText Next r Range("A2:A60000" & iRow).Replace What:="@", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2 MsgBox "Formula copied to every 6th cell in column " & col End Sub VBA #2 Sub FillFormulasDown() Dim sourceCell As Range Dim fillRange As Range ' Define the cell containing the formula Set sourceCell = Range("A2") ' Define the target range Set fillRange = Range("A2:A5000") ' Fill formulas down sourceCell.AutoFill Destination:=fillRange, Type:=xlFillSeries End Subsort 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).The Great Loop Departed User Process
When employees leave a Microsoft 365 tenant, they might leave a user-owned Loop workspace behind which contains some valuable information that the organization wants to retain. Two years or so after announcing that a workflow to handle user-owned workspaces was coming, Microsoft is rolling out the update to tenants worldwide. The process is manual, but not much automation is possible to review and preserve workspace content. https://office365itpros.com/2026/06/04/user-owned-loop-workspaces/
Excel 365: Unexpected Predictive Behaviour Causing Retroactive Cell Changes in Structured Dataset
Hi everyone, I’m posting this to share an unusual and potentially important issue I encountered in Excel 365 this morning. I’ve already submitted a detailed report to Microsoft via the Feedback Hub, but I felt it would be useful to document it here for visibility and to see whether anyone else has experienced something similar. While entering data into a structured table (a parts‑catalogue workbook), Excel began exhibiting behaviour that did not match Flash Fill, AutoFill, or the standard predictive typing feature. Specifically: Grey predictive text appeared beyond the cursor and extended into cells below the active cell Excel began rewriting previously validated cells in the same column Each time I pressed Enter, Excel updated earlier rows based on its latest inferred pattern Attempts to correct earlier rows caused further cascading changes Undo did not revert all changes The behaviour resembled an AI‑style inference engine trying to “learn” my pattern, becoming progressively more confused This was not the normal predictive typing behaviour (which only shows grey text inside the active cell and does not affect other cells). The behaviour stopped only after I clicked the Flash Fill button twice, which suggests an internal state reset. I’m not seeing the issue now, and other workbooks behaved normally, so this appears to have been a transient internal mode rather than a persistent setting. I’m sharing this here because: it caused silent data corruption in a structured dataset it may indicate an experimental feature or feature‑flag activation others working with structured data may want to be aware I’d be interested to know if anyone else has seen similar behaviour If helpful, I can provide the reproduction steps, screenshots, and the engineering‑style report I submitted to Microsoft. Thanks, John
Outlook Cached Mode Repeatedly Re-syncs Mailbox After Restart (Starts Again Around 3.99 GB)
Hi everyone, I’m experiencing a strange Outlook Cached Exchange Mode issue with a Microsoft 365 mailbox after a recent Windows rebuild and wanted to see if anyone has seen similar behavior. Environment: Microsoft 365 mailbox (Exchange Online) Outlook for Microsoft 365 Version 2605 Build 16.0.20026.20076 64-bit Windows 11 25H2 Fresh OS rebuild performed twice New Outlook profile created Office completely reinstalled OST recreated multiple times Issue: When Cached Exchange Mode is enabled, Outlook starts downloading/synchronizing mail normally, and the OST file continues to grow correctly. However, after every reboot or Outlook restart, Outlook again shows “Downloading…” starting from around 3.99 GB. Important observations: Online Mode works perfectly OUTLOOK.EXE closes properly after exit OST file is NOT deleted and continues growing Sync slider changes (1 month, 1 year, all mail) make no difference Disabling Outlook indexing did not help New Outlook profile did not help Reinstalling Office did not help Problem only started after OS rebuild Before rebuild, same mailbox worked normally in Cached Mode No pending office or windows update. It does not appear to actually re-download the mailbox from scratch because the OST size keeps increasing, but Outlook repeatedly processes/downloads from around the same 3.99 GB point after restart. Has anyone seen: Cached Mode replaying synchronization repeatedly after restart? Similar behavior on recent Current Channel builds? Security/EDR products interfering with OST synchronization state? Any known regressions with Outlook Version 2605 Build 16.0.20026.20076? Any suggestions or similar experiences would be appreciated.Forcing Gridlines to print through shaded cell formatting
I know how to force gridlines to print but if any cells are formatted with a fill shading in them, the gridlines will not print through them. Is there a way to print gridlines in formatted cells which are filled? No gridlines will print through the shaded cells.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?Text get cut off on page switch if table spans across pages
I have some code that creates a docx document that includes tables. At first i used some other code that could create doc files, through html, but to update it i now use docx instead, which is build differently. But the problem Im facing after the switch is that text gets cut off through the middle when the table spans across a page. See screenshot below. The only thing I've found to work, is if i change the table theme when the document is opened in word, but I cant find a way to do this via xml. It is also worth noting that the document is generated via code, that creates a html file holding the main content, and loaded via the <altChunk> tag in the xml If i upload the document to word online there is however no issue I've tried lots of things in the xml which is used in the docx generation, like padding, spacing, line-height etc. but haven't found anything yet that works, and at this point im out of ideas, hence why i reach out to the community.
Employee performance management tools in Microsoft 365?
So we are a relatively large organization and in drastic move, we've decided to shift from Google Workspace to Microsoft, primarily centering our employees around Microsoft Teams while trying to encourage them to use Copilot as effectively as possible. In this transition, one of the platforms we will be saying goodbye to will be our performance management software. Are there any Microsoft native performance management tools that can help us go through goal-setting, performance reviews, and feedback? Third party suggestions would also be good but only if they fit into the whole Microsoft workflow well.Recurring issue I'm experiencing with charts that are moved to a dedicated chart sheet.
This is also happening to my students in my Excel for Agriculture courses: they send me their assignments, and while the charts look perfectly fine in older versions of Excel, in my Excel 365 I cannot see them properly. As a test, I even opened files that were working perfectly just a week ago, and now my own charts appear exactly like the image I attached. Needless to say, these are not corrupted files, the data source is fully verified, and everything else is in order. The only workaround I found was to insert a new regular worksheet, move the charts to that sheet (where they display correctly), and then move them again to a new chart sheet. After doing that, they look fine again, just as before. Before anyone asks the obvious questions: I have written four Excel books and have been teaching Excel for Agriculture for 20 years, and this is the first time I’ve ever seen something like this. I urgently need a solution. At this point, it makes no sense to keep paying for a Microsoft 365 subscription if this continues to happen. Please, if possible, translate any replies into Spanish. Thank you!Is Office 365 E3 Developer free
Hi, My tenant had a license named "Office 365 E3 Developer" which allowed us to use Outlook / Exchange (among other Microsoft Office products). This license isn't from the Microsoft 365 Developer Program, which come with free licenses. This license costed CA$11.60 a month per user when we initially purchased it. On May 2, 2026 it still costs $11.60, but when I received my monthly invoice for this tenant, this license was free. I searched around to see whether this license became free recently, but I couldn't find any info on this. The links I found all say it's a paid license. I was wondering if there's any info on this to see why it became free? Or is it a mistake and Microsoft'll be charging us the next billing cycle? Jason
Recent Blogs
- 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
- One of the biggest barriers to enterprise adoption is the lack of centralized controls. Before deploying an agent broadly, organizations need clear answers: What is this agent allowed to do? What dat...Jun 02, 2026
