Forum Discussion
Solved
Excel formulas with curly brackets not updating
This is in Excel 365 and also Excel 2016. I've my excel data and I've created a formula. This formula works just fine - to start with. The actual formula perhaps doesn't matter, but this is it -> ...
Confirm the formula with Ctrl+Shift+Enter each time you edit it.
HansVogelaar That's great to know that shortcut, but why? Why do I have to do that? Why doesn't the green tick do whatever that shortcut does?
thanks 👍
The curly brackets { } indicate that the formula is a so-called array formula. See Array formula for more info.
The curly brackets are created by pressing Ctrl+Shift+Enter, you should not type them yourself.
Remark: in Excel in Microsoft 365 and in Office 2021, it is no longer necessary to do that; all formulas are automatically evaluated as array formulas.