Excel link broken when using Report generation toolkit

[MSIEV]

Hello,

I am using Labview 2018.0.1 64bits and Microsoft Excel 365.

I want Labview to enter data into Excel, and perform calculations in Excel spreadsheet.

This spreadsheet contains links to another .xla spreadsheet which allow specific thermodynamic calculations.

The problem is that when Labview write data into excel, the links are broken, and I have to update manually the links.

Hereafter an example of my code:

The excel spreadsheet is located on the network, the linked .xla spreadsheet is on local drive.

Thanks

[MSIEV]

I want to add that I previously made some attempts using ActiveX functions.

I faced same issue.

However, with ActiveX functions, my process was slightly different:

Indeed, when Labview write data to Excel, the Excel file is opened (whereas I specified not to open), the data are written but the links are broken, and the Excel file remains open.

Then manually, I update the links, let the Excel file open, rerun the Labview code, and then it works.

But this manual operation is not desired and I want the Excel file remains close or at least minimized.

Here is the code with ActiveX:

Thanks in advance

[MSIEV · Accepted solution]

Finally, issue solved with an Excel Macro which update the links at the opening of the excel file.