Load Market Problem

[Shaun]

Hi,

In BA i have the quickpick list set to load the next market with 2 minutes until the off, problem is it loads it in BA but on my excel sheet it is about 45 seconds later before it updates.

In cell Q2 i have 0.5

How can i get my excel sheet to refresh more often.

[GaryRussell]

Are you saying each and every refresh takes 45 seconds or just the initial refresh when the market is first selected? What is the refresh rate in BA before the market is selected, 0.5 seconds?

Is there some VBA on your spreadsheet that takes time to run when the market is changed? Do you have the same problem if you use a blank worksheet? This would prove it isn't BA causing the problem.

[Shaun]

I don't think it is BA because the market loads at it should but it takes up to a minute before excels sees this, once the market is loaded the refreshes are fine.

Might be something in the excel i have i will remove al VB codes and see what happens.

[Shaun]

Sorry about that i found the problem, i was playing with some code yesterday and forgot to remove it thats why it was waiting untill just before a minute to load........ny bad