Each of the generating .xlsm files comes with some built-in macros that support special editing behavior. By default, Excel disables these macros.
-
Click Options on the Security Warning message to enable these macros In the Excel workbook.
-
Click Enable this content in the Microsoft Office Security Options dialog box, and then click OK.
Once macros are enabled, the following behavior is supported:
-
Clicking an empty UID cell or selecting a range of empty UID cells will automatically populate the selected cells with an automatically generated GUID
-
Clicking an empty DefUID cell (or range of cells) will automatically populate the selected cells with the relationship type for the worksheet
-
Clicking a cell for UID1 or UID2 will display a dialog box that contains a combo box of potential values (from the workbook) for that cell