How do i refresh external data import in excel in seconds

B

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?
 
D

darkwood

Unfortunately, you are at the mercy of the refresh rate of the externa
data source
 
B

Bala

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel external data range failed to refresh - second try 1
excel external data range "failed to refresh" 0
import external data as a List (not table) into excel 2010 with excel 2000-2003 list format 0
How do I save external data in Excel? 3
How do I clear a form? 0
Problem with Refresh all external data 0
External Data Toolbar permanently greyed out. 7
Connection/Refresh Control unavailable for imported XML data 0

Top