Excel - Why Formula Fails After Simple Edit (Curly Braces Disappear) - Episode 1368
757 views · Published 24 March 2011 · 2:29 · Indexed 14 November 2026
Channel: MrExcel.com · 2011 · Education
Microsoft Excel Tutorial: Fixing Edited Formula Fail - Array Formulas & Frustrations | MrExcel Podcast. The Scenario? Brendan created a cool Formula about six months ago. He edited that Formula today and it won't work anymore. In Episode #1368, Bill shows you why and how to correct the issue. Welcome to another episode of the MrExcel Podcast. In today's episode, we will be discussing a common issue that many Excel users face - editing a formula and then finding out that it no longer works. This can be incredibly frustrating, as demonstrated by our viewer Brendan who sent in today's question. Brendan had a perfectly functioning formula in his spreadsheet, but needed to make a simple change from "utilities" to "lines." However, upon pressing Enter, the formula stopped working. He was left wondering why Excel seems to hate him and why editing a formula can cause such a headache. The answer lies in the fact that the formula in question is actually an array formula, denoted by the curly braces around it in the formula bar. Microsoft refers to these as array formulas, but I prefer to call them CSE formulas - Ctrl+Shift+Enter formulas. This is because in order to edit an array formula, you need to hold down Ctrl and Shift while pressing Enter. This can be quite confusing and difficult to remember, leading to frustration for users like Brendan. I believe that Microsoft could do better in this aspect and make it easier for users to edit array formulas without having to remember complex key combinations. It would be great if Excel could automatically recognize and handle array formulas, making the editing process much smoother. Until then, we will have to deal with this frustrating fail in Excel. Thank you for tuning in and we'll see you next time for another episode of the MrExcel Podcast. Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Edited Formula Not Working (00:14) Brendan's Formula Issue (00:32) Formula Not Working After Edit and Previous Formula Worked (00:48) Solution: CSE Formula (01:09) Explanation of CSE Formula (01:29) Editing an Array Formula (01:45) Frustration with CSE Formula (02:16) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Array formulas CSE formula Ctrl+Shift+Enter Editing array formulas Excel frustrations Excel troubleshooting Formula editing Learn Excel Microsoft fail Spreadsheet tips Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153047/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920