Excel "Data Analysis" toolkit not working with Report Generator

[Amaes]

I'm having trouble with the excel functions in Report Generator

Whenever my program dumps to excel, the data analysis functions no longer work in that workbook. If I go into add-ins and uncheck the add-in, hit OK, then open the window again and re-check it, Data Anlysis works fine.

I tried writing a macro to do this automatically, but I don't want to have to open a template containing that macro every time I use excel.

Can I have the macro in the Labview program and just have it insert and execute every time I open a blank workbook?

Message Edited by Amaes on 09-14-2007 01:23 PM

[Stephanie B]

Hi Amaes -

This has been reported here and the macro idea seemed to be the solution there. However, this is possibly a bug. Could you possibly give me more information (LV version, Office version, where I check the Data Analysis) and possibly your code? I am currently using Office 2007. Thanks!

Stephanie