Forum Discussion
Connection Properties Disabled
I am new to Office 365. I have opened Excel, Under Data, there is a button - Connection properties. This is disabled. In my earlier Excel 2010, I had set refresh every 5 minutes. In t...
Are you sure you have any data loaded to data model?
- Yes.. All are the Stock data prices.
As of now I have written a macro to refresh every 5 minutes.
Still it would be of great help if someone assist with this issue.- Office 365 has an Icon called STOCKS.
Linked data types as STOCKS do not create connections you may configure, at least from user interface. And they don't load any data to data model, thus "Properties" are disabled. Thus autorefresh if only with VBA.
How do you connected to stock data, is that Power Query or what?
