Excel 365: Stock Quote

https://support.microsoft.com/en-us/...0-623cf07fbc54

I did exactly as the above link shows (today). For stock price, I know it is not live quote, there is delay. For Google sheet, there is also delay. Delay (20 minutes or 30 minutes) is not an issue for me.

But the issue for excel is: it seems the data will not update unless you manually click Refresh button. For google sheet, I guess there is no such issue (no refresh is needed).

Question: Is it true that stock price will not automatically updated? Or is there any setting I can do to fix it?

Thanks.

Originally Posted by alansidman

Look at this link. https://www.michael-saunders.com/sto...ages/info.html

Then set the Connections to refresh every x minutes. The Connections is on the Data Tab

Thanks for the information.