Inserting Document Variables

Last modified on 2024-05-15

Overview

For frequently used texts or formulations in Disclosure Management documents, document variables can be used, which can be retrieved and inserted in every Excel or Word file via the Word or Excel ribbon.

In Disclosure Management, predefined document variables are available for the year, previous year, and reporting date.

Insert Document Variable

To insert a document variable in Excel or Word documents:

  1. Select a cell in an Excel file or place the cursor at the desired position in a Word file.
  2. Click Insert Document Variable in the Excel or Word ribbon.

    Inserting a document variable via the Word ribbon

    The Insert Document Variable dialog will be displayed. The dialog lists all the document variables that have already been created, along with their Name, Value, and Description. Initially, this will contain document variables for the current year, previous year, and due date:

    'Insert Document Variable' Dialog in MS Word

  3. Select the desired document variable.
  4. Click Insert Document Variables.

When you insert document variables in MS Excel, corresponding names are created automatically for the relevant cells (see Names and Name Extensions in MS Excel).