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

Watch on YouTube

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