Programming an Excel Pivot Chart

[id]

I have designed an excel pivot chart in Excel.  I want to update the chart using data calculated in labview for dynamic plotting.  I can copy the labview data to excel worksheet fields but can not seem to "recalculate" the pivot table that the pivot chart plots from.

Does anyone know how to programmatically update the pivot charts using updates to the worksheets that the pivot tables are created from ?

[Harold_Timmis]

maybe you can use the Excel Macro example that ships with labview to help you.

[id]

Thanks but I am beyond that stage.

I have a excel worksheet that has a pivot chart and pivottable.  When I export the new data into the original data cells that I used to originally make the pivot table, nothing in the pivot table or pivot chart updates.  Its like I need to fire a new command after I do this to excel like a Recalculate or something.

[Harold_Timmis]

couldn't you use the macro example and just type in a macro to make a new pivot table each time you program is run?