hi, i have a sheet that displays and uses web data. if i use auto refresh, the 'external data range properties' only gives the option to auto refresh in minutes. how would i be able to get an auto refresh every second (or even less if possible!!)

thanks, jamie

(by the way, i cant get to grips with macros yet, so if this is the solution, please be basic in your answer if possible!!)