[SOLVED] How do i refresh external data import in excel in seconds

[Bala]

I am inporting external data (market securities data) from website. The
"external data range properties" has a tab to auto-update the data in
minutes. But I want to update the data in seconds (may be two or three
seconds once). Please advise me, how do I do this?

[darkwood]

Unfortunately, you are at the mercy of the refresh rate of the external data source.

[Bala]

I asked the question given that the external data source is refreshed more
frequently than a minute. Please help.

"darkwood" wrote:

>
> Unfortunately, you are at the mercy of the refresh rate of the external
> data source.
>
>
> --
> darkwood
> ------------------------------------------------------------------------
> darkwood's Profile: http://www.excelforum.com/member.php...o&userid=29948
> View this thread: http://www.excelforum.com/showthread...hreadid=496112
>
>