Hi all,
I have made a test with VSTO Excel databinding using listobject binded with
a dataview. This dataview/datatable is created by my code and upadated in
memory when I receive some notification via my mesage oriented middleware,
to simulate update of some financial market data (esample: update quotation
of stock equity). I have only 10 rows with 3 colums updaded with a frequency
of 200 ms.

My porpouse is to view data update in excel cells. So, after setting
datasource of a listobject, i can't call disconnect, elsewhere the data
isn't more updated. Well, when I have the bind setted (list1.datasource =
mydataview), excel isnt' more usable , consuming 50% of my CPU (P4 2,3GZ
1GBMemory), When I disable the bind, although my "engine" continue to update
memory datatable, the CPU became completly free and Excel Application occupe
max 1% CPU time. My idea is that listobject binding is wide CPU time
expansive, and I havent' idea how set about  binding propriety or what are
the alternative method to reach my goal. Seem me very strange the difference
between performance when binding is active respect when is disable
(list1.datasource = null).
Note that I have already bind my dataview to another object that support
binding (Devexpress XtraGrid control) without big performance problem.

Maybe, aren't  the object model of excel (COM based and used in .Net via
Interop), and listobject control that use it, suitable for display frequenty
update of a memory.Net datatable?

Can someone give me a suggestion to resolve my problems (binding settings,
or note on other possible my mistake) or an alternative to reach my goal?

Thanks in advance for the answers.

Gianni