There are some issues when using incompatible versions of LabVIEW and Microsoft Office. These issues could cause Report Generation Toolkit VIs to break as well as Microsoft Office.
In order to resolve this issue, take the following steps. While some of these steps use Excel Sort Data.vi
as an example, the repair steps for fixing other VIs are analogous.
Make sure you are using a compatible version of Microsoft Office 32-bit .
- 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)".
- Once this VI has been opened, click the broken run arrow, select the invoke node error message, and click Show Error.
- This takes you to the invoke node inside the nested case structures.
- Once you found the invoke node, perform a right-click anywhere on it, and select Relink Invoke Node:
- If the Relink Invoke Node selection does not appear, you may need to fix the VI by replacing it with the invoke node.
- Select the invoke Node (in the picture above it is the tan block that says Range).
- Copy and paste it on your block diagram.
- Delete the old invoke node, and replace it with 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 the connections should be made.
- 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:
- 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.
- If you get an error message "The VI already exists and you do not have permission to replace it." when saving the VI, make sure the VI is not set to read-only in Windows.
- 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.
- If the issue still persists, perform a reinstall of the Microsoft Office software. This will resolve the behaviour in cases where corruption during installation has occurred.