excel thread is busy

[Graham]

I noticed today that while ba is refreshing fine, i am having real prblems with excel, any idea what could be causing this?

below is an example:

16:33:15:256: Excel updated.
16:33:15:443: Requesting Excel refresh. Origin cell:A1
16:33:15:646: Requesting Excel refresh. Origin cell:A1
16:33:15:646: Excel not updated. Update thread is busy.
16:33:15:880: Requesting Excel refresh. Origin cell:A1
16:33:15:880: Excel not updated. Update thread is busy.
16:33:16:21: Requesting Excel refresh. Origin cell:A1
16:33:16:21: Excel not updated. Update thread is busy.
16:33:16:348: Requesting Excel refresh. Origin cell:A1
16:33:16:348: Excel not updated. Update thread is busy.
16:33:16:645: Requesting Excel refresh. Origin cell:A1
16:33:16:645: Excel not updated. Update thread is busy.
16:33:16:847: Requesting Excel refresh. Origin cell:A1
16:33:16:847: Excel not updated. Update thread is busy.
16:33:17:35: Requesting Excel refresh. Origin cell:A1
16:33:17:50: Excel not updated. Update thread is busy.
16:33:17:222: Requesting Excel refresh. Origin cell:A1
16:33:17:222: Excel not updated. Update thread is busy.
16:33:17:471: Requesting Excel refresh. Origin cell:A1
16:33:17:471: Excel not updated. Update thread is busy.
16:33:17:659: Requesting Excel refresh. Origin cell:A1
16:33:17:659: Excel not updated. Update thread is busy.
16:33:17:893: Requesting Excel refresh. Origin cell:A1
16:33:17:893: Excel not updated. Update thread is busy.
16:33:18:33: Requesting Excel refresh. Origin cell:A1
16:33:18:33: Excel not updated. Update thread is busy.
16:33:18:392: Requesting Excel refresh. Origin cell:A1
16:33:18:392: Excel not updated. Update thread is busy.
16:33:18:704: Requesting Excel refresh. Origin cell:A1
16:33:18:704: Excel not updated. Update thread is busy.
16:33:18:844: Requesting Excel refresh. Origin cell:A1
16:33:18:844: Excel not updated. Update thread is busy.
16:33:19:63: Requesting Excel refresh. Origin cell:A1
16:33:19:63: Excel not updated. Update thread is busy.
16:33:19:265: Requesting Excel refresh. Origin cell:A1
16:33:19:265: Excel not updated. Update thread is busy.
16:33:19:468: Requesting Excel refresh. Origin cell:A1
16:33:19:468: Excel not updated. Update thread is busy.
16:33:19:671: Requesting Excel refresh. Origin cell:A1
16:33:19:671: Excel not updated. Update thread is busy.
16:33:19:874: Requesting Excel refresh. Origin cell:A1
16:33:19:874: Excel not updated. Update thread is busy.
16:33:20:217: Requesting Excel refresh. Origin cell:A1
16:33:20:217: Excel not updated. Update thread is busy.
16:33:20:513: Requesting Excel refresh. Origin cell:A1
16:33:20:513: Excel not updated. Update thread is busy.
16:33:20:685: Requesting Excel refresh. Origin cell:A1
16:33:20:685: Excel not updated. Update thread is busy.
16:33:20:919: Requesting Excel refresh. Origin cell:A1
16:33:20:919: Excel not updated. Update thread is busy.
16:33:21:137: Requesting Excel refresh. Origin cell:A1
16:33:21:137: Excel not updated. Update thread is busy.
16:33:21:309: Requesting Excel refresh. Origin cell:A1
16:33:21:309: Excel not updated. Update thread is busy.
16:33:21:496: Requesting Excel refresh. Origin cell:A1
16:33:21:496: Excel not updated. Update thread is busy.
16:33:21:746: Requesting Excel refresh. Origin cell:A1
16:33:21:746: Excel not updated. Update thread is busy.
16:33:21:949: Requesting Excel refresh. Origin cell:A1
16:33:21:949: Excel not updated. Update thread is busy.
16:33:22:73: Requesting Excel refresh. Origin cell:A1

[GaryRussell]

It cannot update Excel because Excel is busy.

Is your spreadsheet using VBA?

Is Excel using a large amount of CPU in task manager? If it is then maybe your VBA code is taking too long.

[Graham]

Thanks Gary, yes it is using vba, i was thinking that it could be a problem with my code, although strangely the problem is not persistent, it seems that everything starts ok, but problems only develop after market changes.

I noticed that cpu usage yesterday was as high as 40% in total, that was with three instances of BA open linked to about twenty workbooks, on a fairly powerful dual quad core machine.

I tried to replicate the problem this morning, to see if I could find out what was causing this, and strangely I encountered the following when I attempted to change market:

09:17:18:484: Requesting Excel refresh. Origin cell:A1
09:17:18:531: Excel updated.
09:30:16:835: Excel not updated. Requesting bets refresh. Last bets refreshed market does not match current market.

This seemed to have broken the excel link altogether. Could my VBA code be causing this? Is it possible that somehow my excel linking is somehow not operating correctly, would it be worth reinstalling betting assistant?

Thanks

Graham

[Graham]

Yes, it's my slow code, although if i run it on a machine with a fast internet connection it seems ok, although using a lot of cpu. Is it possible that a slowish connection could compound the problem?

Thanks

Graham

[GaryRussell]

Yes, it's my slow code, although if i run it on a machine with a fast internet connection it seems ok, although using a lot of cpu. Is it possible that a slowish connection could compound the problem?

Thanks

Graham

Is your code accessing the internet for external data?