LabVIEW Report Generation Toolkit VIs Broken

Updated Oct 8, 2018

Reported In

Software

  • LabVIEW Report Generation Toolkit
  • LabVIEW

Other

Microsoft Office 365 

Issue Details

I have a LabVIEW program that uses the LabVIEW Report Generation Toolkit. Recently, I started receiving an error that one VI, such as Excel_Save_Workbook.vi or Excel Sort Data.vi, and all its dependencies are broken. How can I fix this?

Solution

Small differences between versions of Microsoft Office can cause Report Generation Toolkit VIs to break. In order to resolve this issue, take the following steps. While these steps use Excel Sort Data.vi as an example, the repair steps for fixing other VIs are analogous.
  1. Check the version of Microsoft Office 365. If your Microsoft Office 365 version is 1609 or newer, continue to the steps below.
  2. Open the broken VI, e.g. C:\Program Files (x86)\National Instruments\LabVIEW <version number>\vi.lib\addons\_office\excel.llb\Excel Sort Data.vi.
 
Note: Change <version number> to the specific version of LabVIEW you want to repair. Using a 64-bit version of LabVIEW, the top folder is typically C:\Program Files\, without "(x86)".
 
  1. Once this VI has been opened, click the broken run arrow, select the invoke node error message, and click Show Error.
 

 
  1. This takes you to the invoke node inside the nested case structures.
 
 
  1. Once you found the invoke node, perform a right-click anywhere on it, and select Relink Invoke Node:
 
 
  1. If the Relink Invoke Node selection does not appear, you may need to fix the VI by replacing the invoke node. Select the invoke Node (in the picture above it is the tan block that says Range), then copy and paste it on your block diagram. Delete the old invoke node, and replace it to the new invoke node by rewiring the missing terminals. It is a good idea to save a previous copy or take a screenshot of the old vi before deleting the node so that you know where to connections should be made.
 
  1. This should cause another input node to appear at the bottom of the list, e.g. named SubField1 in the VI used as example here:
 
 
  1. Once this is done, the run arrow should no longer be broken. Save Excel Sort Data.vi and try running your main VI once more.
 
  1. If this does not fix the issue, mass-compile the folder that Excel Sort Data.vi is found in. This can be done by clicking menu Tools»Advanced»Mass Compile from in LabVIEW. Then navigate to the folder in which Excel Sort Data.vi is found and select Current Folder.

Additional Information

Another VI that gets typically broken by changes in Microsoft Office 365 is C:\Program Files (x86)\National Instruments\LabVIEW <version>\vi.lib\addons\_office\_exclsub.llb\Excel_Save_Workbook.vi.

Here the invoke node is named _Workbook with the SaveAs selector. Right-click and select Relink Invoke Node to make the new input node WorkIdentity appear at the bottom.


WAS THIS ARTICLE HELPFUL?

Not Helpful