Creating and Editing Excel Files | Lucanet Knowledge Base

Documentation

Getting Started

Global Functions

Lucanet Lume

Administration

Data Hub

Consolidation & Financial Planning

Lease Accounting

Extended Planning & Analysis (xP&A)

ESG Reporting

Disclosure Management

The Lucanet Disclosure Management User Interface

All Steps at a Glance

Basic Configuration

Dashboard

Configuring a Document

Cockpit

Creating and Editing Chapters

Creating and Editing Periods

Importing Data

Working with MS Office Files

MS Office Variants

Ribbons for Disclosure Management

Creating and Editing Excel Files

Mode of Excel Files

Configuring an Excel File

Names and Name Extensions in MS Excel

Creating and Editing Columns

Inserting Report Values in MS Excel

Defining Outareas

Programming References

Using Layouts in MS Excel

Inserting Tables From ESG Reports

Using the Area and Column Assistant

Creating and Editing Word Files

Versioning and Recovery of MS Office Files

Creating and Inserting Document Variables

Reviewing Layout Check Violations

Creating and Editing PowerPoint Files

Creating and Editing Validations

Using the Data View

Using the XBRL Tagger

Creating Result Document

Rolling Forward or Copying a Document

Editing Documents in the XBRL Tagger

XBRL Tagger

Tax Compliance & Reporting

Banking & Cash Management

Data Collection

Glossary

Excel files provide the data for Word reports and PowerPoint presentations in Lucanet Disclosure Management. You can insert linked Excel tables and charts into Word and PowerPoint files and update them from the saved Excel sources. One Excel file can be assigned to each chapter of a document in the Cockpit.

To insert tables or charts into PowerPoint files, you must use Office Native. If necessary, check the configuration in the Configure document workspace.

Excel files can be created in the Cockpit of Disclosure Management or in the detail view of a chapter. Alternatively, existing files located in the local file directory can be assigned to a chapter to create a new Excel file.

To create an Excel file for a chapter in Disclosure Management:

Click Cockpit in the overview or click Document in the function bar.

Shows the Cockpit of the document 'Report 2024' in Disclosure Management with the chapter list and the columns 'CHAPTER NAME', 'STATUS', 'VALIDATIONS', 'MS WORD' and 'MS EXCEL'. Highlighted in red are 'Document' in the function bar and 'Cockpit' in the overview. — Opening a document in Disclosure Management

Click the three dots icon

at the end of the desired chapter row.

Choose MS Excel | Add Excel file or MS Excel | Add external Excel file from the context menu.

Shows the context menu of a chapter in the Cockpit of Disclosure Management with the entries 'MS Word', 'MS Excel', 'Change status' and 'Delete chapter' and the submenu of 'MS Excel' with 'Add Excel file' and 'Add external Excel file'. Highlighted in red are the three dots icon, 'MS Excel' and 'Add Excel file'. — Creating a new Excel file

MS Excel will open with a new workbook. As soon as you Check In the file, it will be displayed in the MS Excel column of the Cockpit.

Excel files assigned to a chapter can be opened from the Cockpit of Disclosure Management for editing purposes.

To open an Excel file for a chapter in Disclosure Management:

Click Cockpit in the overview or click Document in the function bar.

You have two options for opening the file:

Click the desired file.

Click the

three dots icon

at the end of the desired chapter row and choose

MS Excel | Open Excel file

from the context menu:

Shows the context menu of a chapter in the Cockpit of Disclosure Management with the entries 'Data view', 'MS Word', 'MS Excel', 'Change status' and 'Delete chapter' and the submenu of 'MS Excel' with 'Open Excel file', 'Delete Excel file' and 'Unlock file'. Highlighted in red are the three dots icon, 'MS Excel' and 'Open Excel file'. — Opening an Excel file from the Cockpit

The file will open in MS Excel and can be edited using the Excel ribbon.

In Lucanet Disclosure Management, you can replace the Excel file of a chapter with a locally saved file in .xlsx format. The chapter is retained. Existing links to Outareas remain usable if the replacement file contains the Outareas under the same name.

The following prerequisites apply to replacing an Excel file in Lucanet Disclosure Management:

An Excel file is already assigned to the chapter.

You have editing permissions for the Excel file; the document is not read-only.

The Excel file is not locked for editing.

MS Office Native

MS Office for Desktop

is configured for the document. With

MS Office for the Web

, the command for replacing is not offered.

To replace the Excel file of a chapter in Lucanet Disclosure Management:

Open the required document and select Cockpit.

Open the three-dot menu at the end of the required chapter row and select MS Excel | Replace Excel file.

Shows the context menu of a chapter in the cockpit of Lucanet Disclosure Management with the open 'MS Excel' submenu. The submenu contains 'Open Excel file', 'Replace Excel file', and 'Delete Excel file'. — Replacing an Excel file via the chapter menu

Alternatively, open the detail view of the chapter and click Replace Excel file in the Excel area.

In the file selection dialog, select the required .xlsx file and confirm the selection.

MS Excel displays the replacement file for editing. Check the content, Outareas, and programming. When opening, the values of the uploaded file are used.

Check in the file after editing. Only then do you transfer the replacement file as the saved state of the chapter. Check the new state and the check-in in the History of the chapter.

When an Excel file is replaced in Lucanet Disclosure Management, report data is assigned based on the programming. The cell position is not relevant for this. For matching programming, the links to text values, validations, footnotes, and XBRL assignments are retained. The Excel settings of the chapter, for example factor and number format, are also retained.

If programming used so far is missing in the replacement file, the check-in points out report data that will be omitted and affected Word links. Check this information before you confirm the process. Outareas that are missing or have been renamed in the replacement file can no longer be updated via existing links.

With table placeholders in Lucanet Disclosure Management, you transfer the unit and the number factor of a chapter to individual Excel cells. In Office for Desktop, you can assign the placeholders using the Excel ribbon or the context menu of a cell.

The following table describes the three table placeholders in Lucanet Disclosure Management:

Placeholder	Content
`sn_unit`	Label of the unit for the number factor used, for example Tsd. for the factor 1000. The configured unit labels are decisive. For the factor 1, the configured currency is used.
`sn_factor`	Number factor used, for example 1000.
`sn_unitindex`	Index of the unit: 1 for factor 1, 2 for 1000, 3 for 1000000, and 4 for 1000000000. For other factors, 0 is entered.

The placeholders refer to the Excel file and are filled with the associated values by Disclosure Management. They are not document variables and are not created in the document variable management.

To assign a table placeholder in Office for Desktop:

Open the Excel file of the required chapter for editing and select exactly one cell.

On the Disclosure Management ribbon, open Insert | Insert placeholder and select the required placeholder, for example sn_unit. Alternatively, open the context menu of the cell and select Insert placeholder and the required entry there.

Check in the Excel file to save the assignment.

Each table placeholder can only be assigned once per Excel file. If it already exists, the corresponding insert command is locked. If several cells are selected, the insert commands are also locked.

To move a placeholder, select the new target cell and select the relevant placeholder under Move on the ribbon. To remove it, use Delete placeholder and the required entry in the context menu. This removes the assignment of the placeholder.

Placeholder names taken over from older files, such as einheit, factor, and einheitindex, are also recognized. For a placeholder that has already been assigned, use the function for moving instead of creating a second placeholder. The assignment applies to the entire workbook.

Excel files in Disclosure Management can be edited using the Excel ribbon. The Excel ribbon provides specific functions tailored to Disclosure Management:

Shows the 'Disclosure Management' tab of the Excel ribbon in Office for Desktop with the areas 'Server', 'File', 'Name management', 'Cells', 'Columns', 'Settings' and 'Layout'. — Excel ribbon for Disclosure Management

The Ribbons for Disclosure Management chapter provides an overview of all the functions available in the Excel ribbon.

Have you not installed the ribbons yet? Then go to the Toolbox of Disclosure Management and first install the Excel ribbon, the Word ribbon, and the Dispatcher. The Dispatcher is responsible for communication between Disclosure Management and the MS Office files.

This content was generated using AI and reviewed by Lucanet subject matter experts before publication.

Page IDKB9138182

Last updated on Oct 20, 2026

Overview

Creating Excel Files in Disclosure Management

Opening Excel Files in Disclosure Management

Replacing Excel Files in Disclosure Management

Links and Report Data When Replacing

Using Table Placeholders in Lucanet Disclosure Management

Editing Excel Files in Disclosure Management

Creating and Editing Excel Files in Disclosure Management