Small excel black out

[alrodopial]

What I say below is not 100% certain - needs further checks- but here it is.

With 0.2 refreshes and logging the data at every refresh I notice a gap of around 2 secs at updating excel which happens when I submit the bet (from excel = back-f2) .After around 2 sec it starts logging again and after another 1 sec excel gets from BA the "status of my just placed bet" (matched or cancelled). In play bet with 1 sec delay.
It may be my VBA code that causes this gap?Note that at this 2 secs another sheet in the same workbook logs the data correctly (other market)
How can I check it?

[Captain Sensible]

Are these bets inplay/under minimum stakes?

[Captain Sensible]

k just noticed they're inplay, probably due to BA waiting for the bet response from betfair before continuing. If it didn't wait to get the response with betid/matched status etc it could fire off allsorts of duplicate bets etc

[alrodopial]

They are above minimum stake.
So no data are being sent to excel when a bet is pending?

[alrodopial]

Now that I'm thinking it again if there is "pending" at the bet reff column there is no need for further bets/ duplicate etc.
Lets wait Garry for his answer.

[GaryRussell]

BA does not write data to Excel while a bet is pending. Sorry, this has always been the case.