Connection Properties Disabled

%3CLINGO-SUB%20id%3D%22lingo-sub-2325017%22%20slang%3D%22en-US%22%3EConnection%20Properties%20Disabled%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2325017%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20new%20to%20Office%20365.%20I%20have%20opened%20Excel%2C%26nbsp%3B%20Under%20Data%2C%26nbsp%3B%20there%26nbsp%3B%20is%26nbsp%3B%20a%26nbsp%3B%20button%20-%20Connection%20properties.%20This%26nbsp%3B%20is%26nbsp%3B%20disabled.%26nbsp%3B%20%26nbsp%3BIn%20my%26nbsp%3B%20earlier%20Excel%202010%2C%20I%26nbsp%3B%20had%26nbsp%3B%20set%26nbsp%3B%20%26nbsp%3Brefresh%20every%205%20minutes.%3C%2FP%3E%3CP%3EIn%26nbsp%3B%20this%26nbsp%3B%20case%26nbsp%3B%20of%26nbsp%3B%20Office%20365%2C%20why%26nbsp%3B%20is%26nbsp%3B%20%26nbsp%3Bthe%26nbsp%3B%20connection%20properties%26nbsp%3B%20disabled%20%3F%26nbsp%3B%20How%26nbsp%3B%20to%26nbsp%3B%20Enable%26nbsp%3B%20it%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2325017%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2325969%22%20slang%3D%22en-US%22%3ERe%3A%20Connection%20Properties%20Disabled%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2325969%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1045426%22%20target%3D%22_blank%22%3E%40kiranca22%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAre%20you%20sure%20you%20have%20any%20data%20loaded%20to%20data%20model%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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  this  case  of  Office 365, why  is   the  connection properties  disabled ?  How  to  Enable  it ?

 

5 Replies

@kiranca22 

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.

@kiranca22 

How do you connected to stock data, is that Power Query or what?

Office 365 has an Icon called STOCKS.

@kiranca22 

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.