---
title: "Names and Name Extensions in MS Excel"
description: "To enable automatic insertion and updating of values in MS Excel files and interaction between MS Office files, names and/or name suffixes must be assigned to certain columns, cells and cell ranges in MS Excel. Names and name suffixes are used to link MS Word with MS Excel spreadsheets. You can easily insert and edit names and name suffixes for Lucanet Disclosure Management using the Excel ribbon."
source_url: https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/excel-files-disclmgmt/setup-excel-file
language: en
last_updated: 2023-08-16
---
# Names and Name Extensions in MS Excel

## Overview

To enable automatic insertion and updating of values in Excel files and interaction between MS Office files, **names** and/or **name suffixes** must be assigned to specific columns, cells and cell ranges in MS Excel. Names and name suffixes are used to link MS Word with Excel spreadsheets.

You can easily insert and edit names and name suffixes for Disclosure Management using the [Excel ribbon](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/ribbons-disclosure-mgmt.md).

In this chapter, we demonstrate the importance of names in Excel files and how to insert and edit names.

## Use Names and Name Suffixes

The following table shows the names that must or may be present in an Excel file so that the corresponding values and information are automatically inserted and/or updated in the Excel file:

#### outarea

**Outarea** for the export to Word. Outareas represent the data basis for the tables in result documents.

#### name_1

Defines a **name column**. The name column is a mandatory column. It contains the row labeling (i.e. the names of the individual report values).

#### value\_ _sequential number_period ID_

Defines a **value column**. A value column contains the report values of the current document. In columns that are defined as value columns, the values are inserted or updated **after each data import** and **when the Excel file is updated**.

#### prog\_ _sequential number_PeriodID_

Defines a **programming column**. The programming column is responsible for programming the contents of the column **value\_**. For example, it contains item numbers from the source system and other information for calculating the corresponding value columns.

#### footnote\_ _sequential number_period ID_

Defines a **footnote column**. The footnote column can be used to add footnotes to values of Excel files, which are then displayed in the Outareas in Word documents.

#### sn_duedate

**Due date** of the document

You can find additional information on variables under [Inserting Document Variables](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/use-document-variable.md).

#### sn_year

**Reference year** of the document, e.g. **2024**

You can find additional information on variables under [Inserting Document Variables](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/use-document-variable.md).

#### sn_prevyear

**Previous year** of the document, e.g. **2023**

You can find additional information on variables under [Inserting Document Variables](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/use-document-variable.md).

## Conditions for Names and Name Suffixes

The following conditions for names and name suffixes must be observed when programming in MS Excel:

- In MS Excel, different cells, cell ranges and columns must be assigned unique names.
- When using names in MS Excel, you must observe the distinction between upper and lower case letters.
- Disclosure Management uses sequential numbers when assigning names, as MS Excel does not allow identical names. This is particularly important when names are entered manually by the user in Excel.
- Cells and columns can be assigned several names simultaneously in Excel (e.g. a column defined as **value_1\_CURRENTYEAR01** and as **value_1\_PREVIOUSYEAR01**). However, only one name is displayed when the column is selected in alphabetical order.

{% idea-box %}
While it is possible to program on multiple worksheets, we recommend minimizing the number of worksheets for performance reasons.
{% /idea-box %}

## Creating Names

You have several options for creating names in MS Excel:

### Using the Excel Ribbon

The simplest option for assigning a name is the **Excelribbon** for Disclosure Management. Proceed as follows:

{% stepper %}
{% stepper-step %}
In MS Excel, select the cell, cell range or column for which you want to assign a new name. Depending on which cell, row or column you have selected, the available buttons are enabled in the Excel ribbon based on the context.

The 'Name' button in the Excel ribbon

{% /stepper-step %}
{% stepper-step %}
Click the desired button in the Excel ribbon.

{% /stepper-step %}
{% /stepper %}
### Using the Context Menu

You can also use the Disclosure Management context menu to assign names. Proceed as follows:

{% stepper %}
{% stepper-step %}
Select the desired cell, row or column.
{% /stepper-step %}
{% stepper-step %}
Right-click to open the context menu.

{% /stepper-step %}
{% stepper-step %}
The **Disclosure Management** menu contains the functions provided by Disclosure Management based on the context:

'Disclosure Management' context menu in MS Excel

{% /stepper-step %}
{% /stepper %}
### Using the Name Manager

You can also use the MS Excel name manager to create names. Proceed as follows:

{% stepper %}
{% stepper-step %}
Select the cell or column for which you want to assign a name.
{% /stepper-step %}
{% stepper-step %}
In the Excel ribbon, click in the **Name Management** area on **Name manager**.

Open the name manager from the Excel ribbon

{% /stepper-step %}
{% stepper-step %}
In the name manager, click **Create**.
{% /stepper-step %}
{% stepper-step %}
The **Create Name** dialog is displayed:

Creating a new name in MS Excel

{% /stepper-step %}
{% stepper-step %}
Specify the new **name** and click **OK**.

{% /stepper-step %}
{% /stepper %}
{% warning-box %}
We recommend that you always use the **Excel ribbon** or the **Disclosure Management** context menu to insert names, as this avoids errors due to incorrect spelling.
{% /warning-box %}

## Editing Names

All existing names can be filtered, sorted, edited and deleted using the MS Excel **name manager**.

{% warning-box %}
Changes to names have a direct impact on programming or links in MS Word. If, for example, the name of the Outarea (**outarea**) is changed, the Outarea must be reinserted in MS Word.
{% /warning-box %}

To edit a name via the Excel name manager:

{% stepper %}
{% stepper-step %}
In the Excel ribbon, click in the **Name Management** area on **Name manager**.

Open the name manager from the Excel ribbon

{% /stepper-step %}
{% stepper-step %}
In the name manager, select the name you want to edit.

Name manager in MS Excel

{% /stepper-step %}
{% stepper-step %}
Click **Edit**. The **Edit Name** dialog is displayed:

Edit name in MS Excel

{% /stepper-step %}
{% stepper-step %}
Edit the **name** and click **OK**.

{% /stepper-step %}
{% /stepper %}