In this article, we will discuss how to manage lose connections, refresh, and update results in Power Query queries and sheets in Excel (Mac version).
Prerequisites
To follow along with this article, you will need:
- Microsoft Excel (Mac version)
- Power Query add-in installed
Table of Contents
- Understanding Lose Connections
- Refreshing Queries
- Updating Results in Queries
- Managing Lose Connections in Sheets
1. Understanding Lose Connections
Lose connections occur when Power Query fails to maintain a connection to the data source. This can happen due to various reasons such as network issues, data source removal, or changes in the data source.
2. Refreshing Queries
To refresh a query, follow these steps:
- Go to the "Data" tab in the ribbon.
- Click on "Refresh All" to refresh all queries or select a specific query and click on "Refresh" to refresh only that query.
3. Updating Results in Queries
To update the results in a query, follow these steps:
- Select the query in the Power Query Editor.
- Go to the "Home" tab in the ribbon.
- Click on "Load To" and then select "Replace" to update the existing data in the destination or "Append Queries" to append new data to the existing data.
4. Managing Lose Connections in Sheets
To manage lose connections in sheets, follow these steps:
- Select the table in the worksheet.
- Go to the "Data" tab in the ribbon.
- Click on "Manage Connections" to view the connections for the selected table.
- If there are any lose connections, you can edit the connection or remove it from here.
References
- Microsoft Excel Help: Power Query
- Excel Easy: Power Query in Excel for Mac
- Power Query Tips: Managing Lose Connections in Power Query