---
title: "Troubleshooting Guide"
description: "This guide serves as a central resource for resolving issues you are facing with the CFP Add-in for Excel 365 efficiently.\n\nEach entry includes the problem description, root cause, and the steps taken to fix it."
source_url: https://support.lucanet.com/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/troubleshooting-cfp-add-in
language: en
last_updated: 2023-08-16
---
# Troubleshooting Guide for CFP Add-in for Excel 365

## Overview

This guide serves as a central resource for resolving issues you are facing with the CFP Add-in for Excel 365 efficiently.

Each entry includes the problem description, root cause, and the steps taken to fix it.

The page will be amended continuously to ensure fast, consistent problem-solving.

## Lucanet Formulas Show the Prefix '\_xldudf\_' (e.g., "\_xldudf_LN_VALUE")

### Error Description

You work with the Lucanet.Excel Add-In and notice that your Lucanet formulas are displayed with the prefix **\_xldudf\_**, e.g. \_ **xldudf_LN_VALUE** instead of their expected format (**LN.VALUE**).

This indicates that Excel cannot recognize or resolve the custom Lucanet functions such as LN.VALUE(), LN.ATTRIBUTE(), and other LucaNet-specific formulas used to retrieve data from Consolidation & Financial Planning (CFP).

### When Does the Error Occur?

The error typically occurs when two or more versions of the Lucanet.Excel-Add-In are installed and active simultaneously:

- **Lucanet COM add-in** \- the legacy Lucanet.Excel-Add-In

- **CFP Add-in for Excel 365** – the modern Office 365-compatible version

Since both add-ins use identical formula names, Excel cannot determine which version to execute, causing the function resolution to fail.

### How to Fix the Error

To fix the error, you must deactivate the legacy Lucanet.Excel-Add-In while keeping the CFP Add-in for Excel 365 active. Proceed as follows:

{% stepper %}
{% stepper-step %}
Open Excel and go to **File | Options**.
{% /stepper-step %}
{% stepper-step %}
In the **Excel Options** dialog, navigate to **Add-ins** in the left sidebar.
{% /stepper-step %}
{% stepper-step %}
From the **Manage** dropdown list, select **COM Add-ins** and click **Go**.

Excel options
{% /stepper-step %}
{% stepper-step %}
Deactivate the check box for **Lucanet COM add-in**.
{% /stepper-step %}
{% stepper-step %}
Click **OK**.
{% /stepper-step %}
{% stepper-step %}
Close and restart Excel.
{% /stepper-step %}
{% /stepper %}

After restart, Lucanet formulas will display correctly without the \_ **xldudf\_** prefix. The COM add-in remains on your system and can be reactivated if needed.

### What Does This Mean for My Workbooks?

Deactivating the COM add-in does not delete it from your system - it simply prevents it from loading when Excel starts. You can reactivate it later if needed by following the same steps and activating the check box again.

The CFP Add-in for Excel 365 will handle all Lucanet formula calculations going forward.

## Automatic Formula Calculation Disrupts the Workflow

### Error Description

When multiple users edit the same Excel file simultaneously using the CFP Add-In for Excel 365, Excel recalculates the formulas very frequently. This slows down MS Excel and affects workflow.

This behavior depends heavily on the file size, the number of formulas, and the number of users editing the file.

### When Does the Error Occur?

This error typically occurs when:

- Multiple users are working on the same workbook at the same time, and
- MS Excel automatically recalculates the formulas (the default behavior for automatic calculation).

### How to Fix the Error

To fix the error, every user working on the file must disable automatic formula calculation in MS Excel.

To do this, open the **Formulas** tab in the Excel ribbon and select the **Manual** option under **Calculation Options**:

Deactivating automatic formula calculation

You can then manually calculate formulas using the **Refresh** button on the **Lucanet CFP Add-in** tab in the Excel ribbon.

## LN Formulas Show a #NAME? Error After Migrating from the COM Add-In

### Error Description

After migrating from the Lucanet COM Add-In to the CFP Add-in for Excel 365, LN formulas in existing workbooks display a **#NAME?** error when the workbook is opened. The formulas do not return data on the first load.

Once a cell containing an LN formula is activated (for example, by pressing **Enter**) or the formula is re-entered manually, the data refreshes correctly.

### Why Does the Error Occur?

The COM Add-In and the CFP Add-in for Excel 365 are built on fundamentally different technologies. When an LN formula is entered using the Lucanet COM Add-In, Excel stores a hidden reference in the cell pointing specifically to that add-in. When the workbook is subsequently opened with only the CFP Add-in for Excel 365 active, Excel cannot find the original add-in reference and displays **#NAME?**.

### How to Fix the Error

To register all LN formulas in the workbook to the CFP Add-in for Excel 365, use Excel's **Find & Replace** function to force Excel to re-evaluate the formulas:

{% stepper %}
{% stepper-step %}
Open the affected workbook with the CFP Add-in active.
{% /stepper-step %}
{% stepper-step %}
Press **Ctrl+H** to open the **Find & Replace** dialog.
{% /stepper-step %}
{% stepper-step %}
In the **Find what** field, enter **=**.
{% /stepper-step %}
{% stepper-step %}
In the **Replace with** field, enter **=**.
{% /stepper-step %}
{% stepper-step %}
Click **Replace All**.
{% /stepper-step %}
{% /stepper %}

Excel re-evaluates all formulas in the workbook and registers them under the CFP Add-in for Excel 365. After this step, LN formulas will work correctly on subsequent opens.

{% info-box %}
This step is required once per workbook after migrating from the COM Add-In to the CFP Add-in for Excel 365.
{% /info-box %}