QlikOCX HELP!!

[#1]

Hi,

I have a QlikOCX control in a excel showing a bar chart.

How do I refresh the control's data in sync with the qvw without closing and opening the excel.

Is there any macro function to do it?

Thanks,

Prabhu