May 05 2021 12:22 AM
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 ?
May 05 2021 04:40 AM
Are you sure you have any data loaded to data model?
May 05 2021 07:59 PM
May 06 2021 03:22 AM
How do you connected to stock data, is that Power Query or what?
May 06 2021 08:42 AM
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.