Will [non-dynamic] array formula entered in 365 without Control Shift Enter work in Excel 2010?

[kcmuppet]

Hello,

Given you don't need anymore in 365 to use to work with array formulae and functions...

what happens when somebody with Excel 2010 opens a spreadsheet created in 365, in which the formulae weren't originally entered with Control + Shift +Enter (and presumably don't have the curly parentheses { } ?

Does Excel 2010 recognise the formulae as array formulae?

(I'm hoping not to have to go back and change hundreds of formulae in order that somebody with an older version can use the workbook)

 

[Fluff]

Does Excel 2010 recognise the formulae as array formulae?

I very much doubt it. If you need the sheet to be backwards compatible, your formulae will need to be built as if you were using 2010.

 

[kcmuppet]

I'm thinking I might be lucky, given when I attempt to save further back - version 97-2003 - a compatibility warning comes up which says,

"One or more cells in this workbook contain a formula that has spilled or may spill in the future. These formulas will be converted into legacy array formulas and will not spill or change dimension in older versions of Excel."

....but, the problem is I'm not able to save specifically to Excel 2010 (isn't an option in my list) and I have used formulae that work with 2010 but were not available in 2003, so can't simply save as 2003 .xls.

I suppose I'll have to try it when I get back to the office and see what happens.