Cannot Save Excel Report in NI-LabVIEW 2022 by Using Report Generation Toolkit

Updated Mar 15, 2023

Reported In

Software

  • LabVIEW 2022 Q3
  • LabVIEW 2022 Q3 Report Generation Toolkit

Issue Details

I am using Report Generation Toolkit for saving an Excel report, but unfortunately, during the VI execution, it automatically closes the Excel file and removes it.

Solution

In order to solve the issue, follow the steps below:
1. Navigate to the path C:\Program Files | Program Files (X86)\National Instruments\LabVIEW 2022\vi.lib\addons\_office\_exclsub.llb

If the 32-bit LabVIEW is being used, use the Program Files (X86) folder, otherwise use the Program Files folder.

2. Open the Excel_Save_Workbook.vi.
The _Workbook invoke node should be grayed out, as shown in the screenshot below.
image.png

3. Right-click on the Invoke node and select Relink Invoke Node option.
image.png

After completing the step above, the invoke node will be enabled.
image.png

4. Save the VI.