Microsoft excel is waiting for another application to complete an


K

kryali

I have excel add-in(VB.net code) that starts an Excel(2007) Application and
creates copies of an original workbook. The original workbook is having
multiple sheets with multiple pivot tables from an OLAP source. The vb.net
code goes to every sheet and every pivot to refresh the data based on new
filters. The refresh time is large and excel throws a message every now and
then “Microsoft excel is waiting for another application to complete an OLE
actionâ€. I have to click OK on this manually for the automation code to run
smoothly. Is there a way I can eliminate this message and programmatically
resolves this? I have the code running on windows server 2003. The Visual
studio version is Visual studio 2008. Any help will be great.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top