Forum Discussion
Community Question - How have you been using the new Stocks and Geography Data Types?
How have you been using the new http://aka.ms/stockgeoXL in Excel? Since the new Stocks and Geography data types in Excel have been available to Insiders for a little while now, we want to hear from ...
Hi Utpaal,
You are correct that you are only able to update the values manually via Data > Refersh at this time. However you can write a macro to refresh automatically using the existing RefreshAll command.
If we were to add an ability to refresh automatically in the future, can you share how you would like it to work? Some things to consider would be the interval at which we refresh and how you would like to switch back to manual refresh, and whether that needs to apply to everything or just some stocks.
Thanks for your feedback!
James
You are correct that you are only able to update the values manually via Data > Refersh at this time. However you can write a macro to refresh automatically using the existing RefreshAll command.
If we were to add an ability to refresh automatically in the future, can you share how you would like it to work? Some things to consider would be the interval at which we refresh and how you would like to switch back to manual refresh, and whether that needs to apply to everything or just some stocks.
Thanks for your feedback!
James
Hello James , The stock prices are required to be refreshed manually and understand I can auto refresh thru connection properties and also able to select time interval. However , the properties in data is not active.
I read the following in Help ..
((Refresh every n minutes Select this check box to enable automatic external data refresh at regular
time intervals, and then enter the number of minutes between each refresh operation. Clear this check
box to disable automatic external data refresh.))
However , the properties link is inactive.AutoRefresh issue