Excel_Save_Workbook.vi Broken When Using the LabVIEW Report Generation Toolkit

Updated Apr 7, 2022

Reported In

Software

  • LabVIEW
  • LabVIEW Report Generation Toolkit

Other

  • Microsoft Excel

Issue Details

Using Excel_Save_Workbook.vi from the LabVIEW Report Generation Toolkit for Microsoft Office leads to a broken caller VI and LabVIEW reporting a block diagram error for an Invoke Node:
 
Invoke Node: Contains unwired or bad terminal

Solution

This error can happen when upgrading or using an incompatible version of LabVIEW and Microsoft Office. Please follow the steps below or install a compatible version of Office.
 
  1. Open Excel_Save_Workbook.vi. If LabVIEW was installed into the default path you should be able to find the VI at C:\Program Files (x86)\National Instruments\LabVIEW 20xx\vi.lib\addons\_office\_exclsub.llb\Excel_Save_Workbook.vi.
(Note: Change "20xx" to the version of LabVIEW you are using. Remove " (x86)" in case you are using the 64-bit version of LabVIEW.)
  1. Once the VI has been opened, find the Invoke Node inside the nested case structures No Error and False. This Invoke Node is set to SaveAs.
  1. Right-click the Invoke Node and select Relink Invoke Node.
  2. Save the VI and close it.
  3. Go back to your caller VI and try to run it. There should no longer be a broken run arrow.

In case the Relink Invoke Node option does not exist, please continue with steps 6 to 10:
  1. Mark the currently existing Invoke Node and copy it into the clipboard (e.g. via menu Edit » Copy).
  2. Delete the original Invoke Node.
  3. Paste the _Workbook SaveAs Invoke Node from the clipboard on the block diagram. Move it into the same position as it was before.
  4. Rewire the inputs and outputs as they were before:
  1. Once done, you save this VI and try running your main VI again. There should no longer be a broken run arrow.