The purpose of the cell reference expression functionality is to dynamically store standard cell references in Microsoft Office Excel within the model. A cell reference refers to a cell or range of cells on a worksheet and can be used in a formula, allowing Excel to search for the values or data you wish to calculate using that formula. Invantive Control for Excel automatically converts the predefined cell reference expression in Excel to the cell reference that Excel uses. In the block, you can specify a cell reference expression for a column that refers to another column. After synchronisation, a reference is created in the cells of the column (with a cell reference expression) to the location in Excel that the expression refers to.