VBA Code stops
Not sure what is going on... this was working and now all the sudden the code stops part way through. Here is the current code (linked to a button) Private Sub CommandButton2_Click() Dim cofCom As Object Set cofCom = Application.COMAddIns("SapExcelAddIn").Object Dim api As Object Set api = cofCom.GetPlugin("com.sap.epm.FPMXLClient") api.RefreshActiveWorkbook Application.ScreenUpdating = False ActiveWorkbook.Sheets("Spend Detail").Activate Sheet14.CommandButton2_Click Sheet14.CommandButton1_Click ActiveWorkbook.Sheets("Spend Detail 1").Activate Sheet21.CommandButton4_Click Sheet21.CommandButton3_Click ActiveWorkbook.Sheets("Spend Detail 2").Activate Sheet22.CommandButton6_Click Sheet22.CommandButton5_Click ActiveWorkbook.Sheets("Spend Detail 3").Activate Sheet23.CommandButton8_Click Sheet23.CommandButton7_Click ActiveWorkbook.Sheets("Spend Detail 4").Activate Sheet24.CommandButton10_Click Sheet24.CommandButton9_Click ActiveWorkbook.Sheets("Spend Detail 5").Activate Sheet25.CommandButton12_Click Sheet25.CommandButton11_Click ActiveWorkbook.Sheets("Spend Detail 6").Activate Sheet27.CommandButton14_Click Sheet27.CommandButton13_Click ActiveWorkbook.Sheets("Finance Input Sheet").Activate Application.ScreenUpdating = True End Sub The problem is that all tabs update for the refresh but for some reason, going to each sheet and clicking the buttons is not occurring now. It is essentially stopping at line 6 and I have tried removing the screenupdating false and true and that did not make any difference. Just like for some reason the code stops and it was working a week ago. Any suggestions?
Excel repair strips all formulas from large .xlsm after March 2026 security update (KB5002849)
Hi everyone, I'm a master's student at Karolinska Institutet in Stockholm. My thesis is a health economic cost-effectiveness model built entirely in Excel — a gender-neutral static Markov cohort model with 34 worksheets. The file has become completely unusable after what I believe is the March 2026 security update, and I'm running out of options. The file: - .xlsm, ~46.5 MB compressed, ~370 MB uncompressed XML - 34 worksheets, four of which are 73–92 MB each (Markov trace sheets) - ~65,000 formulas, ~33,500 shared formulas - Heavy use of LET, LAMBDA, XLOOKUP, XMATCH, CHOOSECOLS, TAKE, MAP, SWITCH - 771 defined names including ~147 hidden _xlpm.* LET/LAMBDA variable placeholders - Stored on OneDrive via KI SharePoint, 34,000+ AutoSave revisions - Contains VBA (vbaProject.bin) The problem: Every time I open the file — on Excel for Mac or Excel Online — the repair engine triggers and strips ALL formulas from every sheet, replacing them with cached values. The file shrinks from ~46.5 MB to ~26 MB. Clicking "No" on the repair dialog just closes the file. There is no way to bypass the repair. What I've verified: - Extracted the .xlsm as a ZIP and confirmed all formulas (<f> tags) are fully intact in the raw XML - Libr€Office Calc can read the formulas but cannot execute them (Err:508 — no LET/LAMBDA support) - Removed 158 broken named ranges (#REF! and #NAME? entries) from workbook.xml and rebuilt the archive — repair engine still strips all formulas - The issue reproduces on every OneDrive version history copy (up until I largely used LET formulas in my sheets - but there is still 1,5months of changes lost) - The issue reproduces on both Excel for Mac and Excel Online Suspected cause: The March 10, 2026 security update (KB5002849) patched CVE-2026-26108, a heap overflow in Excel's file parsing during loading. The same patch was applied to Office Online Server (KB5002846). I believe the tightened parsing now rejects or flags my file's large XML structures as potentially malicious, triggering the repair engine to strip all formulas. This is consistent with: - The known _xlfn. namespace bug on Excel for Mac (reported by multiple users on Microsoft Q&A since late 2024) - The timing - the file was working before this update flawlessly up until March 16th - The fact that Excel Online is also affected (same server-side patch) My questions to the community: 1. Has anyone else experienced formula stripping on large workbooks after the March 2026 update? 2. Is there a way to bypass the repair engine on Mac, or roll back the specific security patch without downgrading all of Office? 3. Would opening this file on Windows Excel (pre-patch or current) preserve the formulas? If anyone with a Windows PC would be willing to try opening and re-saving this file, I would be incredibly grateful. 4. Is there now effectively a size/complexity ceiling for Excel workbooks that makes models like this unviable? If so - should I be migrating this to another environment (R, Python, etc.) going forward? This file represents six months of thesis work. The formulas are all there in the XML. I just need Excel to stop destroying them on open. Any help, pointers, or similar experiences would be hugely appreciated. Thank you, Florian Boschek
Market cap option in Stocks data type not working
Good morning, I am using Microsoft 365 Excel to track stock info like price, 52-wk high, 52-wk low, market cap and shares outstanding then using this data to introduce it in some formulas. But very recently the data for the Market Cap stop appearing and only showing #FIELD! instead. Does anybody know if the option was discontinued from Excel?Error message to say can't install add-ins (where ones I have stop appearing on toolbar)
Hi, I have an accountancy add-in for Excel which normally appears on my toolbar when I load Excel up. For some reason it wasn't there all of a sudden so tried to load it again as an add-in but just get an error message at the bottom of the screen to say that it can't be loaded and to try again later. Tried chatting with Microsoft Support who were no help at all and tried to blame it on the third party software not Excel until I tried loading other add-ins (including Microsoft ones) and get exactly the same message. Tried logging in and out of my account and shutting down and re-starting but to no avail. Any ideas/solutions would be most welcome! Thanks, David
Getting error when adding Add-ins in Excel
Hi all, I have trying to install add-ins to microsoft excel using a M365 Personal Account, and i keep getting an error "Add-in Error: We couldn't connect to the '{0}' catalog server for this add-in" screenshot attached below. I have tried on both Excel Web and and on the desktop Excel app and still the same issue, I have already had a session with microsoft support and they were not able to resolve this for me and directed me to this forum, Any help will be appreciated thanks in advance.
Stock symbol SKHY is missing in Excel's Stock data type
I have been frustrated trying to report a stock ticker symbol that is missing from Excel's Stock data type. SKHY is the ticker symbol for SK HYNIX INC ADR on NASDAQ. Excel responds with the following error when attempting to convert this symbol to a Stock data type: Data Type: Stocks No results found for "SKHY". How do I report this issue so that it can be fixed?
