Properties - This is only enabled when you select a cell that has been populated using an external connection.Įdit Links - Displays the 'Edit Links' dialog box. Data connections are links to data sources outside of this workbook.

Queries & Connections - Displays the 'Workbook Connections' dialog box. The drop down includes the commands: Refresh, Refresh Status, Cancel Refresh and Connection Properties. The button updates all the information in the active workbook coming in from external sources. Recent Sources - Manage and connect to recent sources.Įxisting Connections - Import data from common sources. If the selected range is not part of a table, it will be converted into a table automatically. The drop-down includes the commands: From File, From Database, From Azure, From Online Services (New), From Other Sources, Combine Queries, Launch Query Editor (New), Data Source Settings and Query Options.įrom Text/CSV - Import data from a text, comma-separated file or a text file with a space delimiter.įrom Table/Range - Create a new query linked to an Excel table or named range. Discover, connect and combine data from multiple sources. Link - /en-us/office/unified-get-transform-experience-ad78befd-eb1c-4ea7-a55d-79d1d67cf9b3 Not to be confused with Power BI which is a standalone business analytics application for creating interactive visualisations and reporting. This is a built-in feature for creating data sources, making connections and shaping and transforming your data.

Disable excel queries and connections