Labview reports 'Excel Sort Data.vi' in Report Generation Toolkit is broken.

[BoKnows · Accepted solution]

It appears you're running into similar behavior documented in this KB:
https://knowledge.ni.com/KnowledgeArticleDetails?id=kA00Z0000019N7CSAU

The same troubleshooting steps, only applied to the VI in question here, should fix your VI. 

[McQuillan]

KCS articles for the win.

I couldn't search for this article when troubleshooting. Please add 'Excel Sort Data.vi' as an example vi that breaks in the article as most people on the forums have error codes pointing towards this VI.

[Dhubbell]

---

@BoKnows wrote:

It appears you're running into similar behavior documented in this KB:
https://knowledge.ni.com/KnowledgeArticleDetails?id=kA00Z0000019N7CSAU

The same troubleshooting steps, only applied to the VI in question here, should fix your VI. 

---

PERFECT!  THAT WORKED!  THANK YOU BOKNOWS!  KUDOS!  

1)

2)

3)

[STTAndy]

It seems Bo really does know. Thank you I have marked it as the solution and another lesson learnt.

I did not know Office had updated, microsoft doing things quietly in the background again, I don't feel I am working alone here

[ikaiser]

I just updated the Knowledge Base article Report Generation Toolkit VIs Broken After Updating Office 365 to illustrate the recent changes in Office 365 as described above. Thanks to BoKnows and Tom for noticing!

[mtsmilt]

Great thread...  It fixed my problem as well. MS Office update is what caused issue on my end.

[ikaiser]

Just in case more run into this issue: I just updated the Knowledgebase article to reflect all changed needed to fix "Excel Sort Data.vi": LabVIEW Report Generation Toolkit VIs Broken

Please note that there are also repair steps available for 'Excel_Save_Workbook.vi': VI Is Broken When Using Excel_Save_Workbook.vi