Refresh rate in Excel

[vanbuuts]

Hi, can anyone advise if / how I can change the frequency of the data updating into Excel linked files? Mine currently updates about every 30 seconds

[mak]

In grid interface you should adapt the arrows next to 30
You can adapt it permanently through the options menu - general tab
In excel you should change the value at cell q2

[vanbuuts]

Hello Mark, many thanks - so I can manually change cell q2 in Excel? Currently q2 just says "Refresh rate:" and there is no value there

[Captain Sensible]

You just stick the value in Q2 in seconds from 0.2 to a max of 1000(I think) . The other special Q2 triggers have a minus sign in front so BA can distinguish between say -8 delete a market and 8 can refresh to 8 seconds.

[vanbuuts]

Thank you