|
Check DA: Compatibility of Office 365 Dynamic Array Formulas
Note:
Check DA is not available in fastExcel V4 Manager Pro for Mac.
The introduction of Dynamic Array formulas in Office 365 Excel 2016 has made a fundamental change to formula behaviour and syntax:
In previous versions such as Excel 2013, Excel automatically used implicit intersection to select a single value from a range in many circumstances.
In Office 365 Dynamic Array Excel 2016 (Excel DA), Excel treats all formulas as array formulas unless the implicit intersection operator @ is used, and single-cell dynamic array formulas will spill their arrays to surrounding cells.
Forward compatibility for workbooks authored in previous versions of Excel is good: implicit intersections will be silently converted to the new @ syntax.
In most cases workbooks authored in Dynamic Array Excel (Excel DA) will also be silently converted to the old syntax (@ will be removed where possible, and spilling dynamic arrays converted to array (CSE) formulas) when opened in previous versions.
But it is possible to create formulas in Excel DA which cause difficulties when opened in previous versions.
CheckDA is a tool to scan Excel DA formulas, highlight potential backward compatibility problems and optionally convert problem formulas to more compatible versions.
|
