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.
Something else I used to do with legacy versions of Excel (mine was 2010) was to enter the formula as the 'Refers to' value of a defined Name. Excel always did complete the calculation as a defined name whereas the same formula on the grid worked with single values extracted from the input arrays. CSE was the cumbersome way of telling the Excel worksheet formula that it was to use the entire arrays rather than performing the 'implicit intersection' step first.