How to refresh Excel file every second

Question

I have a list of stock prices pulled from Google finance and placed in different sheets in my Excel. I'm wondering, Can I refresh Excel sheet every SECOND (not minute) according to the Google finance stock price?

Answer 1

Data should be refreshed at regular intervals.
Select a cell in the external data range by clicking it.
Click Refresh All in the Connections group on the Data tab, then click Connection Properties.
Select the Usage tab from the drop-down menu.
Select the Refresh every check box, and then specify the time interval between refreshes in minutes.