Clock / Time not updating

[excelhasey]

Not sure if this is connected to my previous issue but the time in cells C2 & D2 on Sheet 1 of my worksheet (standard trigger worksheet) only updates every 20 / 25 seconds .......................... What is causing this behavior ???

Getting pee'd now

[mak]

check the refresh rate in cell q2
otherwise there is something wrong with your xlsheet or internet connection
try to log to a blank xl sheet

[excelhasey]

My spreadsheet is blank in Q2 - I think it always has been - Why what do you think it should say ??

I have VBA to record data every 1 second but it only manages to populate every 20 secs at the moment (if I am lucky) and i am not sure why, it used to be ok

[mak]

q2 cell sets the refresh rate in BA GRID. So if you. need 1 sec place in q2 cell 1... Also you should check the help file regarding the refresh rate in general