---
title: "Lucanet.Excel-Reporting"
description: "Das Lucanet.Excel-Reporting dient zum Erstellen von Standardberichten, die beliebig verteilt und unabhängig von einem Lucanet-Zugang oder Internet-Zugang angezeigt werden sollen. Das Erstellen eines Berichts und seine Konfiguration erfolgen direkt aus Lucanet heraus. \nAlle Berichte werden auf Basis von Berichtsvorlagen erstellt, die in Lucanet abgespeichert werden."
source_url: https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/lucanet-excel-reporting
language: en
last_updated: 2023-08-16
---
## Lucanet-Excel-Reporting

**Lucanet.Excel-Reporting** is used to create standard reports that can be distributed as required and displayed without a Lucanet account or an internet connection. Reports are created and configured directly on the CFO Solution Platform in a [workspace configured for this purpose](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/lucanet-excel-reporting/configure-workspace-excel-reporting.md).

All reports are created based on [reporting templates](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/lucanet-excel-reporting/create-and-edit-reporting-templates.md) that are saved in Lucanet. Excel files can be used as reporting templates.

The data are queried from Lucanet using [tilde formulas](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/lucanet-excel-reporting/work-with-tilde-formulas.md) that are defined in the reporting templates.

The [generated Excel reports](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/lucanet-excel-reporting/generate-excel-report.md) do not contain specific macros or references to the database and can therefore be forwarded as required.

{% warning-box %}
The **macros** included in **XLSM files** are not run when creating Excel reports with Lucanet.Excel-Reporting. The macros are, however, retained when XSLM files are uploaded to Lucanet so that macros in the generated report can be run using MS Excel.
{% /warning-box %}

# Supported Excel Versions

Lucanet.Excel-Reporting supports **XLS**, **XLSX**, and **XLSM files** from the following Excel versions, depending on the operating system:

#### - MS Excel 2016 to 2021
- MS Excel 365

- MS Excel 2021 for macOS
- MS Excel 365 for macOS

{% tiles %}
{% tile image="_images/en/buecherspiegel-72ppi.png" href="./configure-workspace-excel-reporting" %}
Configuring Workspaces
{% /tile %}
{% tile image="_images/en/berichtenanalysieren-72ppi.png" href="./create-and-edit-reporting-templates" %}
Creating Reporting Templates
{% /tile %}
{% tile image="_images/en/gettingstarted-72ppi.png" href="./work-with-tilde-formulas" %}
Working with Tilde Formulas
{% /tile %}
{% /tiles %}