Excel Update Radar
Excel Update Radar
New and removed Excel functions explained - what changed, which versions have it, and a will-this-break-your-workbook checklist for each.
- excel-update
- excel updates
- new excel functions
- microsoft 365
Each entry covers one Excel change: what it does, which versions have it, and what to check before it reaches a workbook other people rely on. Facts come from Microsoft's support pages and Excel blog, linked at the end of each post.
Excel Update Radar
New and removed Excel functions explained - what changed, which versions have it, and a will-this-break-your-workbook checklist for each.
Excel COPILOT Function Removed: Fix the #NAME? Errors
Microsoft removed the COPILOT worksheet function on 14 September 2026. How to find affected cells, keep the cached results and move to the Copilot pane.
Excel REGEX Functions: REGEXTEST, REGEXEXTRACT, REGEXREPLACE
Excel's three regex functions with worked examples - validate a GSTIN, extract emails, strip phone numbers - and the compatibility check before sharing.
Excel TRIMRANGE and Trim References (A:.A) Explained
TRIMRANGE and the trim-reference operators cut blank rows off range edges - syntax, examples and the mismatched-size trap.
Excel GROUPBY and PIVOTBY: Pivot Tables as Formulas
GROUPBY and PIVOTBY build a summary table with one formula that recalculates on its own - syntax, five finance examples and what to check before replacing a PivotTable.
Excel IMPORTCSV and IMPORTTEXT: Load a File With One Formula
IMPORTCSV and IMPORTTEXT load a CSV or text file into a dynamic array with one formula - syntax, examples and why they are not ready for shared reports yet.
Not sure whether a change affects your workbooks? Send the file for a free check.
Calls scheduled in your timezone (UK, EU, US, UAE, APAC) · How a project works