Using CheckDA

CheckDA requires Windows Office 365 Dynamic Array Excel 2016.

Clicking the Check DA Formulas button shows the Check DA form.

The form:

Shows formulas in Non-DA Syntax

Is Modeless (you can edit formulas while still showing the form)

Is Resizeable

At start-up scans the active worksheet for unique formulas

At start-up filters out formulas with unexpected @ or Spill Ref or Spill or single-cell Array formulas

Restate Selected Formulas

Any @ or {1} formulas selected in the form will be changed in the workbook.
@ formulas will have their unexpected @s removed.
{1} formulas will be re-entered as non-array formulas.
# Spill formulas and {#} Spill Ref formulas cannot be automatically restated.

Undo Restate

Any formulas restated in this session of CheckDA will have their restatement undone.

Show Office 365 DA Syntax

This button toggles between showing the formulas in Non-DA syntax and Office 365 Dynamic Array syntax.

Copyright © 2020 Decision Models Ltd