Connection Properties Disabled

Question

I am new to Office 365. I have opened Excel,&nbsp; Under Data,&nbsp; there&nbsp; is&nbsp; a&nbsp; button - Connection properties. This&nbsp; is&nbsp; disabled.&nbsp; &nbsp;In my&nbsp; earlier Excel 2010, I&nbsp; had&nbsp; set&nbsp; &nbsp;refresh every 5 minutes.In&nbsp; this&nbsp; case&nbsp; of&nbsp; Office 365, why&nbsp; is&nbsp; &nbsp;the&nbsp; connection properties&nbsp; disabled ?&nbsp; How&nbsp; to&nbsp; Enable&nbsp; it ?&nbsp;

sergeibaklan · Answer

kiranca22&nbsp;
Are you sure you have any data loaded to data model?

kiranca22 · Answer

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.

sergeibaklan · Answer

kiranca22&nbsp;
How do you connected to stock data, is that Power Query or what?

kiranca22 · Answer

Office 365 has an Icon called STOCKS.

sergeibaklan · Answer

kiranca22&nbsp;
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.&nbsp; Thus autorefresh if only with VBA.
&nbsp;

Forum Discussion

Connection Properties Disabled

5 Replies