|
Unwanted Array Formulas (CSE) in previous versions
Any formula that Excel DA thinks could return an array (even if it is actually only returning a single value) is converted to a CSE array formula in previous versions.
This may or may not produce a backward compatibility problem – you have to inspect these formulas carefully.
CheckDA flags these formulas as types:
{1} a single-cell non-spilling formula
# An Excel DA Dynamic Array formula that is spilling or blocked (#Spill!) and will be converted to a fixed CSE formula in Excel 2013
{n} a formula entered in Excel DA as a multi-cell CSE formula
|
