A question about LabView reporting tools to Excel templates to dynamically add worksheets & data and update formulas

[ll cool]

I am using the report tool to dynamically add worksheets and data to a template during the report generation process. The template has static work which has formulas that refer to the data in the dynamically added worksheets, but I find that the formulas are not updated in the generated report, does anyone know what causes this? How can I fix it?

didn't want black borders on the cells I was writing to, but I still get this problem with Excel easy table.vi. It doesn't seem to be a cell formatting issue either.

 

 

 

[Neil Pate]

You are writing text into the spreadsheet, maybe that is why your formulas are broken.

Have you tried writing numbers instead?