DanielMag

Hi.

I need some advise with a little problem with my VSTO application.

I have a excel document with a listobject. This listobject is bind with a datatable, that it's filled with a sqlcommand from my codebehind. This work very well, but when the user navigate through the listobjects' headers in the excel document, the excel process (excel.exe) sometimes it uses 50% - 90% cpu time for a minute aprox.

I look for a codebehind event that produce this behavior, but nothing. So i think that is some process within excel.exe. I think that i need deactive some feature in excel, but no difference.

someone have any idea for this. I appreciate some ideas



Re: Visual Studio Tools for Office Excel 2003 and ListObjects (VSTO 2005)

colbert

Hi DanielMag,

Do you mean that your program stops or runs slowly when navigating through the listobjects' header

And how much data in your sqlDB bound to the listobjects

Thanks






Re: Visual Studio Tools for Office Excel 2003 and ListObjects (VSTO 2005)

DanielMag

Yeah, the program runs slowly when navigating through the listobjects' header. Aprox there are between 3000 and 4000 rows, and each row has 13 fields. I find a way to improve the navigation through. But i need to disconnect the listobject from the datasource. But doing this, i can't save changes done by the user, on the data (insert, updates o delete).





Re: Visual Studio Tools for Office Excel 2003 and ListObjects (VSTO 2005)

Nikhil Khandelwal - MSFT

Hi Daniel,

What version of VSTO runtime are you using (VSTO SE ) Did you get a chance to run it in the VS perf profiler to have a look at what's taking the chunk of the time.

Is it possible you can share out your solution/or at least part of the code that performs the databinding I can have a look at it.

Thanks,

Nikhil






Re: Visual Studio Tools for Office Excel 2003 and ListObjects (VSTO 2005)

Nikhil Khandelwal - MSFT

Since there has been no response on this thread for a while, I will assume that the problem has been solved. I will close the thread now.